Monthly Archives: April 2014

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 →

I did a quick survey of the latest PeopleSoft manuals to find a set of links to pass on to a couple of coworkers of mine that are interested in doing PeopleSoft DBA work so I thought I’d include the … Continue reading →

I’m still studying for my Oracle 12c OCP exam and I was trying to run a simple example of using SQL*Loader Express and the first thing I did blew up and I think it is a bug.  When I load … Continue reading →

I was trying to recreate the scenario where a 12c container database is flashed back to a SCN before the point that I recovered a pluggable database to using point in time recovery. I got this ugly ORA-00600: RMAN> recover … Continue reading →

I got the newly available Kaplan test prep software for the Oracle 12c OCP upgrade exam. I took the test in certification mode when I was tired at the end of the day some day last week and got 44% … Continue reading →

Here is a zip of two examples I built as I’m learning about the new adaptive plans features of Oracle 12c: zip The first example has the optimizer underestimate the number of rows and the adaptive plans feature switches the … Continue reading →