Search This Blog

Total Pageviews

Friday, 15 July 2011

session IO info

SQL> select * from v$sess_io where sid in (select sid from v$session where username is not NULL) order by physical_reads;

SID BLOCK_GETS CONSISTENT_GETS PHYSICAL_READS BLOCK_CHANGES CONSISTENT_CHANGES OPTIMIZED_PHYSICAL_READS
---------- ---------- --------------- -------------- ------------- ------------------ ------------------------
29 0 53 3 0 0 0

No comments:

Oracle DBA

anuj blog Archive