Predictive Diagnostics
Predictive Diagnostics
Collect and analyze performance metrics in order to predict the future behavior of the Oracle database.
To open Predictive Diagnostics
- Select the Spotlight on Oracle connection (or Spotlight on Oracle RAC connection) in the Spotlight Browser.
-
Click Predictive Diagnostics.
The page contains several sections —Configuration, Find Impending Problems, Performance Modeling, and What To Do Next — and a set of images that indicate a basic workflow through the predictive process.
Notes:
- Predictive Diagnostics uses a proprietary set of algorithms to process the data.
- You do NOT need to have Spotlight running continuously in order to collect the data.
- Use the Oracle User Wizard to create a new Spotlight user (or modify an existing user) that employs Predictive Diagnostics.
| Diagnostic Category | Diagnostic Category | Description |
|---|---|---|
| SQL Performance | SQL Performance |
Collect and analyze performance metrics for SQL statements as they are executed on the database instance. When enough performance data is collected, Spotlight may be able to predict the future performance for individual SQL statements on that database. These predictions can be used to identify SQL statements whose performance may not scale adequately as data volumes and SQL execution rates increase. Spotlight will refer to these SQL statements as degrading SQL. |
| Impending Bottlenecks - Timed Statistics | Impending Bottlenecks - Timed Statistics |
Note: Available for Oracle 10.2 and later. Collect and analyze waiting events as they occur on the database. When enough performance data is collected, Spotlight may be able to predict potential bottlenecks in the system as they affect database throughput and response time. |
| Performance Modeling | Performance Modeling |
Note: Available for Oracle 10.2 and later. Collect and analyze statistics on the performance of the database during periods of high activity. When enough performance data is collected, Spotlight may be able to:
|