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!

Want to reduce Log switch time interval !!!

shipon_97Oct 28 2008 — edited Oct 28 2008
Friends ,

I know that the standard LOG SWITCH TIme interval is 20/30 minutes , i.e., every time it is better switch redolog 1 to redolog 2 (or redolog2 to redolog3) within 20/30 minutes.

But in my production server , Logfile switches within every 60 minutes every time in the peak hour . Now my question , How I can make a situation where my logfile should switch to another logfile between 20/30 minutes .

Here my database configuration is :

Oracle database 10g (10.2.0.1.0 version) in AIX 5.3 server
AND

SQL> show parameter fast_start_mttr_target

NAME TYPE VALUE
------------------------------------ ----------- -----
fast_start_mttr_target integer 600

My every redolog file size is = 50 MB

In this situation , give me advice plz how I can reduce my logswitch time interval ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 25 2008
Added on Oct 28 2008
2 comments
1,480 views