onlineredo.sql

rem ======================================================================
rem Name:  onlineredo.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   "onlineredo.sql" -
       center "Online Redo Log" -
       right  "Page:" sql.pno  skip 1 -
       right  "Date: " now  skip 3 

   SELECT group#, bytes, members   FROM v$log;


spool onlineredo.lst
/
spool off

exit