Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Join v$session, v$sesstat and v$statname

SQL> SQL> SELECT a.username, c.name, b.value   2  FROM   v$session a, v$sesstat b, v$statname c   3  WHERE  a.sid        = b.sid   4  and    rownum < 2   5  AND    b.statistic# = c.statistic#   6  AND    b.value      != 0; USERNAME ------------------------------ NAME                                                                  VALUE ---------------------------------------------------------------- ---------- logons cumulative                                                         1 SQL>