(Jagruti Jasleniya) Recovery Manager(RMAN) is an Oracle Database client that performs backup and recovery tasks on your databases and automates administration of your backup strategies.

(Michael McLaughlin) This answers “How you connect PHP programs to an Oracle 12c multitenant database. This shows you how to connect your PHP programs to a user-defined Container Database (CDB) and Pluggable Database (PDB).

(Jeff Moss) I was trying to use DBMS_COMPRESSION on an 11gR2 (11.2.0.4 on RHEL 6.3) database the other day and was helped by this article from Neil Johnson. I was having some trouble with permissions until I read that article which nicely summarises everything you need to know – thanks Neil!

(Michael McLaughlin) While trying to explain a student question about Oracle object types, it seemed necessary to show how to write a dependency tree. I did some poking around and found there wasn’t a convenient script at hand. So, I decided to write one.

(Christian Antognini) You can use the V$SQL.IS_RESOLVED_ADAPTIVE_PLAN column to know whether the execution plan associated to a child cursor is adaptive or not.

(Sayan Malakshinov) When “serveroutput” is enabled, SQL*Plus executes “BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;” after each command.

(David Fitzjarrell) In earlier versions of the Listener, Oracle has been more forgiving with static registrations; with 12.2 that seems to have changed as static registrations, if not configured completely, can cause the listener to dump a core file in the directory where the listener process was st

(Christian Antognini) At the beginning of December, at the UKOUG Tech17 conference in Birmingham (GB), I presented a comparison of the query optimizers of MySQL 8.0.3 and PostgreSQL 10.1.

(Dimitri Gielis) If you didn’t hear about Oracle Quick SQL, it’s time to read about it as it’s something you have without knowing (it’s a packaged app in Oracle APEX) and I believe you should start using 🙂

(Scott Wesley) Imagine, if you will, a really large application. Perhaps it’s a reporting application, and you’ve just created a new page (report) and an associated breadcrumb.