ThatJeffSmith

Tag: Tuning

Explain Plan and Autotrace Enhancements in Oracle SQL Developer 4

“Explain Plans are useless.” Yikes. Really? Don’t we spend all day looking at execution plans? To clarify, I would say that explain plans could be useless. If you do an Explain, you’re actually looking at a theoretical plan, not the ‘actual’ plan. From the docs: With the query optimizer, execution plans can and do change [...]

Quick Tip – Comparing Explain Plans with SQL Developer

SQL optimization and tuning is fun for a lot of folks. For others it’s a affirmation that the database is ‘magic.’ I fall somewhere in the middle. No matter where you find yourself on that spectrum however, it’s pretty safe to assume that at some point you will look at an execution plan for insight [...]

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 [...]

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 [...]

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. Ever heard of Angry Birds? In this mobile [...]

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. Many of the customers I speak with are unaware of a new 11g [...]

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 [...]

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 [...]