Author Archives: Bobby

I’m trying to compare two types of database servers and it looks like one has a faster CPU than the other.  But, the benchmark I have used runs a complicated variety of SQL so it is hard to really pin … Continue reading →

I need to change a view and an index on an active production system.  I’m concerned that the change will fail with a “ORA-00054: resource busy” error because I’m changing things that are in use.  I engaged in a twitter … Continue reading →

I’m trying to compare how a query runs on two different 11.2.0.3 systems.  One runs on HP-UX Itanium and one runs on 64 bit x86 Linux.  Same query, same plan, different hash value. HP-UX: SQL_ID 0kkhhb2w93cx0 ——————– update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,exts … Continue reading →

I started using sar -d to look at disk performance on a Linux system this week and had to look up what some of the returned numbers meant.  I’ve used sar -d on HP Unix but the format is different. … Continue reading →

I was preparing for my weekend patch of our Exadata system and I needed to back up all of our Oracle homes and inventories on our production system.  On our 2 node dev and qa clusters I just ran the backups … Continue reading →

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 →

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 →

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 →

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 →

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. 🙂