LOCAL_TRAN_ID
|
VARCHAR2(22)
|
NOT NULL
|
String of form: n.n.n; n is a number
|
GLOBAL_TRAN_ID
|
VARCHAR2(169)
|
|
Globally unique transaction ID
|
STATE
|
VARCHAR2(16)
|
NOT NULL
|
Collecting, prepared, committed, forced commit, or forced rollback
|
MIXED
|
VARCHAR2(3)
|
|
YES indicates part of the transaction committed and part rolled back
|
ADVICE
|
VARCHAR2(1)
|
|
C for commit, R for rollback, else NULL
|
TRAN_COMMENT
|
VARCHAR2(2000)
|
|
Text for commit work comment text
|
FAIL_TIME
|
DATE
|
NOT NULL
|
Value of SYSDATE when the row was inserted (transaction or system recovery)
|
FORCE_TIME
|
DATE
|
|
Time of manual force decision (null if not forced locally)
|
RETRY_TIME
|
DATE
|
NOT NULL
|
Time automatic recovery (RECO ) last tried to recover the transaction
|
OS_USER
|
VARCHAR2(64)
|
|
Operating system-specific name for the end-user
|
OS_TERMINAL
|
VARCHAR2(255)
|
|
Operating system-specific name for the end-user terminal
|
HOST
|
VARCHAR2(128)
|
|
Name of the host machine for the end-user
|
DB_USER
|
VARCHAR2(30)
|
|
Oracle user name of the end-user at the topmost database
|
COMMIT#
|
VARCHAR2(16)
|
|
Global commit number for committed transactions
|