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 by hand like this:
login as root
tar -cvf - dbhome_1 | gzip > dbhome_1-20150211.tgz
cp -r oraInventory oraInventory.20150211
But the production cluster has 12 nodes (more...)
I saw a load of 44 on a node of our production Exadata and it worried me. The AWR report looks like this:
CPUs Begin End %User %System %WIO %Idle
----- --------- --------- --------- --------- --------- ---------
16 10.66 44.73 68.3 4.3 0.0 26.8
So, why is the load average 44 and yet the CPU is 26% idle?
I started looking at ASH data and (more...)
Sign up for the Arizona Oracle User Group (AZORA) meeting next week: signup url
The email that I received from the meeting organizer described the topic of the meeting in this way:
“…the AZORA meetup on March 18, 2015 is going to talk about how a local business decided to upgrade their Oracle Application from 11i to R12 and give you a first hand account of what went well and what didn’t go so well. ”
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:
Also, I want to thank two Delphix employees, Ann Togasaki and Matthew Yeh. Ann did a great job of converting my text bullet points into a visually appealing PowerPoint. She also translated my hand drawn images into useful drawings. Matthew did an (more...)
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 it’s completely in my control. I control the content and the time-table. I pay a small amount each year for hosting and for the domain name, but the entertainment value alone is worth (more...)
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.
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 includes a system generated temporary segment like this:
| 1 | TEMP TABLE TRANSFORMATION | |
| 72 | TABLE ACCESS STORAGE FULL | SYS_TEMP_0FD9D668C_764DD84C |
For some reason the system generated temporary table (more...)
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.
Adam Leventhal, the Delphix CTO, will also be on the call previewing the new Delphix 4.2 features.
I will describe our experience with Delphix and the lessons we have learned. It is a technical talk so it should have enough details to have value to (more...)
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 I tried to figure out why they were slow. I reviewed an AWR report for the 24 hours when the reports were running and found a simple query against a tiny table at (more...)
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 to this bug:
- Interval partitioned table
- Partitioned by range
- Sub-partitioned by list
- Open ended range on partitioning column in where clause
- Tens of thousands of sub-partitions
Prior to applying the patch I did (more...)