Category Archives: Uncategorized

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 →

I’m doing Toastmasters to try to improve my speaking and my third talk will be related to why a function on a web site can suddenly slow down due to a change in plan.  It has to be 5 to … Continue reading →

Over the weekend a coworker applied a SQL profile to a long running SQL statement but it looked like the profile was not applied.  For one thing, the SQL statement ran just as long after applying the profile.  Also, the … Continue reading →

Here are my rough screenshots from an install of 12c grid on a standalone Linux vm: pdf I’m running version 6 of Oracle’s Linux in a VMWare Player 4 gigabyte virtual machine on my Windows 7 laptop.  I ran into … Continue reading →

I’ve been learning about online table redefinition in Oracle 12c.  Here is a zip of some test scripts I built for my own understanding: zip I spent some time trying out DBMS_REDEFINITION on an 11.2 Exadata test system and then … Continue reading →

Quick post.  I’m messing with 12c again.  I finished recreating my cdb but this time found the option to create multiple pdbs on the initial creation.  I’m using DBCA. PDF with screenshots of me creating a cdb with two pdbs … Continue reading →

Last week I came across what seemed like a simple query tuning problem.  A PeopleSoft batch job ran for many hours and when I did an AWR report I found that the top query was doing a full scan when … Continue reading →

Well, I took the Oracle 12c OCP upgrade exam this morning and didn’t pass it.  I’ve spent many hours over the past weeks and months reading up on new 12c features and it wasn’t enough.  I also installed 12c databases … Continue reading →

I found this blog post about the Oracle 12c OCP exam useful: NO LONGER EXISTS In particular it explained why my Kaplan SelfTest software only covers the new 12c features and not general DBA skills section of the OCP exam. … Continue reading →