Hi,
We're in a 11gR2 DB where redo log files were mistakenly made with different sizes:
SQL> select group#, bytes from v$log order by 1;
GROUP# BYTES
---------- ----------
1 1073741824
2 1073741824
3 1073741824
...
8 1073741824
10 536870912
...
20 536870912
21 536870912
...
Is there a way to join this view and V$LOG_HISTORY to see what your log files average size amounts
per day (or per hour... etc. doesn't matter) over the previous days (or hours...) depending on how many
log switches you had ? Cause you've got no GROUP# column in V$LOG_HISTORY.
Thanks.
Regards,
Seb