Author Archives: Bobby

I have this test script I use to remind myself of the fastest way I’ve found to copy data into an Oracle table.  It shows three things: Fast way to create a new table populating with data Fast way to … Continue reading →

Click here for a simple but useful script that shows how the execution of a given query has changed over time. (current version). This script just queries DBA_HIST_SQLSTAT for a given sql_id. A sql_id corresponds to a single SQL query.  … Continue reading →

I use this script all the time to get the plans for a given SQL statement I’ve identified from an AWR report: getplans.sql Recently I’ve found out that you can do something like this with the delivered awr script $ORACLE_HOME/rdbms/admin/awrsqrpt.sql … Continue reading →

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 →