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

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

Go to previous page
Previous
Go to next page
Next
View PDF

DBA_APPLY_SPILL_TXN

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)   Position of the first message in this transaction

This column is populated only for an XStream inbound server.

TRANSACTION_ID VARCHAR2(128)   Transaction ID of the spilled transaction