Name
DB_CACHE_ADVICE
Synopsis
Value: ON | OFF | READY
Default: OFF
Dynamic: ALTER SYSTEM
Specifies how statistics gathering used for predicting database performance with different cache sizes will be performed. If this parameter is set to OFF and then changed to ON using the ALTER SYSTEM statement, an error is likely to occur, because memory will not be allocated. Use the READY setting to allow this parameter to be changed to ON at a later time. New with Oracle9i.
Keywords
- ON
Cache advisory is turned on and statistics are gathered.
- OFF
Cache advisory is turned off, and no memory is allocated for gathering of statistics.
- READY
Cache advisory is turned off, but memory is allocated for statistics.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.