Configuration of Redo Logs

SET SERVEROUTPUT ON
SET ECHO OFF
SET FEEDBACK OFF
SET PAGES 80
SET LINES 132

REM
REM
REM || Title : show_redologs.sql
REM ||
REM || Purpose : This scripts shows the configuration of the redo logs.
REM ||
REM || Release No : 1
REM ||
REM || Variables : None
REM ||
REM || Schema : system
REM ||
REM


BREAK ON redo_group SKIP 1

COL sequence# FORMAT 99999999 HEADING 'Sequence' JUSTIFY L
COL First_Time FORMAT A25 HEADING 'Switch Time' JUSTIFY L
COL redo_group FORMAT 9999 HEADING 'Redo Group' JUSTIFY L
COL size_mb FORMAT 99,999,999 HEADING 'Size in MB' JUSTIFY L
COL member FORMAT A45 HEADING 'Log Name' JUSTIFY L

SELECT a.group# redo_group ,
a.bytes/1024/1024 size_mb,
a.sequence#,
b.member,
TO_CHAR(a.first_time,'DD-MON-YYYY HH24:MI:SS') First_Time
FROM v$log a,
v$logfile b
WHERE a.group# = b.group#

SPOOL show_redologs.lis
/
SPOOL OFF

COL sequence# CLEAR
COL First_Time CLEAR
COL size_mb CLEAR
COL member CLEAR
COL redo_group CLEAR

CLEAR BREAKS


SET SERVEROUTPUT ON
SET FEEDBACK ON
 
This script is provided for educational purposes only. The script has been tested and appears to work as intended. However, you should always test any script before relying on it. No responsibility will be accepted for Lost or damage that may occur from it's use.