|Explain Plan||Tools | Explain Plan||The Explain Plan allows you to determine the execution plan that Oracle applies to a particular SQL statement. Spotlight on Oracle allows you to view graphical representations of the execution plan for SQL statements being executed by a user, or for those identified by the SQL & Application Workload drilldown.|
|SQL Optimizer||Tools | SQL Optimizer (SQL Tuning)||SQL Optimizer (if installed) provides context-sensitive tuning advice for SQL statements based on the Oracle execution plan and the database structure. You must have DBA privileges for the database you are diagnosing.|
|Space Manager||Tools | Space Manager||
Space Manager (if installed) provides a comprehensive solution for space management and reorganization. Space Manager offers preventive maintenance, problem detection and resolution, and capacity planning across any number of databases.