Dear experts,
We would like to know the number of buffer gets or physical reads done by a specific session and we are using v$sess_io for the same.Will this gives cumulative values or values for a specific session and serial#
SQL> SELECT s.sid,s.schemaname, s.serial#,s.sql_id, s.username, s.program,i.CONSISTENT_GETS,i.PHYSICAL_READS FROM v$session s, v$sess_io i WHERE s.sid = i.sid and s.status='ACTIVE' and s.program not like 'oracle%' and rownum<20 ORDER BY i.CONSISTENT_GETS desc
2 /
SID SCHEMANAME SERIAL# SQL_ID USERNAME PROGRAM CONSISTENT_GETS PHYSICAL_READS
---------- -------------------- ---------- ------------- ---------- -------------------- --------------- --------------
511 SAI 6725 9awzbg8b2br6w SAI JDBC Thin Client 762243551 86505179
132 DPS 30908 b2qnnjgmh9yqj DPS LocalCounters.exe 1998138 16
1141 SYSTEM 2313 8hja49yzpxh9h SYSTEM SQL Developer 1783932 1471844
638 PERFSTAT 4417 c130p7hp9k58a PERFSTAT sqlplus@AXPPDCPODB 606 130
01.SSST.ORG (TNS V1-
V3)
Thank you