Monthly Archives: June 2014

Sam Alapati’s 12c OCP upgrade book includes test software with key DBA skills

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

Posted in Uncategorized | 2 Comments

Bought Matthew Morris’ OCP 12c upgrade book for Key DBA Skills section

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

Posted in Uncategorized | 14 Comments

Limits of SQL Optimization Toastmasters Talk

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

Posted in Uncategorized | Leave a comment

Adding an outline hint to a PS/Query

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

Posted in Uncategorized | 3 Comments

v$sql_cs_statistics bug in 12c?

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

Posted in Uncategorized | 2 Comments