Blog

On the Ninth day of 12.2, my DBA gave to me…

On December 20, 2016, Posted by , In Uncategorized, With No Comments

On the Ninth Day of 12.2, my DBA gave to me… In-Memory New Features December 20, 2016 In-Memory Expressions An In-memory expression, or “hot” expression, enables frequently evaluated query expressions to be materialized in the In-Memory Column Store, for subsequent reuse. By default, the procedure DBMS_INMEMORY_ADMIN.IME_CAPTURE_EXPRESSIONS identifies and populates IM…

On the Eighth day of 12.2, my DBA gave to me…

On December 19, 2016, Posted by , In Uncategorized, With No Comments

On the Eighth Day of 12.2, my DBA gave to me… Index New Features December 19, 2016 On the Eighth day of 12.2, my DBA gave to me… The following list illustrates the new Index features for Oracle Database 12c Release 2. There are several new index features that offer…

On the Seventh day of 12.2, my DBA gave to me…

On the Seventh Day of 12.2, my DBA gave to me… Database Security New Features December 18, 2016 Encryption With Oracle Database 12c Release 2, encryption of a tablespace can be deployed with zero downtime. The encryption process can be executed in the background, so that the tablespace can be…

On the Sixth day of 12.2, my DBA gave to me…

On the Sixth Day of 12.2, my DBA gave to me… Automatic Storage Management Cluster File System (ACFS) New Features December 17, 2016 Oracle Automatic Storage Management Cluster File System (ACFS) made it’s debut with Oracle 11.2. Many DBAs are not aware of the vast features that are available with…

On the Fifth day of 12.2, my DBA gave to me…

On the Fifth Day of 12.2, my DBA gave to me… SQL Performance Tuning New Features December 16, 2016 AWR at PDB Level Automatic workload repository reports can now be generated at PDB level. This feature will help a lot in narrowing down performance issues in a very active 12c…

UA-43005198-1