Oracle high physical reads Sessions wise

SQL> r

1 select

2 OSUSER os_user,username,

3 PROCESS pid,

4 ses.SID sid,

5 SERIAL#,

6 PHYSICAL_READS,

7 BLOCK_CHANGES

8 from v$session ses,

9 v$sess_io sio

10 where ses.SID = sio.SID

11 and username is not null

12 and status='ACTIVE'

13* order by PHYSICAL_READS



OS_USER USERNAME PID SID SERIAL# PHYSICAL_READS BLOCK_CHANGES

---------- --------------- ------------------------------------ ---------- ---------- -------------- -------------

oracle SYS 18038 112 1457 0 2

oracle SYS 18040 120 12352 0 2

oracle SYS 18032 128 24796 0 2

oracle SYS 18030 138 49309 0 2

oracle SYS 18034 135 63569 0 2

oracle SYS 18028 126 15159 0 2

oracle SYS 18036 146 22857 0 2

oracle SYS 18042 124 4489 7 10

oracle SYS 25381 131 54920 1516947 5

oracle SYS 17904 129 29110 15857587 47



10 rows selected.