Oracle training Online

1
Oracle Training Online

• http//smconsultant.com/

2
New Features of Oracle12c Database

• Lets have a look a the Oracle 12c Features

3

• Online Data file move
• Automatic data optimization
• Temporal validity

4

• Unified Auditing
• Privilege Analysis
• Adaptive Execution Plans

5

• Real time ADDM
• Data Pump
• Partitioning
• SQL

6
Main Features

• De-Supported Deprecated

7

• Oracle 12c, it is important to be aware of
  features which are either being de-supported or
  deprecated with this database version.

8
Main Features

• Online Table Redefinition Data file Movement

9

• Moving objects and data files around is required
  when you need to either change the physical
  location of the data files or when you want to
  migrate to ASM or some other Storage system.
• In Oracle 12c this can be minimized to almost no
  downtime. Lets look at how online table
  redefinition and data file movement can help us
  in achieving zero downtime.

10
Main Features

• Heat Maps Automatic Data Optimization

11

• When installing Oracle Software
• you can create 12c CDB
• PDB Databases using OUI
• just like you used to do in the previous versions
  of the Oracle database.

12
Main Features

• Last login time for Non-Sys Users

13

• Oracle 12c introduced a new, very useful security
  feature to store and display the last login
  information for non-sys users
• Logging in via SQLPLUS.
• The last login time is displayed in the banner by
  default when we log into the database using
  SQLPLUS in 12c.

14
For more information login to

• http//smconsultant.com/

15
Thank You