Category Archives: Uncategorized

We appear to be hitting this bug on our production Exadata RAC system: Bug 14383007 – Sort runs out of temp space in RAC even when temp space is available One particular job errors out with ORA-01652 errors on the … Continue reading →

I’ve been having issues for a long time now with an Exadata RAC database that has user reports experiencing library cache lock waits.  The challenge is to figure out what is holding the library cache locks that the queries are … Continue reading →

I wanted to find out if queries against a particular table were experiencing parse time during the week.  We had previously seen issues where queries on the table would be stuck parsing for tens of minutes before they started actually … Continue reading →

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 →