Find the oracle sessions with high physical reads
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;