Search notes:

v$sess_io

--
-- 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');
Github repository oracle-patterns, path: /Installed/dynamic-performance-views/sess/io/own-sessions-statistics.sql

See also

Oracle Dynamic Performance Views

Index