Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
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
Feedback

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 of the Streams apply processes in the database.

Column Datatype NULL Description
APPLY_NAME VARCHAR2(30) NOT NULL Name of the apply 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 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