Name
DB_BLOCK_LRU_STATISTICS
Synopsis
Value: TRUE | FALSE
Default: FALSE
Disables or enables compilation of statistics in the X$KCBCBH table, which measures the effect of decreasing the number of buffers in the SGA buffer cache. These statistics are also available in V$CURRENT_BUCKET. This parameter is a tuning tool; you should set it to FALSE during normal operation. Obsolete with Oracle8i.
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.