(Randolf Geist) Prompted by a (not really that) recent discussion on the OTN forum I’ve decided to publish this note.

(mdinh) Admittedly, I did not realize the benefit at first until there came a need.

(Natik Ameen) Question: What is the cause of the error “ORA-00054 resource busy and acquire with NOWAIT specified or timeout expired”?

(ilmarkerm) Lately I’ve been upgrading our 11g Standard Edition databases in test environments to 12c Enterprise Edition and also plugging them in to a multitenant container database.

(Andrejus Baranovskis) ADF 12.2.1.1 brings improved support for programmatic VO creation.

(Dbaharrison) So i finally got round to attempting the upgrade from 12.1.0.5 to 13c, buoyed with the confidence of having done a fresh install on azure i had carefully planned by ‘real’ upgrade on our system monitoring 150 servers…….

(John Hallas) What is the difference between the summaries of disk space on these two systems? Look at the free_usable_file_MB column and free space

(connormcdonald) You would think that (with the exception of the V$ tables which are predominantly memory structures reflecting the state of various parts of the database instance) a query on a read-only standby database would have absolutely no interaction with the primary.

(Hemant K Chitale) If you need to view the source code of a stored program you need to either :

(Ben) The Oracle HEXTORAW function is a basic conversion function used in Oracle SQL. Learn how to use it and see some examples in this article.