December 2002
Intermediate to advanced
928 pages
85h 29m
English
DB_CACHE_ADVICE
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.
Cache advisory is turned on and statistics are gathered.
Cache advisory is turned off, and no memory is allocated for gathering of statistics.
Cache advisory is turned off, but memory is allocated for statistics.