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