Home Oracle Commands v$ Performance views
Oracle Data Dictionary

V$SESSION

Data Dictionary View

Columns
   ___________________________
 
   SADDR
   SID
   SERIAL#
   AUDSID
   PADDR
   USER#
   USERNAME
   COMMAND
   OWNERID
   TADDR
   LOCKWAIT
   STATUS
   SERVER
   SCHEMA#
   SCHEMANAME
   OSUSER
   PROCESS
   MACHINE
   TERMINAL
   PROGRAM
   TYPE
   SQL_ADDRESS
   SQL_HASH_VALUE
   PREV_SQL_ADDR
   PREV_HASH_VALUE
   MODULE
   MODULE_HASH
   ACTION
   ACTION_HASH
   CLIENT_INFO
   FIXED_TABLE_SEQUENCE
   ROW_WAIT_OBJ#
   ROW_WAIT_FILE#
   ROW_WAIT_BLOCK#
   ROW_WAIT_ROW#
   LOGON_TIME
   LAST_CALL_ET
   PDML_ENABLED
   FAILOVER_TYPE
   FAILOVER_METHOD
   FAILED_OVER
   RESOURCE_CONSUMER_GROUP
   PDML_STATUS
   PDDL_STATUS
   PQ_STATUS
   CURRENT_QUEUE_DURATION
   CLIENT_IDENTIFIER

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

Related:

DBMS_APPLICATION_INFO
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 



Simon Sheppard
SS64.com