Join v$session and v$sess_io : sess_io « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. sess_io

SQL>
SQL>
SQL> SELECT a.username, b.block_gets, b.consistent_gets,
  2         b.physical_reads
  3  FROM   v$session a, v$sess_io b
  4  WHERE  a.sid = b.sid
  5  and    rownum < 2
  6  ORDER BY a.username;

USERNAME                       BLOCK_GETS CONSISTENT_GETS PHYSICAL_READS
------------------------------ ---------- --------------- --------------
                                        0               0              0

SQL>