Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Release Notes

Predictive Diagnostics And Spotlight

Predictive Diagnostics And Spotlight

For detailed information on Predictive Diagnostics, see the Spotlight online help.

When... Do this...
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.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating