Without the proper access to Oracle data, Predictive Diagnostics cannot make its projections on the behavior of Oracle databases. To ensure its access to Oracle data, set the correct values for these Oracle parameters.
| Oracle Parameter | Value |
|---|---|
| db_cache_advice |
Set this parameter to ON. If this value is not set, Predictive Diagnostics cannot collect data on memory utilization. |
| statistics_level |
Set this parameter to TYPICAL or ALL. If statistics_level is set to BASIC, Predictive Diagnostics cannot collect data on disk latency, disk throughput, active sessions, or memory. |
| timed_statistics |
Set this parameter to TRUE. If timed_statistics is set to FALSE, Predictive Diagnostics cannot collect data on disk latency or disk throughput. |
You can set Oracle parameters in the Spotlight on Oracle Configuration & Memory | Oracle Parameters Page.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
