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

VIEW: SYS.CDB_APPLY_SPILL_TXN

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

Streams apply spilled transactions info in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
APPLY_NAME VARCHAR2 (128) Yes Name of the apply that spilled the message
XIDUSN NUMBER
Yes Transaction ID undo segment number
XIDSLT NUMBER
Yes Transaction ID slot number
XIDSQN NUMBER
Yes Transaction ID sequence number
FIRST_SCN NUMBER
Yes SCN of first message in this transaction
MESSAGE_COUNT NUMBER

Number of messages spilled for this transaction
FIRST_MESSAGE_CREATE_TIME DATE

Source creation time of the first message in this transaction
SPILL_CREATION_TIME DATE

Time first message was spilled
FIRST_POSITION RAW (64)
Position of first message in this transaction
TRANSACTION_ID VARCHAR2 (128)
Transaction ID of the spilled transaction
CON_ID NUMBER

container id
Query Text

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


SELECT APPLY_NAME
,      XIDUSN
,      XIDSLT
,      XIDSQN
,      FIRST_SCN
,      MESSAGE_COUNT
,      FIRST_MESSAGE_CREATE_TIME
,      SPILL_CREATION_TIME
,      FIRST_POSITION
,      TRANSACTION_ID
,      CON_ID
FROM SYS.CDB_APPLY_SPILL_TXN;

Dependencies

[top of page]

SYS.CDB_APPLY_SPILL_TXN does not reference any database object

SYS.CDB_APPLY_SPILL_TXN is referenced by following:

SchemaPUBLIC
SynonymCDB_APPLY_SPILL_TXN