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 →

User Task-Specific Administrative Privileges

• To continue with the objective of separating duties and the least privileges, Oracle 12c introduce new administratives privileges all destinated to accomplish specific duties:
  • SYSBACKUP : Used for RMAN operations like BACKUP, RESTORE, RECOVER
  • SYSDG : Used to administer DATAGUARD, In 12c when you use DGMGRL commandline interface your are automatically loggued on with the SYSDG privilege.
  • SYSKM : This privilege is meant for TDE operations like OPEN/CLOSE key stores, change master key or manage column encryption keys and tablespace encryption.

Continue reading OCP 12C – Privileges →