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

VIEW: SYS.DBA_APPLY_SPILL_TXN

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

Streams apply spilled transactions info

[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.DBA_APPLY_SPILL_TXN;

Dependencies

[top of page]

SYS.DBA_APPLY_SPILL_TXN references the following:

SchemaSYS
View_DBA_APPLY_SPILL_TXN
SYS.DBA_APPLY_SPILL_TXN is referenced by following:

SchemaPUBLIC
SynonymDBA_APPLY_SPILL_TXN
SchemaSYS
ViewALL_APPLY_SPILL_TXN
Package BodyDBMS_STREAMS_AUTO_INT - show dependent code