SQL> SELECT name, 1-(physical_reads / (consistent_gets + db_block_gets )) "HIT_RATIO" FROM V$BUFFER_POOL_STATISTICS WHERE ( consistent_gets + db_block_gets ) !=0 / NAME HIT_RATIO -------------------- ---------- DEFAULT .817011081
© 2005 tiplib.com