DB_CACHE_ADVICE

This enables or disables statistics gathering used for predicting behavior with different cache sizes through the V$DB_CACHE_ADVICE performance view.

Property

Description

Parameter type

String

Syntax

DB_CACHE_ADVICE = { ON | READY | OFF }

Default value

If STATISTICS_LEVEL is set to TYPICAL / ALL, then ON If STATISTICS_LEVEL is set to BASIC, then OFF

Recommended Value

OFF (Should be ON while Performance Monitoring)

Oracle FLEXCUBE relevance

Turning ON advisory will have an extra overhead. Please note it should be ON, only during performance monitoring.

Parent topic: Database Initialization Parameters