Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Join v$session and v$sess_io

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>