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 Oracle Query Window. See About SQL Tuning Advisor.

• Explain Plan

  Provides an Oracle Execution Plan for any arbitrary SQL statement through the Oracle Query window. This helps advanced users manually tune their SQL statements. See About Explain Plan.

• 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.