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 |