2.4 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 Banking Trade Finance relevance
Turning ON advisory will have an extra overhead. Please note it should be ON, only during performance monitoring.
Parent topic: Database Initialization Parameters