[Home] [Help] [Dependency Information]
Object Name: | DBA_2PC_PENDING |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
info about distributed transactions awaiting recovery
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 |
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;
|
|
|