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 have worked in the Information Technology field since 1989. I have a passion for Oracle database performance tuning because I enjoy challenging technical problems that require an understanding of computer science. I enjoy communicating with people about my work.

Bug 13930580 Workaround Effective

We put the workaround for Bug 13930580 in on Friday and the results have been much better than I expected.  Here is when the workaround went in as reported in the alert log: Fri Jan 17 18:38:26 2014 ALTER SYSTEM … Continue reading

Posted in Uncategorized | Leave a comment

Getting started with 12c

Back in July I finally got Oracle 12c installed on my laptop as documented in this post: url But, that was as far as I got.  The last thing I did was get an error message creating a user.  Well, … Continue reading

Posted in Uncategorized | Leave a comment

Adaptive Optimization Limitation Example

I’ve been reading up on Oracle 12c to get certified and to help advise my company on potential uses for the new version.  I’ve been looking forward to researching the new Adaptive Optimization features because it makes so much sense … Continue reading

Posted in Uncategorized | 2 Comments

New Features Guide Highlights

I just finished reading the main section of the Oracle 12c New Features Guide.  I read pages 17-107 of the version I have – Section 1 titled “Oracle Database 12c Release 1 (12.1) New Features”.  I underlined and asterisked the … Continue reading

Posted in Uncategorized | Leave a comment

Bug 13930580 Example

It looks like we hit 13930580 on one of our systems and I wanted to put some example output showing log file sync times going above 10 milliseconds (10,000 microseconds) after the log writer switches to polling. Here is the … Continue reading

Posted in Uncategorized | 5 Comments

Delphix upgrade in twenty minutes

Just got off of a Webex with Delphix support.  They upgraded our Delphix server from version 3.0.3.1 to 3.2.5.1.  It took about twenty minutes.  Pretty nice compared to an Oracle database upgrade I think! The only thing that took some … Continue reading

Posted in Uncategorized | 3 Comments

Cool Picture of Instance/Database from 12c Concepts

I just think this is a cool picture of an Oracle 12c instance and database from Oracle’s 12c Concepts manual (not my own work): This is from the concepts manual found here: url – Bobby

Posted in Uncategorized | 2 Comments

Finished reading Oracle Core

Just finished reading the book by Jonathan Lewis titled “Oracle Core: Essential Internals for DBAs and Developers“.  I think I picked it up at the Collaborate 13 conference in Denver last April but haven’t had time (or taken the time) … Continue reading

Posted in Uncategorized | 3 Comments

Top Ten Posts So Far

Just for fun I’ve pasted in a table listing the top 10 most viewed posts on this blog as links and including total number views since this blog began in March 2012.  I based this on WordPress’s statistics so I’m … Continue reading

Posted in Uncategorized | Leave a comment

Exadata compression reduces row chaining > 255 columns

After I did my previous post on how adding a column to a table with more than 255 columns can cause a ton of row chaining the question came up about Exadata and the form of compression we use on … Continue reading

Posted in Uncategorized | 4 Comments