You want to know how much pain you are going to inflict on the server and network before you run that ad hoc query? An explain plan can give you an idea of how long it might take to run, and tell you how much data it thinks will be involved. Cardinality – Fancy Word, [...]
Plan
Are You Illiterate?
I know you can read, you’re here. But maybe you’re a functioning illiterate. Here’s what I mean. You spend a lot of time in the database writing queries, analyzing data, doing important stuff. Most of the time, things go great for you. You can answer questions for people. You make things happen. The wheels of [...]
SQL Server VS Oracle: Index Monitoring
Jealousy is not an emotion I generally feel for the SQL Server technology stack. I covet their Twitter camaraderie, but I ‘know’ that Oracle can counter just about anything thrown at it. People that Helped Me with this Post I was reminded that even old dogs can be taught new tricks while monitoring the #SQLSaturday [...]
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 [...]
Who Owns Performance in the Database?
Many moons ago, this was a pretty straightforward question. It also had a very easy answer, the DBA owned performance. By that I mean if the database or it’s applications did not perform as expected, it was the DBA who would step in and fix it. Several years ago this began to change. More and [...]
1 2
Twitter
RSS
GooglePlus
Facebook