Category Archives: Uncategorized

This graph represents commit time compared to CPU utilization and redo log write time.  I’ve included only the hourly intervals with more than 1,000,000 commits.  At these peaks the number of commits ranges 1 to 1.6 million commits per hour … Continue reading →

I am learning about how well commits scale on Oracle 11.2 and so far they seem to scale surprisingly well. I’ve looked at two waits – log file parallel write and log file sync.  Based on documents I’ve read on … Continue reading →

Well, I finally passed the Oracle Certified Professional (OCP) 12c upgrade exam, 1Z0-060.  I got 86% right on the new features section and 78% correct on the general DBA section.  So, that means I missed roughly 7 questions on each … Continue reading →

I came up with a simple query that shows a running SQL executing a different plan than what it had in the past.  Here is the query: — show currently executing sqls that have history — but who have never … Continue reading →

I did a quick check of some facts I’m studying about Oracle 12c and its new threaded execution mode.  I set this parameter: alter system set THREADED_EXECUTION=true scope=spfile; I had to connect SYS as SYSDBA with a password to get … Continue reading →

I just finished reading Sam Alapati’s 12c OCP upgrade book for the first time and I really like it because of the content that it covered which I hadn’t discovered through my study of the Oracle manuals.  Also, it did … Continue reading →

Yesterday I used Delphix to quickly recover ten production tables that had accidentally been emptied over the weekend.  We knew that at a certain time on Saturday the tables were fully populated and after that some batch processing wrecked them … Continue reading →

Sweet!  I just installed the software from the CD that came with Sam Alapati’s book related to the OCP 12c upgrade exam and found that it has questions related to the key DBA skills section of the test.  Now I … Continue reading →

I haven’t even started on Sam Alapati’s OCP book but I realized today that Matthew Morris’s OCP 12c upgrade book has an outline of the Key DBA Skills section of the OCP exam and that is what I need most.  … Continue reading →

I think I’m done with the script for my Toastmaster’s talk: pdf It’s Toastmaster’s talk 3 “Get to the Point” so I’m trying to do a 5-7 minute talk that focuses on how Oracle’s SQL optimizer sometimes chooses a slow … Continue reading →