|
|
V$SESSION
Note that v$session truncates the OSUSER to 15 characters, so you might want to use the one from V$SESSION_CONNECT_INFO.
Columns ___________________________ CLIENT_INFO ACTION_HASH ACTION MODULE_HASH MODULE PREV_HASH_VALUE FIXED_TABLE_SEQUENCE SQL_HASH_VALUE LAST_CALL_ET SQL_ADDRESS TYPE PREV_SQL_ADDR ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# PROGRAM LOGON_TIME SCHEMA# PDML_ENABLED FAILOVER_TYPE FAILOVER_METHOD FAILED_OVER RESOURCE_CONSUMER_GROUP ROW_WAIT_ROW# COMMAND PQ_STATUS PDDL_STATUS SADDR SID SERIAL# AUDSID PADDR OSUSER USERNAME TERMINAL OWNERID TADDR LOCKWAIT STATUS SERVER SCHEMANAME PDML_STATUS PROCESS MACHINE USER#
Related Commands: