What’s new ?

• Oracle 12c introduces a major update called Adaptive Query Optimization which is based on :
  • Adaptive execution plans
  • Adaptive Statistics
• These two functionnalities are used to improve execution plans by using dynamic statistics gathered during the first part of the SQL execution. This allow to create more efficient plans that those using only the existing statistics which could be inaccurate or insufficient.
• Oracle 12c introduce 2 new types of histograms
• Finally there are significant improvements on SQL Plan Management.

Continue reading OCP 12C – SQL Tuning →

What is Real Time Database Operation Monitoring ?

• Real Time Database Operation Monitoring will help you track the progress of a set of sql statements and let you create a report.
• Real Time Database Operation Monitoring acts as a superset of all monitoring components like : ASH, DBMS_MONITOR …
• You can generate Active Reports which are available offline and don’t need access to the production system once generated.
• Real Time Database Operation Monitoring is part of the tuning pack and subject to license.

What is a Database Operation ?

• A database opration is one or more sql statements running inside a single session.
• There are two types of database operations :
  • Simple : A simple database operation is one SQL or PL/SQL statement.
  • Composite : A Composite database operation consists in multiple SQL or PL/SQL statement running in a single session.

Continue reading OCP 12C – Real-Time Database Operation Monitoring →

RMAN Enhancements

New Privilege

• A new SYSBACKUP privilege is created in Oracle 12c,  it allows the grantee to perform BACKUP and RECOVERY operations with RMAN

SQL in RMAN

• You can now use SQL Statements in RMAN like you would do in SQL*PLUS :
  • BEFORE : RMAN> SQL “alter system switch logfile”;
  • NOW : RMAN> alter system switch logfile;

Continue reading OCP 12C – RMAN and Flashback Data Archive →