V$SESSION definition in Oracle Database 11.2
V$SESSION
select
SADDR, -- SADDR RAW(8)
SID, -- SID NUMBER
SERIAL#, -- SERIAL# NUMBER
AUDSID, -- AUDSID NUMBER
PADDR, -- PADDR RAW(8)
USER#, -- USER# NUMBER
USERNAME, -- USERNAME VARCHAR2(30)
COMMAND, -- COMMAND NUMBER
OWNERID, -- OWNERID NUMBER
TADDR, -- TADDR VARCHAR2(16)
LOCKWAIT, -- LOCKWAIT VARCHAR2(16)
STATUS, -- STATUS VARCHAR2(8)
SERVER, -- SERVER VARCHAR2(9)
SCHEMA#, -- SCHEMA# NUMBER
SCHEMANAME, -- SCHEMANAME VARCHAR2(30)
OSUSER, -- OSUSER VARCHAR2(30)
PROCESS, -- PROCESS VARCHAR2(24)
MACHINE, -- MACHINE VARCHAR2(64)
PORT, -- PORT NUMBER
TERMINAL, -- TERMINAL VARCHAR2(16)
PROGRAM, -- PROGRAM VARCHAR2(64)
TYPE, -- TYPE VARCHAR2(10)
SQL_ADDRESS, -- SQL_ADDRESS RAW(8)
SQL_HASH_VALUE, -- SQL_HASH_VALUE NUMBER
SQL_ID, -- SQL_ID VARCHAR2(13)
SQL_CHILD_NUMBER, -- SQL_CHILD_NUMBER NUMBER
SQL_EXEC_START, -- SQL_EXEC_START DATE
SQL_EXEC_ID, -- SQL_EXEC_ID NUMBER
PREV_SQL_ADDR, -- PREV_SQL_ADDR RAW(8)
PREV_HASH_VALUE, -- PREV_HASH_VALUE NUMBER
PREV_SQL_ID, -- PREV_SQL_ID VARCHAR2(13)
PREV_CHILD_NUMBER, -- PREV_CHILD_NUMBER NUMBER
PREV_EXEC_START, -- PREV_EXEC_START DATE
PREV_EXEC_ID, -- PREV_EXEC_ID NUMBER
PLSQL_ENTRY_OBJECT_ID, -- PLSQL_ENTRY_OBJECT_ID NUMBER
PLSQL_ENTRY_SUBPROGRAM_ID, -- PLSQL_ENTRY_SUBPROGRAM_ID NUMBER
PLSQL_OBJECT_ID, -- PLSQL_OBJECT_ID NUMBER
PLSQL_SUBPROGRAM_ID, -- PLSQL_SUBPROGRAM_ID NUMBER
MODULE, -- MODULE VARCHAR2(48)
MODULE_HASH, -- MODULE_HASH NUMBER
ACTION, -- ACTION VARCHAR2(32)
ACTION_HASH, -- ACTION_HASH NUMBER
CLIENT_INFO, -- CLIENT_INFO VARCHAR2(64)
FIXED_TABLE_SEQUENCE, -- FIXED_TABLE_SEQUENCE NUMBER
ROW_WAIT_OBJ#, -- ROW_WAIT_OBJ# NUMBER
ROW_WAIT_FILE#, -- ROW_WAIT_FILE# NUMBER
ROW_WAIT_BLOCK#, -- ROW_WAIT_BLOCK# NUMBER
ROW_WAIT_ROW#, -- ROW_WAIT_ROW# NUMBER
TOP_LEVEL_CALL#, -- TOP_LEVEL_CALL# NUMBER
LOGON_TIME, -- LOGON_TIME DATE
LAST_CALL_ET, -- LAST_CALL_ET NUMBER
PDML_ENABLED, -- PDML_ENABLED VARCHAR2(3)
FAILOVER_TYPE, -- FAILOVER_TYPE VARCHAR2(13)
FAILOVER_METHOD, -- FAILOVER_METHOD VARCHAR2(10)
FAILED_OVER, -- FAILED_OVER VARCHAR2(3)
RESOURCE_CONSUMER_GROUP, -- RESOURCE_CONSUMER_GROUP VARCHAR2(32)
PDML_STATUS, -- PDML_STATUS VARCHAR2(8)
PDDL_STATUS, -- PDDL_STATUS VARCHAR2(8)
PQ_STATUS, -- PQ_STATUS VARCHAR2(8)
CURRENT_QUEUE_DURATION, -- CURRENT_QUEUE_DURATION NUMBER
CLIENT_IDENTIFIER, -- CLIENT_IDENTIFIER VARCHAR2(64)
BLOCKING_SESSION_STATUS, -- BLOCKING_SESSION_STATUS VARCHAR2(11)
BLOCKING_INSTANCE, -- BLOCKING_INSTANCE NUMBER
BLOCKING_SESSION, -- BLOCKING_SESSION NUMBER
FINAL_BLOCKING_SESSION_STATUS, -- FINAL_BLOCKING_SESSION_STATUS VARCHAR2(11)
FINAL_BLOCKING_INSTANCE, -- FINAL_BLOCKING_INSTANCE NUMBER
FINAL_BLOCKING_SESSION, -- FINAL_BLOCKING_SESSION NUMBER
SEQ#, -- SEQ# NUMBER
EVENT#, -- EVENT# NUMBER
EVENT, -- EVENT VARCHAR2(64)
P1TEXT, -- P1TEXT VARCHAR2(64)
P1, -- P1 NUMBER
P1RAW, -- P1RAW RAW(8)
P2TEXT, -- P2TEXT VARCHAR2(64)
P2, -- P2 NUMBER
P2RAW, -- P2RAW RAW(8)
P3TEXT, -- P3TEXT VARCHAR2(64)
P3, -- P3 NUMBER
P3RAW, -- P3RAW RAW(8)
WAIT_CLASS_ID, -- WAIT_CLASS_ID NUMBER
WAIT_CLASS#, -- WAIT_CLASS# NUMBER
WAIT_CLASS, -- WAIT_CLASS VARCHAR2(64)
WAIT_TIME, -- WAIT_TIME NUMBER
SECONDS_IN_WAIT, -- SECONDS_IN_WAIT NUMBER
STATE, -- STATE VARCHAR2(19)
WAIT_TIME_MICRO, -- WAIT_TIME_MICRO NUMBER
TIME_REMAINING_MICRO, -- TIME_REMAINING_MICRO NUMBER
TIME_SINCE_LAST_WAIT_MICRO, -- TIME_SINCE_LAST_WAIT_MICRO NUMBER
SERVICE_NAME, -- SERVICE_NAME VARCHAR2(64)
SQL_TRACE, -- SQL_TRACE VARCHAR2(8)
SQL_TRACE_WAITS, -- SQL_TRACE_WAITS VARCHAR2(5)
SQL_TRACE_BINDS, -- SQL_TRACE_BINDS VARCHAR2(5)
SQL_TRACE_PLAN_STATS, -- SQL_TRACE_PLAN_STATS VARCHAR2(10)
SESSION_EDITION_ID, -- SESSION_EDITION_ID NUMBER
CREATOR_ADDR, -- CREATOR_ADDR RAW(8)
CREATOR_SERIAL#, -- CREATOR_SERIAL# NUMBER
ECID -- ECID VARCHAR2(64)
from
GV$SESSION
where
inst_id = USERENV('Instance')