ORACLENERD!

On Real-Time SQL Monitoring and the /*+MONITOR*/ Hint

Oracle 11gR1 Enterprise Edition with the Diagnostic and Tuning packs has a very compelling new feature, Real-Time SQL Monitoring. Oracle thinks enough of the feature that it was highlighted prominently in whitepaper by ACE Directory Arup Nanda titled “Oracle Database 11g: The Top Features for DBAs and Developers” (read it here)

Long story short: Too late [...]

My Oracle is broken, can you fix it?

“Look for things that make them go!” – from ST:TNG, “Samaritan Snare” (Wiki)

I have a tendency to relate everything in life back to a Star Trek or South Park episode – it’s a personal problem and I’m currently in therapy, courtesy my DVR.

But back to Oracle…

How often have you been asked to help with a [...]

Angry Birds of Database Performance Tuning

Database developers and DBAs often play the role of gunslinger, or a hired gunman. Someone brought in to ‘kill’ the bad guy, in this case, an under-performing database. Our tools of the trade are not as dramatic as firearms, but we can do just as much damage.

Every heard of Angry Birds? In this mobile game, [...]

SQL_IDs, Plans, and Baselines, Oh My!

Do you run a 3rd party application that uses Oracle RDBMS under-the-hood? Do you experience performance issues? Frustrated that you do not own the application SQL that is causing the issues? Maybe an upcoming upgrade to 11g might give you some relief.

Somewhere, over the rainbow…lies 11g, unicorns, and databases that tune themselves.

Many of the [...]

Is Your Query Running?

You better run and catch it then!

You know you’re getting old when the new crop of kids don’t get this joke, or even worse, don’t understand what a prank phone call is.

I’m pretty sure that folks still get phone calls from frustrated people who want to know how much time is left before their query [...]

Enterprise Doesn’t Mean What You Think It Does

One of the most dangerous phrases to be uttered in an organization is ‘Oh, we have an Enterprise license.’ Once that gets out, everyone will think they can deploy/use as much as product X as they want. It does not take much of an imagination to realize where this can lead.

Standard VS Enterprise VS [...]

Introducing Toad for SQL Server Pt II

That’s right folks! Toad for SQL Server has been recognized AGAIN as the best development tool for SQL Server. In a previous post I talked about Toad’s IntelliSense and Group Execute features.

Skip back to Part I
Skip ahead to Part III

Let’s continue the conversation now with a quick introduction on our SQL Tuning feature.

SQL [...]

Related Posts Plugin for WordPress, Blogger...