Category Archives: Uncategorized

This is my third of four posts about people who have made a major impact on my Oracle database performance tuning journey.  This post is about Cary Millsap.  The previous two were about Craig Shallahamer and Don Burleson. I am … Continue reading →

I will be talking at my daughter’s high school for career day on Monday, explaining my job as an Oracle Database Administrator.  Wish me luck! The funny thing is that no one understands what Oracle DBAs do, unless they are … Continue reading →

AZORA is planning a meeting January 20th.  Here is the link to RSVP: url Hope to see you there. 🙂 – Bobby

I am working on an SR with Oracle support and they asked me to do a 10128 trace to look at how the optimizer is doing partition pruning.  I did some quick research on this trace and wanted to pass … Continue reading →

I had a five-minute conversation with Oracle development Friday that rocked my world.  I found out that parsing blocks stats which blocks parsing. We have a system with queries that are taking minutes to parse.  These queries include the main … Continue reading →

I’ve uploaded a monitoring script that I have worked on: zip. The script alerts you when the optimizer runs a SQL statement with a potentially new and inefficient plan so you can intervene.  This script improves upon my earlier script … Continue reading →

I found a broken link to an Oracle help document in one of my posts and when I went to the Oracle 12c database documentation to find the new URL to put in my post I found that Oracle had … Continue reading →

Saw an interesting post related to work I am doing locking in plans and finding plans that have changed: Carlos Sierra post on queries with changing performance. Our DBA team uses versions of my sqlstat.sql(updated) script to find queries whose … Continue reading →

This is pretty simple, but I thought I would share it since it is helpful to me.  I have been preparing for a large migration which involves table, index, type, function, package, and procedure changes.  When I run a big … Continue reading →

Yesterday was the first meeting of the newly restarted Arizona Oracle User Group, AZORA.  It was a good first meeting to kick off what I hope will turn into an active club. We met in the Tempe Public Library in … Continue reading →