v$sess_io.consistent gets increasing but v$slq does not

Hi

Users ran a query which takes already some days (?!?!)

I check the session and I see this

select CONSISTENT_GETS , PHYSICAL_READS, BUFFER_GETS, PHYSICAL_READS, USERS_EXECUTING
from v$sess_io a, v$sql b, v$session c
where c.sid = 24
and a.sid = c.sid
and b.hash_value = c.sql_hash_value

CONSISTENT_GETS PHYSICAL_READS BUFFER_GETS PHYSICAL_READS USERS_EXECUTING
--------------- -------------- ----------- -------------- ---------------

      683949998 683071915 38006682 683071915 1

CONSISTENT_GETS PHYSICAL_READS BUFFER_GETS PHYSICAL_READS USERS_EXECUTING
--------------- -------------- ----------- -------------- ---------------

      683952895 683074810 38006682 683074810 1

I noticed buffer_gets in v$sql does not increase however consistent gets in v$sess_io does increase, what consistent gets is v$sess_io showing us?

Any help would be appreciated

Cheers

--

LSC
--

http://www.freelists.org/webpage/oracle-l Received on Mon Nov 06 2006 - 10:40:53 CST