V$SESSION
Data Dictionary ViewColumns ___________________________ 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
Notes:
The SYS_CONTEXT function is often a better way to return this information.
V$SESSION truncates the OSUSER to 15 characters,
so you might want
to use the one from V$SESSION_CONNECT_INFO.
select * from v$session where sid = (select sid from v$mystat where rownum=1 );
Related:
SYS_CONTEXT - function that returns session information 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