Copyright Ó Oracle Corporation, 1999. All rights reserved.
6-16
Recycle Buffer Pool Guidelines
Tool:
V$SESS_IO
SQL> SELECT io.block_gets,
2 io.consistent_gets,
3 io.physical_reads
4 FROM v$sess_io io,
5 v$session s
6 WHERE s.audsid = USERENV('SESSIONID')
7* AND io.sid = s.sid ;
BLOCK_GETS CONSISTENT_GETS
PHYSICAL_READS
---------- ---------------
--------------
2187
23271 1344