redoinfo.sql
---***************************** ---* Commits Class Info * ---* By Eini Trujillo. Vzla * ---* July 2014 * ---* Created : 12/08/2014 * ---* Updated : 02/09/2014 * ---* version 1.01 * ---***************************** PROMPT PROMPT ----- Redo Log Files SET LIN 120 set verif off set echo off SET FEEDBACK off set timing off set time off COL MEMBER FOR A64 HEADING "Redo Log File" COL WARNING FOR A11 HEADING "Multiplexed" JUS CENTER COL DAY FOR A12 COL Max_Redo_perHour FOR 9999 HEADING "Max. RedoLog Switch|per Hour" COL Avg_Redo_perHour FOR 9999 HEADING "Avg. RedoLog Switch|per Hour" COL Avg_Min_Switch FOR 9999 HEADING "Avg. RedoLog Switch Time|(Min)" COL Size_MB FOR 999999 HEADING "Size MB" COL Avg_Redo_perDay FOR 999 , 999 HEADING "Avg. RedoLog| Switch per Day" JUS CENTER COL Avg_SizeDay