Category Archives: Uncategorized

Loads of fun with DBA_HIST_OSSTAT

I saw a load of 44 on a node of our production Exadata and it worried me.  The AWR report looks like this: Host CPU Load Average CPUs Begin End %User %System %WIO %Idle —– ——— ——— ——— ——— ——— … Continue reading

Posted in Uncategorized | Leave a comment

Arizona Oracle User Group Meeting March 18

I just found out that this meeting was cancelled.  We will have to catch the next one. 🙂 – 3/16/2015 Sign up for the Arizona Oracle User Group (AZORA) meeting next week: signup url The email that I received from … Continue reading

Posted in Uncategorized | Leave a comment

Delphix User Group Presentation

My Delphix user group presentation went well today. 65 people attended.  It was great to have so much participation. Here are links to my PowerPoint slides and a recording of the WebEx: Slides: PowerPoint Recording: WebEx(NO LONGER EXISTS) Also, I … Continue reading

Posted in Uncategorized | 3 Comments

Blog third anniversary

My first blog post was March 5, 2012, three years ago today. I have enjoyed blogging.  Even though I am talking about topics related to my work blogging does not feel like work. The great thing about blogging is that … Continue reading

Posted in Uncategorized | Leave a comment

Joined twitter

I joined twitter.  I don’t really know how to use it.  I’m setup as Bobby Durrett, @bobbydurrettdba if that means anything to you. 🙂 – Bobby 4/27/21 I no longer tweet. 🙂

Posted in Uncategorized | 2 Comments

Different plan_hash_value same plan

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

Posted in Uncategorized | 6 Comments

Speaking at Delphix User Group Webex March 11

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

Posted in Uncategorized | 2 Comments

A new index on a small table makes a big difference

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

Posted in Uncategorized | 4 Comments

Long parse time with interval partitioning and subpartitions

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

Posted in Uncategorized | 5 Comments

Arizona User Group Meeting tomorrow

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

Posted in Uncategorized | Leave a comment