Author: Simon Pane

Oracle Database 12c Patching: DBMS_QOPATCH, OPATCH_XML_INV, and datapatch

Background Oracle Database 12c brings us many new features including: the long needed ability to run OPatch and query the patch software installed in the Oracle Home programatically through SQL using the new DBMS_QOPATCH package. If you’re a DBA working…

Read More >

Performance issues with the Sequence NEXTVAL call

Is SELECTing from a sequence your Oracle Performance Problem? The answer to that question is: it might be! You wouldn’t expect a sequence select to be a significant problem but recently we saw that it was—and in two different ways….

Read More >

The power of the Oracle Database Proxy authenticated connections

We recently received this inquiry from a client: “Can an Oracle database account support two passwords at once so we can roll out updated credentials to application servers gradually rather than having to change them all at the same time?…

Read More >
Page 3 of 3123