DBPedias

All your database knowledge are belong to you

Oracle

Wait Events - writes stopped by instance recovery or database suspension

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