SQL> select * from v$recovery_progress; START_TIM TYPE ITEM UNITS SOFAR TOTAL TIMESTAMP COMMENTS --------- ---------------------------------------------------------------- -------------------------------- -------------------------------- ---------- ---------- --------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 28-JAN-15 Crash Recovery Redo Blocks Blocks 102400 102400 28-JAN-15 Crash Recovery Redo Blocks Blocks 102400 102400 28-JAN-15 Crash Recovery Log Files Files 1 1 SQL> select * from v$session_wait where wait_time=0 and wait_class <> 'Idle'; SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_CLASS_ID WAIT_CLASS# WAIT_CLASS WAIT_TIME SECONDS_IN_WAIT STATE WAIT_TIME_MICRO TIME_REMAINING_MICRO TIME_SINCE_LAST_WAIT_MICRO ---------- ---------- ---------------------------------------------------------------- ---------------------------------------------------------------- ---------- ---------------- ---------------------------------------------------------------- ---------- ---------------- ---------------------------------------------------------------- ---------- ---------------- ------------- ----------- ---------------------------------------------------------------- ---------- --------------- ------------------- --------------- -------------------- -------------------------- 243 1955 checkpoint completed 0 00 0 00 0 00 3290255840 2 Configuration 0 2 WAITING 1656096 3343904 0 SQL> SQL> SQL> spo off