Category Archives: Uncategorized

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 →

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 →

Spent a good amount of time yesterday and today reading about auditing in Oracle 12c.  Can’t say I read every word, but I think it was worth reading the three chapters in the Security manual related to auditing: Chapter 21 … Continue reading →

A RMAN restore and recovery that I completed today answered a couple of questions that remained after the recovery that was the topic of my post from June.  Both today’s recovery and June’s involved a restore of a production database … Continue reading →