Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


DBA_APPLY_SPILL_TXN displays information about the transactions spilled from memory to hard disk by all apply processes in the database.

Column Datatype NULL Description
APPLY_NAME VARCHAR2(30) NOT NULL Name of the apply process that spilled one or more transactions
XIDUSN NUMBER NOT NULL Transaction ID undo segment number
XIDSLT NUMBER NOT NULL Transaction ID slot number
XIDSQN NUMBER NOT NULL Transaction ID sequence number
FIRST_SCN NUMBER NOT NULL SCN of the first message in the transaction
MESSAGE_COUNT NUMBER   Number of messages spilled for the transaction
FIRST_MESSAGE_CREATE_TIME DATE   Source creation time of the first message in the transaction
SPILL_CREATION_TIME DATE   Time the first message was spilled
FIRST_POSITION RAW(64)   Reserved for internal use
TRANSACTION_ID VARCHAR2(128)   Transaction ID of the spilled transaction