doc

    Name:   decbcach.sql

    Author: Mark Gurry


The following script show the effect of decreasing the buffer cache.
You must have assigned a value TRUE to DB_BLOCK_LRU_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$KCBCBH
    WHERE INDX > 0
    GROUP BY TRUNC(INDX / 250);