Category Archives: Uncategorized

A coworker of mine cleaned up a bunch of old data to improve performance on an older system of ours and one of the queries started running slower.  It looks like the optimizer was choosing a full table scan when … Continue reading →

Participated in a long forum thread that I started with this title: SS Enqueue and sort segment request waits on 8.1.7.4 after trying to drop temp tablespace We have had quite the saga on an old 8.1.7 database.  Really, it … Continue reading →

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 →

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 →

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 →

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 →

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 →

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 →

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

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 →