Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Optimize Redo Log size

Prince_AlexMay 5 2011 — edited May 5 2011
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2011
Added on May 5 2011
11 comments
1,152 views