doc

    Name:   incbcach.sql

    Author: Mark Gurry


The following script show the effect of increasing the buffer cache.
You must have assigned a value to the DB_BLOCK_LRU_EXTENDED_STATISTICS 
INIT.ORA parameter to get a result.

#

SELECT 250 * TRUNC(INDX / 250) +1 || 'to' ||250 * (TRUNC(INDX / 250) +1) INTERVAL,
    SUM(COUNT) CACHE_HITS
    FROM SYS.X$KCBRBH
    GROUP BY TRUNC(INDX / 250);