Making existing SQLPLUS Scripts 12c and Container DB (PDB) compatible May 26, 2015 Oracle 12c introduces new catalog features including CDB_ dictionary views (which include a CON_ID...
Recovering an Oracle Database with Missing Redo March 10, 2015 Background I ran into a situation where we needed to recover from an old online backup which (due...
Oracle Database 12c Patching: DBMS_QOPATCH, OPATCH_XML_INV, and datapatch January 20, 2015 Background Oracle Database 12c brings us many new features including: the long needed ability to...
Performance issues with the Sequence NEXTVAL call December 18, 2014 Is SELECTing from a sequence your Oracle Performance Problem? The answer to that question is: it...
The power of the Oracle Database Proxy authenticated connections October 27, 2014 We recently received this inquiry from a client: "C an an Oracle database account support two...