Category Archives: Uncategorized

I’m working on an 11.1.0.7 to 11.2.0.4 upgrade and found a handful of queries that run more than 3 times longer on 11.2.0.4 than 11.1.0.7. The data and optimizer statistics are very similar on the two test databases. I’m pretty … Continue reading →

Today I sped a query up by over 5 times by setting _small_table_threshold=1000000. Here is the query elapsed time and a piece of the plan showing its behavior before setting the parameter: Elapsed: 00:28:41.67 —————————————————————————————————————————————————————————- | Id | Operation | Name … Continue reading →

I just got my bobbydurrettdba.com blog back online. It seems that an automatic update of Jetpack to version 4.8 took it down last night. I thought I would post a quick comment on how I resolved it because it is … Continue reading →

My company, US Foods, has posted a number of information technology jobs that are in Chicago (Rosemont)  or Phoenix (Tempe). Here is the web site: https://www.usfoods.com/careers.html IT jobs are under the “Technical” category. Bobby

I’m working on upgrading a very buggy unpatched 11.1.0.7 Oracle database to a fully patched 11.2.0.4 version. I’m using Delphix to support the upgrade and it has been a big help so far. This is on the HP-UX 11.31 Itanium platform. … Continue reading →

I ran across a stackoverflow question and it gave me an idea for a simpler use of Python to graph some Oracle database performance information. I looked at my PythonDBAGraphs scripts and I’m not sure that it is worth modifying … Continue reading →

I have experimented with the Rosetta Code website as a way to learn more about computer technology. I have mentioned my exploration of the edX and OCW web sites in earlier posts so I thought I would mention Rosetta Code or … Continue reading →

The next Arizona Oracle User Group meeting is January 26th in Scottsdale. Signup on this meetup link. Copied from invitation: When:  January 26, 2017 (Thursday) 12:30 pm – 4:00 pm Where:  Republic Services 1st Floor Training Rooms 14400 N 87th … Continue reading →

Before I left for vacation I noticed this blog post about setting up a network on VirtualBox: “CREATING A TEST LAB USING VIRTUALBOX / NAT NETWORKING”(DOES NOT EXIST). Now that I am back in the office I thought I would … Continue reading →

Delphix is sponsoring a user webinar on Wednesday from 10 to 11 am California time. I and a couple of other technical Delphix users will take part in a panel discussion. The webinar will give you a good chance to hear about other users’ experience … Continue reading →