DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_2PC_PENDING

Object Details
Object Name: DBA_2PC_PENDING
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

info about distributed transactions awaiting recovery

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOCAL_TRAN_ID VARCHAR2 (22) Yes string of form: n.n.n, n a number
GLOBAL_TRAN_ID VARCHAR2 (169)
globally unique transaction id
STATE VARCHAR2 (16) Yes collecting, prepared, committed, forced commit, or forced rollback
MIXED VARCHAR2 (3)
yes => part of the transaction committed and part rolled back (commit or rollback with the FORCE option was used)
ADVICE VARCHAR2 (1)
C for commit, R for rollback, else null
TRAN_COMMENT VARCHAR2 (255)
text for "commit work comment "
FAIL_TIME DATE
Yes value of SYSDATE when the row was inserted (tx or system recovery)
FORCE_TIME DATE

time of manual force decision (null if not forced locally)
RETRY_TIME DATE
Yes 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 (128)
Oracle user name of the end-user at the topmost database
COMMIT# VARCHAR2 (16)
global commit number for committed transactions
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LOCAL_TRAN_ID
,      GLOBAL_TRAN_ID
,      STATE
,      MIXED
,      ADVICE
,      TRAN_COMMENT
,      FAIL_TIME
,      FORCE_TIME
,      RETRY_TIME
,      OS_USER
,      OS_TERMINAL
,      HOST
,      DB_USER
,      COMMIT#
FROM SYS.DBA_2PC_PENDING;

Dependencies

[top of page]

SYS.DBA_2PC_PENDING references the following:

SchemaSYS
TablePENDING_TRANS$
SYS.DBA_2PC_PENDING is referenced by following:

SchemaPUBLIC
SynonymDBA_2PC_PENDING