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