Oracle Database 12c New Features

SQL Tuning Tools

Several tuning tools to detect and rectify SQL errors and performance issue


Automatic Database Diagnostic Monitor

The Automatic Database Diagnostic Monitor (ADDM) continually analyzes the performance data that is collected from the database instance.


SQL Tuning Advisor

The SQL tuning advisor analyzes SQL statements that have been identified as problematic, in an effort to retune them. By default, this is an automated task. You can also, at any time, run the SQL Tuning Advisor on a specific SQL workload, to look for ways to improve performance.


SQL Tuning Sets

SQL tuning sets serve as a repository for sets of SQL statements. For example, the SQL Tuning Advisor can run againsts a workload that is represented by a SQL Tuning Set. They can even be transported from database to database, to perform analysis on different machines.


SQL Access Advisor

The SQL Access Advisor analyzes a SQL statement, and provides advise on materialized view, indexes, materialized view logs, and partitions.


SQL Performance Analyzer

The SQL performance analyzer automates the process of assessing the overal effect of a change, such as upgrading database or adding new indexes, on the full SQL workload by identifiying the performance divergence for each statement.


SQL Monitoring

The real-time SQL monitoring feature of Oracle Database enables you to monitor the performance of SQL statements while they execute.


SQL Plan Management 

The SQL Plan Management tool can be used to control the execution plan evolution.


Adaptive SQL PLan Management


SQL plan management (SPM) ensures that runtime performance will never degrade due to the change of an execution plan. To guarantee this, only accepted execution plans are used; any plan evolution that does occur, is tracked and evaluated at a later point in time, and only accepted if the new plan shows a noticeable improvement in runtime.