Performance Tuning Overview

ODT offers several different tools to assist in performance tuning your application’s use of the Oracle Database:

• Oracle Performance Analyzer

  Examines the actual use of an Oracle database over a specified period of time and provides recommendations to improve application performance. See About Oracle Performance Analyzer.

• SQL Tuning Advisor

  Provides tuning recommendations for arbitrary SQL statements. Access the SQL Tuning Advisor through the Tune SQL Toolbar in the SQL and PL/SQL File Editor. See About SQL Tuning Advisor.

• Real-Time SQL Monitor

  Real-Time SQL Monitoring provides automatic monitoring of SQL statements and PL/SQL blocks. You can view a list of monitored SQL, view and save SQL Monitor Active Reports, and generate an Active Report for ad hoc SQL. See About Real-Time SQL Monitor.