v$sess_io.consistent gets increasing but v$slq does not
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 6 Nov 2006 17:40:53 +0100
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
Other related posts:
- » v$sess_io.consistent gets increasing but v$slq does not
