The session waits for SMON to enable or disable cache or transaction recovery. This usually happens during ALTER DATABASE OPEN or CLOSE.
Wait Time: Wait time depends on the amount of time the action takes (that is, the amount of recovery needed)
| Parameter | Description |
|---|---|
|
layer |
This value can be 1 or 2. If 1, it means that the transaction layer wants transaction recovery to be performed. If 2, it means that cache recovery will be performed. |
|
value |
This value can be 0 (disable) or 1 (enable) |
|
waited |
The number of seconds waited so far |