Author Archives: Bobby

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 →

I just finished working with a coworker on speeding up a PS/Query.  It was running well in a development environment but not in production.  I tried to find a simple hint or two to make production run like development but … Continue reading →

I think I’ve run across a bug in 12c where v$sql_cs_statistics is not populated in 12c as it was in 11.2.0.3. I’ve messed with adaptive cursor sharing using an example on Tim Hall’s web site: web example I’ve tried to … Continue reading →

I guess I should have waited around a bit longer before taking my 12c OCP upgrade exam.  I purchased Kaplan’s Self Test software to prepare for the 12c OCP upgrade exam but it only included 50 questions and they only … Continue reading →