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