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

TABLE: SYS.PENDING_SESSIONS$

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
LOCAL_TRAN_ID VARCHAR2 (22) Yes
SESSION_ID NUMBER
Yes
BRANCH_ID RAW (64) Yes
INTERFACE VARCHAR2 (1) Yes
TYPE# NUMBER

PARENT_DBID VARCHAR2 (16)
PARENT_DB VARCHAR2 (128)
DB_USERID NUMBER
Yes
Query Text

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


SELECT LOCAL_TRAN_ID
,      SESSION_ID
,      BRANCH_ID
,      INTERFACE
,      TYPE#
,      PARENT_DBID
,      PARENT_DB
,      DB_USERID
FROM SYS.PENDING_SESSIONS$;

Dependencies

[top of page]

SYS.PENDING_SESSIONS$ does not reference any database object

SYS.PENDING_SESSIONS$ is referenced by following:

SchemaSYS
ViewD$PENDING_XATRANS$
ViewDBA_PENDING_TRANSACTIONS
Package BodyDBMS_TRANSACTION - show dependent code
ViewPS1$