writes stopped by instance recovery or database suspension
This event will block a foreground process until the DBWR of the instance is allowed to do a write again. This will only happen in Parallel Server. SMON will get the IR instance lock and then do a cross instance call to all the other instances which will update a variable in the SGA to indicate that writes have been stopped. Until SMON releases the IR instance lock, foregrounds will wait on this event. Wait Time:
5 seconds in tight loop until the writes are allowed again.
|
Parameter |
Description |
|---|---|
|
bythread# |
The rollback segment id that contains the transaction that is being rolled back |
|
ourthread# |
The current instance thread number |