For detailed information on Predictive Diagnostics, see the Spotlight online help.
|Predictive Diagnostics identifies a SQL statement that may cause problems||Open the Top SQL drilldown to view further details about the SQL statement.|
|Open Explain Plan to view further information about the statement's execution plan.|
|Open SQL Optimizer to view context-sensitive tuning advice for the SQL statement based on the Oracle execution plan and the structure of the database.|
|Predictive Diagnostics identifies a bottleneck that may cause problems||Open the Activity | Waiting Events drilldown to view further details about the current behavior of potential bottlenecks.|
|Predictive Diagnostics identifies a database resource whose limitations may cause problems||Open the I/O, Configuration & Memory, and Tuning drilldowns to view further details about the current behavior of CPU, memory, and disk I/O resources.|