Oracle's v$session Performance view

1, v$session table structure

sql> desc v$session;

is the name empty? Type

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

Saddr RAW (8)

SID number

serial# number

Audsid number

Paddr RAW (8)

user# number

USERNAME VARCHAR2 (30)

COMMAND number

ownerID number

Taddr VARCHAR2 (16)

Lockwait VARCHAR2 (16)

STATUS VARCHAR2 (8)

SERVER VARCHAR2 (9)

schema# number

SCHEMANAME VARCHAR2 (30)

Osuser VARCHAR2 (30)

PROCESS VARCHAR2 (12)

MACHINE VARCHAR2 (64)

TERMINAL VARCHAR2 (16)

Program VARCHAR2 (64)

TYPE VARCHAR2 (10)

Sql_address RAW (8)

Sql_hash_value number

sql_id VARCHAR2 (13)

Sql_child_number number

Prev_sql_addr RAW (8)