Sunday, May 15, 2016

What are the new features of Oracle 12C.

What are the new features of Oracle 12C.

As per my view, below are the main new features of the Oracle Database 12c.

1. Pluggable Database
2. Reduction Policy
3. Top N Query and Fetch and offset Replacement to Rownum
4. Adaptive Query Optimization and Online Stats Gathering
5. Restore a Table Easily through RMAN
6. Some Datatype Size has been increased (Varchar2, NBarchar2, Raw Data)
7. Multiple indexes on single column.
8. Temporary Undo Feature
9. In database Archiving

No comments:

Post a Comment

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...