As we all know proper use of bind variables in SQL statements is a must to make transaction processing applications scalable. So how do we find the queries that don’t use bind variables and have to be parsed each time they are executed? There is number of ways, but this article is all about the most effective way I know. If you have a better one – let me know please!
Following my “Building Integrated DWH with Oracle and Hadoop” webinar for IOUG Big Data SIG, I got a bunch of excellent follow up questions. The most frequently asked questions are: What is the minimum I need to do to get started with Hadoop? and How do I load data into Hadoop? Since so many people are interested in the same question, it makes more sense to answer on the blog.
Sky’s the limit for the database bloggers. They are producing awesome rants in Oracle, fabulous ramblings in MySQL, and fantastic views in SQL Server, and this Log Buffer Edition, very proudly covers all that in Log Buffer #303. Enjoy.
I recently helped setup an Exadata X2-8 Database Machine with the latest version of OEM Cloud Countrol (22.214.171.124). A few documents do exist for this process. However I found a few inconsistencies and problems; I think the existing documents I found were written on older versions of OEM and older versions of the tools. I’m publishing my final procedure here with hopes that it helps you, but as always please cross-reference this with the appropriate documentation before doing anything in your own environment.
There is no great joys for the bloggers to mark the holiday season with some blistering and lightweight blog posts. This Log Buffer Edition in Log Buffer #302 shares that mirth and presents you with another medley of blogs.
DBD::Oracle v1.54 is on its way to CPAN. In this iteration, no new feature, but a large amount of bug fixes.
This year’s last log buffer edition looks at the marvelous and splendid blog posts of Oracle, SQL Server and the MySQL databases which promise to bring more and more next year. This Log Buffer #301 promises to be the anchor for yet another action packed blogging carnival next year.
Shortly before we all went on break for the holiday, Oracle announced the new BDA X3-2. Now I have time to properly sit down with a glass of fine scotch and dig into the details of what is included in the release. Turns out that there are quite a few changes packed in. We are getting new hardware, new Hadoop, new Connectors and new NoSQL. Tons of awesome features are included. Let’s get into it.
In this post, I’ll demonstrate how to deploy the pre-built Oracle VM templates to create a two-node 11gR2 RAC cluster in Oracle VirtualBox.
If you are reading this, it means that world moves on and somebody somewhere was wrong in predicting the end of it. The ageless Log Buffer Edition presents you yet again some cool blog posts just before the holiday season to top up your excitement. This Log Buffer #300 is as sweet as the holidays and as sumptuous as Aussie BBQ. Enjoy