Optimize Redo Log size
Hello
Running oracle 10g R2 under Sun Solaris 10.
Log swith appears every 2 minutes or less.
Our target is to make this happen every 15mn.
Based on the following information what should be the advisable redo log file?
-Values grabbed from the target database
SQL> select GROUP#,BYTES/1024/1024 Size_Mb ,MEMBERS from v$log;
GROUP# SIZE_MB MEMBERS
---------- ---------- ----------
1 50 2
2 50 2
3 50 2
SQL> SELECT OPTIMAL_LOGFILE_SIZE FROM V$INSTANCE_RECOVERY;
OPTIMAL_LOGFILE_SIZE
--------------------
77113
SQL> SELECT TARGET_MTTR, ESTIMATED_MTTR, CKPT_BLOCK_WRITES FROM V$INSTANCE_RECOVERY;
TARGET_MTTR ESTIMATED_MTTR CKPT_BLOCK_WRITES
----------- -------------- -----------------
81 73 58006326
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fast_start_mttr_target integer 3600
Note:
-From my observation 3600 is very huge for instance recovery as well as 77113Mb as recommended target redo log file.
-I guess changing 3600 to 81 or 73 should trigger oracle to provide another optimize redo log files size?
Thanks