Oracle Data Dictionary

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:



Back to the Top

Simon Sheppard
SS64.com