Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.