Oracle PL/SQL Tutorial/System Tables Data Dictionary/sess io

Join v$session and v$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>