(Richard Foote) This come up recently with a customer and I saw a related question on OTN that made me realize I haven’t previously discussed the SKIP_UNUSABLE_INDEXES parameter.

(Jared Still) Perhaps you’ve wondered about this. What is the difference between taking an RMAN full backup and a level 0 incremental backup?

(Uwe Hesse) Less famous 12c New Feature: If you do Create Table As Select (CTAS) or a direct load into an empty table, we will automatically collect optimizer statistics:

(Andrejus Baranovskis) ADF 12.2.1 provides out of the box support for REST. You should read about all available REST functionality in ADF BC here – 16 Creating RESTful Web Services with Application Modules. I have created very quick sample application to test how it works.

(Andrew Reid) If USERA creates a function or procedure and allows USERB to run it, USERB does so with USERA’s permissions. However, if USERA adds the AUTHID CURRENT_USER clause to the code, USERB runs it with its own permissions.

(David Fitzjarrell) Database backups are a necessary part of a robust management strategy, and ensuring the success of such processes is key to providing reliable disaster recovery operations. Several media choices are available for such backups, which can involve third-party tools such as NetBackup

(Hemant K Chitale) All previous examples of tracing are only to demonstrate enabling tracing and viewing the results.

(Flavio Casetta) Error: parsererror – SyntaxError: JSON.parse:

(Andrew Reid) Long ago, in Oracle 7 I believe, a user with the SELECT ANY TABLE privilege could access tables and views owned by SYS. Also, a user with the EXECUTE ANY PROCEDURE privilege could run code owned by SYS.

(Andrejus Baranovskis) ADF 12.2.1 provides much better responsive UI support comparing to previous version ADF 12.1.3. Previously we were using CSS media queries to hide/show facets.