Author Archives: Bobby

One of my coworkers asked a really good question: “Where is the documentation that explains all the sections of the AWR report?” The answer is that there is no comprehensive section-by-section documentation of an AWR report. But, there is a … Continue reading →

I couldn’t help notice the Oracle product placement in The Avengers movie as I watched it for the second time in two weeks with my eleven year old daughter.  I was wondering what sort of systems they were supposed to … Continue reading →

I’ve updated the “Resources” page on my blog to include all my old presentation, papers, and scripts that I’ve published before.  I used to have a free Geocities blog but that disappeared.  I’ve been waiting to see if this new … Continue reading →

I’ve done an update on my introduction to SQL tuning paper. Updated paper as of 05/29/2012 Example SQL script and its log – in zip with paper I’ve added cardinality hint and breakup of a SQL query into smaller pieces … Continue reading →

I updated my very generic “about” page on my blog. Check it out and get to know me and my blog better: https://www.bobbydurrettdba.com/about/ – Bobby

Submitted two talks to the East Cost Oracle Users Conference: http://www.eastcoastoracle.org/ssl/presentations.asp – NO LONGER EXISTS First one is my Exadata talk that I gave at work.  Second is new Intro to SQL Tuning talk I’m preparing for my coworkers.  I … Continue reading →

I’m working on a paper titled “Introduction to SQL Tuning”.  I’d like to have this be the start of a training program at work for DBAs and developers.  I’ve completed a draft of a paper on this topic.  If anyone … Continue reading →

We are having challenges with queries that spend most of their time on these waits: enq: TS – contention This wait indicates that a query on one instance of a RAC system is causing its instance to add temp space … Continue reading →

I thought it might be helpful to show what sar -d returns during a disk issue.  Sorry, I only have a screenshot I took during the problem.  Click on the smaller image to see the full size jpeg. This was a … Continue reading →

Worked on the scripts in this zip today: https://www.bobbydurrettdba.com/uploads/sessionprofiledbahist.zip I wanted to see a session profile from the DBA_HIST_ACTIVE_SESS_HISTORY view.  My idea was to include the time the session was inactive as well as the time it was waiting on an event or … Continue reading →