DBA_2PC_PENDING

DBA_2PC_PENDING describes distributed transactions awaiting recovery.


Column Datatype NULL Description

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(255)

 

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 system for the end-user

DB_USER

VARCHAR2(128)

 

Oracle user name of the end-user at the topmost database

COMMIT#

VARCHAR2(16)

 

Global commit number for committed transactions