Create Session Level General Performance Object: sessprocess

sessprocess
This object displays global information about all connected processes.

Column Datatype Description
SERVER_ID NUMBER Server ID
SESSION_ID NUMBER Connection ID
USER_NAME VARCHAR Name of the user
USER_HOST VARCHAR Name of the user host
LOGON_TIME DATETIME Date/time the connection logged on
DATABASE_NAME VARCHAR Name of the current database
PROGRAM VARCHAR Program being executed
COMMAND VARCHAR Current command being executed
STATUS VARCHAR Current status of the connection
CPU NUMBER Total CPU used by the connection
MEMORY NUMBER Total memory used by the connection
WAIT_TIME NUMBER Total wait time experienced by the connection
BLOCKED_BY NUMBER Connection ID blocking the connection
CURRENT_SQL_HASH VARCHAR Currently executing SQL hash value
CURRENT_SQL TEXT Currently executing SQL (partial)
IDLE_SINCE_LAST_CALL NUMBER Amount of time (seconds) since last call completed