SQL> select * from v$log_history;
791445Sep 29 2010 — edited Sep 29 2010SQL> select * from v$log_history;
RECID STAMP THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIM NEXT_CHANGE#
---------- ---------- ---------- ---------- ------------- --------- ------------
1 726598206 1 1 190578 08-AUG-10 467652
2 726663400 1 2 467652 09-AUG-10 719320
3 726758063 1 3 719320 10-AUG-10 1044278
(1)From this output how I can know that how often archivelog is getting genarated what should be the actual interval of genaration.
(2)How can I know the size of redolog group & it's member's size.
(3)How can I determine that these sizes are perfect with my DB(Because of performance issue).