Oracle's V$session detailed

First look at what columns v$session have

Sys@orcl>desc v$session

Name Null? Type

----------------------------------------- -------- ----------------------------

Saddr RAW (4)

SID number

serial# number

Audsid number

Paddr RAW (4)

user# number

USERNAME 2 VARCHAR2 (30)

COMMAND number

ownerID number

Taddr VARCHAR2 (8)

Lockwait VARCHAR2 (8)

STATUS VARCHAR2 (8)

SERVER VARCHAR2 (9)

schema# number

SCHEMANAME VARCHAR2 (30)

Osuser VARCHAR2 (30)

PROCESS VARCHAR2 (12)

MACHINE VARCHAR2 (64)

TERMINAL VARCHAR2 (30)

Program VARCHAR2 (48)

TYPE VARCHAR2 (10)

Sql_address RAW (4)

Sql_hash_value number

sql_id VARCHAR2 (13)

Sql_child_number number

Prev_sql_addr RAW (4)

Prev_hash_value number

prev_sql_id VARCHAR2 (13)

Prev_child_number number

MODULE VARCHAR2 (48)

Module_hash number

ACTION VARCHAR2 (32)

Action_hash number

Client_info VARCHAR2 (64)

Fixed_table_sequence number

row_wait_obj# number

row_wait_file# number

row_wait_block# number

row_wait_row# number

Logon_time DATE

Last_call_et number

Pdml_enabled VARCHAR2 (3)

Failover_type VARCHAR2 (13)

Failover_method VARCHAR2 (10)

Failed_over VARCHAR2 (3)

Resource_consumer_group VARCHAR2 (32)

Pdml_status VARCHAR2 (8)

Pddl_status VARCHAR2 (8)

Pq_status VARCHAR2 (8)

Current_queue_duration number

Client_identifier VARCHAR2 (64)

Blocking_session_status VARCHAR2 (11)

Blocking_instance number

Blocking_session number

seq# number

event# number

EVENT VARCHAR2 (64)

P1text VARCHAR2 (64)

P1 number

P1raw RAW (4)

P2text VARCHAR2 (64)

P2 number

P2raw RAW (4)

P3text VARCHAR2 (64)

P3 number

P3raw RAW (4)

WAIT_CLASS_ID number

wait_class# number

Wait_class VARCHAR2 (64)

Wait_time number

Seconds_in_wait number

State VARCHAR2 (19)

Service_Name VARCHAR2 (64)

Sql_trace VARCHAR2 (8)

Sql_trace_waits VARCHAR2 (5)

Sql_trace_binds VARCHAR2 (5)

SADDR-—— The address of the current session in memory

sad--the ID number of the current session

serial#--the serial number of the session, and when a session ends, another session may reuse the session's ID number, which requires serial# to determine the unique session object. That is to say, sid+serial# to determine a unique session.

audsid--the ID number of the audit session corresponding to this session

The paddr--session corresponds to the process address, and the addr field associated with the V$process view can find the operating system process corresponding to the session.

user#--session corresponds to the user ID number, corresponding to the Dba_users user_id field

username--session corresponding user's USERNAME

command--the current command type being executed, which records a numeric value that you want to view with the following table