log size and logs generated per day

–show current redo logs, number allowed, their size, average switches per hour, switches per hour by day. See showRedo.sql
prompt
prompt >>> Total allowed redo log files <<>> Current redo logs files <<>> If greater than 4 per hour, increase size of logs << sysdate -10
group by to_char(first_time,’DDMonYY’) order by to_date(to_char(first_time,’DDMonYY’),’DDMonYY’);

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: