Chat now with support
Chat with Support

Spotlight on Oracle 11.0 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Troubleshooting: Connection Problems

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