undo segment tx slot

Wait for a transaction slot to become available within the selected rollback segment. Continue waiting until the slot is available. The number of transaction slots in the rollback segment can be obtained from the internal view X$KTUXE. It has the details about the undo segement slots. You can count for the number of slots per USN.

select  count ktuxeslt from X$ktuxe group by ktuxeusn

Wait Time:

1 second