ktm: instance recovery
The session waits for SMON to finish the instance, transaction recovery, or sort segment cleanup. Wait Time:
The wait time can vary and depends on the amount of recovery needed.
| Parameter | Description |
|---|---|
| undo segment# | If the value is 0, SMON is probably performing instance recovery. If P1 > 0, use this query to find the undo segment:
select *from v$rollstat where usn = undo segment#; |