(Syed Jaffar Hussain) Whoever is working with Exadata or knew how to administrate Exadata major components like DB and Cell nodes, will certainly knows the use of CellCLI, dcli and DBMCLI utilities.

(Oren Nakdimon) Onine DDL operations are much more polite than offline DDL operations. They usually wait patiently for transactions that hold resources they need until these transactions end, and they do not block new DML statements.

(stewashton) I recently posted an experimental approach to accessing package constants from SQL. Here is a more robust approach that includes all variables.

(Andrejus Baranovskis) Did you ever wonder why Attributes Enum is generated by JDeveloper in Entity or View Row class? Attributes Enum holds a collection of attribute names and there is a set of static variables with attribute indexes.

(stewashton) This is an enhancement request on ODC and a recent Twitter topic. Here is a homemade solution using the SQL Translation Framework.

(robertCrames) Since today, Oracle Database Appliance software release 18.3.0.0.0 is available … I took the chance to download and install the new release – this is the story:

(Bobby Durrett) On December 2nd we ran into a problem with one of my scripts that uses the DBA_HIST_SQLSTAT view. It did not show the full run time of a SQL statement that ran for several hours.

(Jeff Smith) The 18.4 version product lines of SQL Developer, SQLcl, Data Modeler, and ORDS we’re pretty much limited to bug fixes.

(Uwe Hesse) The technique to recover only certain objects from an ordinary backup is called Virtual Access Restore.

(Martin Bach) For a little while now I have been using Ansible for all installation/configuration tasks I do in the lab.