--
-- Show session io statistics for executing session
--
select
sio.block_gets,
sio.consistent_gets,
sio.physical_reads,
sio.block_changes,
sio.consistent_changes,
sio.optimized_physical_reads
from
v$session ses join
v$sess_io sio on ses.sid = sio.sid
where
ses.audsid = sys_context('userenv', 'sessionid');