Category Archives: Uncategorized

Finished reading the Snowflake database documentation

I just finished reading the Snowflake database documentation and I thought I would blog about my impressions. I have not spent a lot of time using Snowflake so I can not draw from experience with the product. But, I read all … Continue reading

Posted in Uncategorized | Leave a comment

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 | 5 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