redo.sql

 

---

 rem ======================================================================
 rem Name:  redo.sql
 rem Desc:  Online Redo Log
 rem
 rem ======================================================================
 
 rem Set the general display parameters for the report:
 set pages 55
 set lines 79
 set pause off
 set echo off
 set feed 1
 set termout on
 
 rem Capture the current date and time:
 set termout off
 col currdate new_value now
 select to_char(sysdate, 'mm/dd/yy hh24:mi') currdate from dual;
 set termout on
 
 rem The title for the report:
 ttitle left   "redo.sql" -
        center "Online Redo Log" -
        right  "Page:" sql.pno  skip 1 -
        right  "Date: " now  skip 3 
 
 select * from v$logfile ;
 
 spool redo.lst
 /
 spool off
 
 exit
 

---