Category Archives: Uncategorized

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 →

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 →