spool x$kcbcbh.rslt 

set linesize 80;
set pagesize 1000;
set long 50;
set echo on;
 
/* ************************************************************************* */
/*                                                                           */
/*                  Measure the impact of removing "DB_BLOCK_BUFFERS"        */
/*                                                                           */
/* Script will show the cache hit rate of your database.  To make the buffer */
/*  cache larger increase the iniatialization parameter DB_BLOCK_BUFFERS to  */
/*  a maximium value of 65535.  In order to determine the efficiency of the  */
/*  buffer cache the parameter DB_BLOCK_LRU_STATISTICS must by set           */
/*  to TRUE - THERE IS AN OVERHEAD TO THE SYSTEM PERFORMANCE FOR CAPTURING   */
/*  THE STATISTICS.                                                          */
/*                                                                           */
/*  NAME:   @c:\oracle\sql\x$kcbcbh.sql                                      */ 
/*  OWNER:  R.Kupcunas                                                       */
/*  DATE:   May 2, 1995                                                      */
/*                                                                           */
/* ************************************************************************* */

/* *********************************************** */
/* Group the additional buffers in large intervals */
/* *********************************************** */

select 200*TRUNC(indx/200)+1||' to '||250*(TRUNC(indx/200)+1) "Interval",
       sum(count) "Less Buffer Cache Hits"
  from sys.x$kcbcbh
  where indx > 0
  group by TRUNC(indx/200);
         
set echo off;
spool off;
set long 80;
commit;










