Spotlight on Oracle 10.10

Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Spotlight on Oracle 10.10 - Release Notes

New Features Resolved Issues and Enhancements Deprecated Features Known Issues System Requirements Product Licensing Getting Started Globalization About us Copyright

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.

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.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Spotlight on Oracle 10.10 - Release Notes

Oracle Parameters for Predictive Diagnostics

Oracle Parameters for Predictive Diagnostics