Author Archives: Bobby

About Bobby

I live in Chandler, Arizona with my wife and three daughters. I work for US Foods, the second largest food distribution company in the United States. I've been working as an Oracle database administrator and PeopleSoft administrator since 1994. I'm very interested in Oracle performance tuning.

Submitted two abstracts for Oracle OpenWorld 2017

I submitted two abstracts for Oracle OpenWorld 2017. I have two talks that I have thought of putting together: Python for the Oracle DBA Toastmasters for the Oracle DBA I want to do these talks because they describe two things that I … Continue reading

Posted in Uncategorized | 2 Comments

How to find the object that caused ORA-08103 error

A developer told me that two package executions died with ORA-08103 errors and he didn’t know which object caused the errors. I found two trace files that had the following contents: *** SESSION ID:(865.1201) 2017-04-17 10:17:09.476 OBJD MISMATCH typ=6, seg.obj=21058339, diskobj=21058934, … Continue reading

Posted in Uncategorized | Leave a comment

Optimizer bug fix makes a query run more than 3 times slower

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

Posted in Uncategorized | 3 Comments

_small_table_threshold=1000000 results in > 5x query speedup

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

Posted in Uncategorized | 2 Comments

Jetpack 4.8 outage

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

Posted in Uncategorized | 4 Comments

Information Technology Jobs Posted

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://usfood.taleo.net/careersection/usf_external/jobsearch.ftl Enter Information Technology as the Job Field to see all the posted IT jobs. Bobby

Posted in Uncategorized | Leave a comment

Using Delphix to support Oracle upgrade

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

Posted in Uncategorized | 2 Comments

Simple Python for Oracle database tuning example

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

Posted in Uncategorized | 8 Comments

Rosetta Code

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

Posted in Uncategorized | Leave a comment

AZORA Meeting January 26th

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

Posted in Uncategorized | Leave a comment