4.88 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 |
---|---|---|---|
|
|
|
Name of the apply process that spilled one or more transactions |
|
|
|
Transaction ID undo segment number |
|
|
|
Transaction ID slot number |
|
|
|
Transaction ID sequence number |
|
|
|
PDB ID number |
|
|
|
SCN of the first message in the transaction |
|
|
|
Number of messages spilled for the transaction |
|
|
|
Source creation time of the first message in the transaction |
|
|
|
Time the first message was spilled |
|
|
|
Position of the first message in this transaction. This column is populated only for an XStream inbound server. |
|
|
|
Transaction ID of the spilled transaction |