v$session的一點認知

欄位 大致解釋
-------------------------------------------
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@]