(Martin Bach) One of the problems I have seen when deploying Data Guard for systems such as RAC One Node and policy managed databases was the static listener configuration you needed in 11.2. This has changed with 12c for the better if you are using Grid Infrastructure.
Tag: Oracle
It Isn’t The Index
(David Fitzjarrell) One of the more confusing statistics in Oracle is, apparently, one called the clustering factor. Associated with an index (as evidenced by the columns in DBA_INDEXES) it’s actually dependent on the table data, more specifically the distance between ‘jumps’ for a given index key.
Multiple invisible indexes on the same column in #Oracle 12c
(Uwe Hesse) After invisible indexes got introduced in 11g, they have now been enhanced in 12c: You can have multiple indexes on the same set of columns with that feature. Why would you want to use that?
Little things worth knowing: Data Guard Broker Setup changes in 12c
(Martin Bach) One of the problems I have seen when deploying Data Guard for systems such as RAC One Node and policy managed databases was the static listener configuration you needed in 11.2. This has changed with 12c for the better if you are using Grid Infrastructure.
Things that are there but you cannot use
(connormcdonald) I did a “desc” command on the STANDARD package today, the package that helps define PL/SQL, and saw the XOR function!
Things that are there but you cannot use
(connormcdonald) I did a “desc” command on the STANDARD package today, the package that helps define PL/SQL, and saw the XOR function!
12c Parallel Execution New Features: Parallel FILTER Subquery Evaluation – Part 1: Introduction
(Randolf Geist) 12c introduces another interesting new Parallel Execution feature – the parallel evaluation of FILTER subqueries. In pre-12c FILTER subqueries always had to be evaluated in the Query Coordinator.
12c Parallel Execution New Features: Parallel FILTER Subquery Evaluation – Part 1: Introduction
(Randolf Geist) 12c introduces another interesting new Parallel Execution feature – the parallel evaluation of FILTER subqueries. In pre-12c FILTER subqueries always had to be evaluated in the Query Coordinator.
SQLcl: Using the new CTAS Command
(Jeff Smith) How often do you need to build a new table to test something out?
AUDIT_SYS_OPERATIONS defaults to TRUE in #Oracle 12c
(Uwe Hesse) A small but remarkable change in Oracle Database 12c is the default value of AUDIT_SYS_OPERATIONS has changed to TRUE now. In other words, all actions done by the superuser sys are being audited now by default!