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.