This system table contains all sessions if auditing is enabled. This system table can be cleared by the statement TRUNCATE AUDIT LOGS. Only users with the SELECT ANY DICTIONARY system privilege have access to the table.

Column Name Description
SESSION_ID ID of the session
LOGIN_TIME Login time
LOGOUT_TIME Logout time
USER_NAME User name
CLIENT Client application used by the user
DRIVER Used driver
ENCRYPTED Flag whether the connection is encrypted
HOST Computer name or IP address from where the user has logged-in
OS_USER User name used by the user to log into the operating system of the computer from where the login came
OS_NAME Operating system of the client
  • TRUE: Login was successful
  • FALSE: Login failed (for example, because of a wrong password)
ERROR_CODE Error code if the login failed
ERROR_TEXT Error text if the login failed
CLUSTER_NAME Name of the cluster on which the session is initially running