(David Fitzjarrell) Extended statistics can be very helpful to the optimizer by establishing a dependency between two or more columns in a table. Such dependencies can improve cardinality estimates the optimizer uses to determine the best plan of attack for a query.

(Iggy Fernandez) As I explained in The Rise and Fall of the NoSQL Empire, since there is very little—if anything—about NoSQL that is incompatible with the relational model, the RDBMS vendors will eventually absorb the innovations of the NoSQL camp.

(Andrejus Baranovskis) Alta UI in ADF 12c provides great options for dashboard implementation. You can use so called ‘info tiles’ as blocks displaying summary information. These blocks are clickable and based on active tile, content can be rendered.

(David Fitzjarrell) Extended statistics can be very helpful to the optimizer by establishing a dependency between two or more columns in a table. Such dependencies can improve cardinality estimates the optimizer uses to determine the best plan of attack for a query.

(Martin Berger) datapatch can fail if doing manual out of place patching, when the new ORACLE_HOME is not cloned from previous one but a fresh installation. The problem is a one-of patch in the old ORACLE_HOME, which is included in something else (like a PSU) in the new ORACLE_HOME.

(Martin Berger) datapatch can fail if doing manual out of place patching, when the new ORACLE_HOME is not cloned from previous one but a fresh installation. The problem is a one-of patch in the old ORACLE_HOME, which is included in something else (like a PSU) in the new ORACLE_HOME.

(Christian Antognini) The database engine determines the maximum disk I/O size used during multiblock reads (for example, full table scans or index fast full scans) by multiplying the values of the db_block_size and db_file_multiblock_read_count initialization parameters.

(Christian Antognini) The database engine determines the maximum disk I/O size used during multiblock reads (for example, full table scans or index fast full scans) by multiplying the values of the db_block_size and db_file_multiblock_read_count initialization parameters.

(Martin Berger) datapatch is a nice new feature in recent Oracle database installations. It helps to ensure the databases objects match the binaries after any kind of patching and so avoid situations which can be an operational and support nightmare – and very hard to identify.

(Vikram Das) Recently I spent almost a full day struggling to make out, why an sftp connection would not work without password, after setting up ssh equivalence.