Re: v$sess_io

v$sess_io lists I/O statistics for each user session.

block gets are the number of database blocks read to satisfy a particular session.
consistent_gets are the number of reads from rollback_segments physical_reads are reads of data blocks into memory from disk.

Hope this helps

Neil C

Christopher Spence wrote in message ...
> Could someone please explain accurately what exactly 'BLOCK
>GETS' and 'CONSISTANT GETS' refers to under this view? I believe i
>know wha they mean but if someone that is 100% sure can explain this
>that would be wonderful. Also 'Physical Reads' would be great too. I
>have heard different answers to this.
>
Received on Wed Sep 08 1999 - 08:46:34 CDT