字段 大致解释
-------------------------------------------
SADDR 会话在内存的地址

------------------------------------------
SID 唯一标示一个会话
SERIAL#

-------------------------------------------
PADDR $process.addr

-------------------------------------------
USER# user$.user#
USERNAME

-------------------------------------------
COMMAND
OWNERID

-------------------------------------------
TADDR v$transaction.addr
LOCKWAIT v$lock.kaddr

-------------------------------------------
STATUS
SERVER

-------------------------------------------
SCHEMA#
SCHEMANAME
OSUSER

-------------------------------------------
PROCESS 服务器进程的父进程server.ppid

-------------------------------------------
MACHINE
TERMINAL
PROGRAM
TYPE

-------------------------------------------
SQL_ADDRESS v$sql.addr
SQL_HASH_VALUE v$sql.hash_value
PREV_SQL_ADDR v$sql.addr previous 即同一个会话执行的上一条sql
PREV_HASH_VALUE v$sql.hash_value previous

-------------------------------------------
MODULE dbms_application_info.set_module(module,action)
MODULE_HASH

ACTION
ACTION_HASH

-------------------------------------------
CLIENT_INFO dbms_application_info.set_client_info()

-------------------------------------------
FIXED_TABLE_SEQUENCE

-------------------------------------------
此四个字段构成了 rowid

ROW_WAIT_OBJ# 操作对象id
ROW_WAIT_FILE# 数据文件号
ROW_WAIT_BLOCK#
ROW_WAIT_ROW#
如果没有发生rowid变化的话，
ROW_WAIT_BLOCK# ROW_WAIT_ROW# 为0

-------------------------------------------
LOGON_TIME
LAST_CALL_ET 上次执行到现在消耗的时间

-------------------------------------------
parallel dml usefule for smp(Symmetric Multi Processing) server

PDML_ENABLED
PDML_STATUS
PDDL_STATUS
PQ_STATUS

-------------------------------------------
oci failover (tns)

FAILOVER_TYPE
FAILOVER_METHOD
FAILED_OVER

-------------------------------------------
user profile
RESOURCE_CONSUMER_GROUP
CURRENT_QUEUE_DURATION

---------------------------------------------
CLIENT_IDENTIFIER show parameter client

[@more@]