Chat now with support
Chat with Support

Spotlight on Oracle 10.6 - Release Notes

Oracle Parameters for Predictive Diagnostics

Oracle Parameters for Predictive Diagnostics

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.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating