REM
REM DBAToolZ NOTE:
REM	This script was obtained from DBAToolZ.com
REM	It's configured to work with SQL Directory (SQLDIR).
REM	SQLDIR is a utility that allows easy organization and
REM	execution of SQL*Plus scripts using user-friendly menu.
REM	Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM 
REM File:
REM 	s_log_avg_entry.sql
REM
REM <SQLDIR_GRP>LOG</SQLDIR_GRP>
REM 
REM Author:
REM 	Vitaliy Mogilevskiy 
REM	VMOGILEV
REM	(www.dbatoolz.com)
REM 
REM Purpose:
REM	<SQLDIR_TXT>
REM	lists avarage size of redo log entry
REM	</SQLDIR_TXT>
REM	
REM Usage:
REM	s_log_avg_entry.sql NUM_OF_CONC_USERS
REM 
REM Example:
REM	s_log_avg_entry.sql 100
REM
REM
REM History:
REM	08-01-2001	VMOGILEV	Created
REM
REM

select &num_of_concurrent_users*(redo_size.value+redo_wastage.value)/redo_entries.value/1024 avg_log_entry_in_KB
,       redo_size.value/1024/1024 redo_size_in_MB
,       redo_wastage.value/1024/1024 redo_wastage_in_MB
,       redo_entries.value redo_entries_COUNT
from  (select value from v$sysstat where name='redo size') redo_size
,     (select value from v$sysstat where name='redo entries') redo_entries
,     (select value from v$sysstat where name='redo wastage') redo_wastage
/