Oracle Data Dictionary

V$SESSION

Columns
   ___________________________
 
   SADDR
   SID
   SERIAL#
   AUDSID
   PADDR
   USER#
   USERNAME
   LOGON_TIME
   OSUSER
   CLIENT_INFO
   COMMAND
   PROGRAM
   TERMINAL
   PROCESS
   MACHINE
   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#
   SCHEMA#
   PDML_ENABLED
   FAILOVER_TYPE
   FAILOVER_METHOD
   FAILED_OVER
   RESOURCE_CONSUMER_GROUP
   ROW_WAIT_ROW#
   PQ_STATUS
   PDDL_STATUS
   OWNERID
   TADDR
   LOCKWAIT
   STATUS
   SERVER
   SCHEMANAME
   PDML_STATUS


Note that v$session truncates the OSUSER to 15 characters, so you might want
to use the one from V$SESSION_CONNECT_INFO.

Related Commands:

DBMS_APPLICATION_INFO

Related Views:

V$ACCESS
V$MYSTAT 
V$SESSION_CONNECT_INFO 
V$SESSION_CURSOR_CACHE 
V$SESSION_EVENT 
V$SESSION_LONGOPS 
V$SESSION_OBJECT_CACHE 
V$SESSION_WAIT 
V$SESSTAT 
V$SESS_IO 




Back to the Top

Simon Sheppard
SS64.com