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

TABLE: SYS.PENDING_TRANS$

Object Details
Object Name: PENDING_TRANS$
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
I_PENDING_TRANS1 NORMAL UNIQUE TablespaceSYSTEM ColumnLOCAL_TRAN_ID
Columns
Name Datatype Length Mandatory Comments
LOCAL_TRAN_ID VARCHAR2 (22) Yes
GLOBAL_TRAN_FMT NUMBER
Yes
GLOBAL_ORACLE_ID VARCHAR2 (64)
GLOBAL_FOREIGN_ID RAW (64)
TRAN_COMMENT VARCHAR2 (255)
STATE VARCHAR2 (16) Yes
STATUS VARCHAR2 (1) Yes
HEURISTIC_DFLT VARCHAR2 (1)
SESSION_VECTOR RAW (4) Yes
RECO_VECTOR RAW (4) Yes
TYPE# NUMBER

FAIL_TIME DATE
Yes
HEURISTIC_TIME DATE

RECO_TIME DATE
Yes
TOP_DB_USER VARCHAR2 (128)
TOP_OS_USER VARCHAR2 (64)
TOP_OS_HOST VARCHAR2 (128)
TOP_OS_TERMINAL VARCHAR2 (255)
GLOBAL_COMMIT# VARCHAR2 (16)
SPARE1 NUMBER

SPARE2 VARCHAR2 (128)
SPARE3 NUMBER

SPARE4 VARCHAR2 (128)
Query Text

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


SELECT LOCAL_TRAN_ID
,      GLOBAL_TRAN_FMT
,      GLOBAL_ORACLE_ID
,      GLOBAL_FOREIGN_ID
,      TRAN_COMMENT
,      STATE
,      STATUS
,      HEURISTIC_DFLT
,      SESSION_VECTOR
,      RECO_VECTOR
,      TYPE#
,      FAIL_TIME
,      HEURISTIC_TIME
,      RECO_TIME
,      TOP_DB_USER
,      TOP_OS_USER
,      TOP_OS_HOST
,      TOP_OS_TERMINAL
,      GLOBAL_COMMIT#
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
FROM SYS.PENDING_TRANS$;

Dependencies

[top of page]

SYS.PENDING_TRANS$ does not reference any database object

SYS.PENDING_TRANS$ is referenced by following:

SchemaSYS
ViewD$PENDING_XATRANS$
ViewDBA_2PC_PENDING
ViewDBA_PENDING_TRANSACTIONS
Package BodyDBMS_PITR - show dependent code
Package BodyDBMS_TRANSACTION - show dependent code