Oracle: Get list of connected users

Categories:

  less than a minute  

Following query returns the list of users who are currently connected to the Oracle database

SELECT
  username,
  osuser,
  terminal,
  utl_inaddr.get_host_address(terminal) ip_address
FROM
  system.v$session
WHERE
  username is not null
ORDER BY
  username,
  osuser;