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 |