Oracle logged in users

To check how many users are currently active on your oracle server you could run the following statemnts:

SELECT username, status, machine, to_char(logon_time, 'DD.MM.YYYY hh24:mm:ss'), state, count(*)
  FROM sys.v_$session
  GROUP BY username, status, machine, logon_time, state;
SELECT username, status, machine, state, count(*)
  FROM sys.v_$session
  GROUP BY username, status, machine, state;

Labels

oracle oracle Delete
sql sql Delete
users users Delete
logged logged Delete
in in Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.