Oracle’s SQL Tuning Advisor and SQL Developer

thatjeffsmith SQL Developer 4 Comments

If you have the Tuning Pack licensed, a couple of things become available for you in SQL Developer: SQL Tuning Advisor Real Time SQL Monitoring If you DO NOT have this pack licensed, then you can disable these features in the SQL Developer UI via the preferences: Semi-Rant: consider giving your developers access to this feature in their development and …

Why Is My SQL Slow & Go Faster Features

thatjeffsmith SQL Developer 19 Comments

Yesterday I made my first presentation ever at the annual Hotsos conference. The topic: “All of the Performance Tuning Features in SQL Developer.” It went pretty well, and I’d like to share those slides now with y’all: Tuning & Diagnostics Features in Oracle SQL Developer from Jeff Smith Easier to Read Autotrace Execution Plans Apparently I said ‘explain plan’ too …

Real Time SQL Monitoring Support in Oracle SQL Developer [Video]

thatjeffsmith SQL Developer 5 Comments

I had a pretty good week of presenting at Open World this week. 3 solo presentations, all well attended. But in one, I had a technical issue – that’s code for I was having problems because I was using the wrong database connection – when trying to show off the Real Time SQL Monitoring support feature in Oracle SQL Developer. …

Explain Plan and Autotrace Enhancements in Oracle SQL Developer 4

thatjeffsmith SQL Developer 41 Comments

“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 as the underlying optimizer inputs …

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

thatjeffsmith SQL Developer 4 Comments

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 or too lazy to …

My Oracle is broken, can you fix it?

thatjeffsmith Database Stuff 1 Comment

“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 performance problem, …

SQL_IDs, Plans, and Baselines, Oh My!

thatjeffsmith Database Stuff 1 Comment

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 feature called ‘SQL Plan Management’ …

Is Your Query Running?

thatjeffsmith Database Stuff 4 Comments

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 will finish executing. …