Friday, 22 January 2016

12c New Features

--------------------
Part 1 Covers:
--------------------
CDB & PDB
Online migration of an active data file
Online table partition or sub-partition migration
Invisible column
Multiple indexes on the same column
DDL logging  ( $DIAG )
Temporary undo in- and- outs
New backup user privilege
How to execute SQL statement in RMAN
Table level recovery in RMAN
Restricting PGA size
Smart Flash Cache
 Automatic Big Table Cache 12.1.0.2c (ABTC)


--------------------
Part 2 Covers:
--------------------
Table partition maintenance enhancements
Database upgrade improvements
Restore/Recover data file over the network
Data Pump enhancements
Real-time ADDM
Concurrent statistics gathering
TDE Re-create master key after deleting

--------------------------------------
Part 3 RAC & ASM Covers:
--------------------------------------
Additions/Enhancements in ASM
        * Flex ASM
* Increased ASM storage limits
* Tuning ASM rebalance operations
* ASM Disk Scrubbing
* Active Session History (ASH) for ASM

Additions/Enhancements in Grid Infrastructure
* Flex Clusters
* OCR backup in ASM disk group
* IPv6 support

Additions/Enhancements in Real Application Cluster (database)
* What-If command evaluation
* Miscellaneous srvctl improvements

--------------------
Part 4 Covers:
---------------------
How to truncate a master table while child tables contain data
Limiting ROWS for Top-N query results
Miscellaneous SQL*Plus enhancements
Session level sequences
WITH clause improvements
Extended data types



I'm great thanks to Mr.Syed Jaffar Hussain &  Mr.Tim Hall for nice explanation some 12c features.

No comments: