Oracle PL/SQL Tutorial/System Tables Data Dictionary/statname

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