undo segment extension
The undo segment is being extended or shrunk. The session must wait until the operation on the undo segment has finished. Wait Time:
0.01 seconds
|
Parameter |
Description |
|---|---|
|
segment# |
The ID of the rollback segment that is being extended or shrunk |
Advice:
Don't make rollback segments too small and also don't always use the OPTIMAL clause. This will cause rollback segments to shrink and extent numerous times.