Tag: DBA Lounge

Hadoop FAQ – But What About the DBAs?

Do DBAs have a role to play with Hadoop clusters? If so, what is that role and what skills they need to get there. I provide the answers to these questions in this post.

Read More >

The Easy Way of Finding Similar SQL Statements

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!

Read More >

Statement Toggler for Vim

Wouldn’t it be nice if there was a way to flip block and postfix statements with the ease of a single command? Well, I thought so, so I came up with a dirty little script, have a look.

Read More >

Are You Switching to BULK_LOGGED Recovery Model? Know Your Risks.

This post should give you some insights into the risk that your databases are in by switching to the bulk-logged recovery model. So, what do you need to do to avoid this risk? Make sure that you run a backup immediately after the transactions you are running under the bulk-logged recovery model complete.

Read More >

Set Up Exadata for Cloud Control 12.1.0.2

I recently helped setup an Exadata X2-8 Database Machine with the latest version of OEM Cloud Countrol (12.1.0.2). 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.

Read More >

Fit to Be Tied (Tied Handles and Localized $\)

This one was going to be a cry for help and a request to confirm that I’m not going cuckoo, but I think I figured it out. Still, for giggles, hear this:

Read More >

DBD::Oracle v1.54 on Its Way to CPAN

DBD::Oracle v1.54 is on its way to CPAN. In this iteration, no new feature, but a large amount of bug fixes.

Read More >

Reminiscence of 2012 and Forecast for 2013

It has come again. This magic time of the year when, in-between the hangovers of Christmas and the hangovers of the New Year bashes, one takes a longing look back at the ending year, and make mad plans, wistful wishes and grandiose resolutions for the new one. So, for a moment, let me indulge in this tradition and let my gaze wander at the distances that stretch forward and behind, while my mind drift back and forth betwixt what has been and what shall be. But gently. ‘Cause lemme tell you, that was damn good eggnog (so please be kind and don’t click so hard with the mouse, will you?).

Read More >

Git::CPAN::Patch — Now with MetaCPAN Power

What better way to start the year than to bring a fresh new breath to an old favorite? And thus, as you read this a new version of Git::CPAN::Patch should be making its way to CPAN. This new version is a massive refactoring of the module’s guts, which will affect both end-users and developers. For the best. Mostly. Or so I hope.

Read More >

Build an 11gR2 RAC Cluster in VirtualBox in 1 Hour Using OVM Templates

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.

Read More >
Page 10 of 60« First Page...89101112...20...Last Page »