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

VIEW: SYS.ALL_APPLY_SPILL_TXN

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

Streams apply spilled transactions info to the user

[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
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
FROM SYS.ALL_APPLY_SPILL_TXN;

Dependencies

[top of page]

SYS.ALL_APPLY_SPILL_TXN references the following:

SchemaSYS
ViewALL_APPLY
ViewDBA_APPLY_SPILL_TXN
SYS.ALL_APPLY_SPILL_TXN is referenced by following:

SchemaPUBLIC
SynonymALL_APPLY_SPILL_TXN