Author Archives: Bobby

I mentioned this same effect in an earlier post about SQL profiles: link I get a different plan_hash_value values for a query each time I run an explain plan or run the query.  I see this in queries whose plan … Continue reading →

On March 11 at 10 am California time I will be speaking in a Delphix User Group Webex session. Here is the sign up url: WebEx sign up(NO LONGER EXISTS). Adam Leventhal, the Delphix CTO, will also be on the … Continue reading →

A few weeks back on the weekend just before I went on call we got a complaint about slowness on an important set of reports.  I worried that the slowness of these reports would continue during my support week so … Continue reading →

In an earlier post I described how some queries with long parse times were causing long library cache lock waits.  Friday I applied a patch from Oracle that resolved the long parse times.  Here are the conditions which may relate … Continue reading →

Here is the link: url It looks like our meeting tomorrow will be on Oracle 12c new features.  I’m looking forward to participating. 🙂 – Bobby

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 →