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

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

SQL>
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>
SQL>