undo segment recovery
PMON is rolling back a dead transaction. The wait continues until rollback finishes. Wait Time:
3 seconds
|
Parameter |
Description |
|---|---|
|
segment# |
The ID of the rollback segment that contains the transaction that is being rolled back |
|
tx flags |
The transaction flags (options) set for the transaction that is being rolled back |
Transaction control flags
|
Flag |
Meaning |
|---|---|
|
0x1 |
TX has started storing collecting information |
|
0x2 |
TX has forced the collecting information |
|
0x4 |
Prepared TX needs distributed recovery |
|
0x10 |
Rollback failed on this TX, SMON to recover |
|
0x20 |
TX has rollback its updates |
Advice:
In Parallel Server mode the Global enqueue TA is acquired to recover the transaction. If the TA lock can't be obtained wait on this event and try again.