col os_user format a10
col username format a15
col pid format 9999999999
SELECT OSUSER os_user,
username,
PROCESS pid,
ses.SID sid,
SERIAL#,
PHYSICAL_READS,
BLOCK_CHANGES
FROM v$session ses,
v$sess_io sio
WHERE ses.SID = sio.SID
AND username IS NOT NULL
AND status ='ACTIVE'
ORDER BY PHYSICAL_READS;
Sample Output:
Code: Select all
OS_USER USERNAME PID SID SERIAL# PHYSICAL_READS BLOCK_CHANGES
---------- --------------- ------------ ---------- ---------- -------------- -------------
oracle SYS 7639 159 26 0 0