Archive_Lag_Target....

-

If you are working with Oracle than redo log files have a huge impact on the performance of the database. Its some times a huge pain how to attain an optimal size for the redo log files and the corresponding checkpointing and archiving frequency. One option is to find the redo generation rate of your database which is not so-easy option as it will keep on varying.  Second will be the sizing of the redo log files again which becomes a pain coz there is no rule of thumb( well 20minutes as per oracle) given for it. There is one parameter called Archive_lag_target which is described here in oracle docs. This is given mainly for the dataguard configurations but Howard Rodgers has given a very good explanation for using it on standalone databases too on oracle forums.  It was a good learning to know about it. Here are some links of discussion if you are interested.

How often should a database archive its logs

Redo log switch

Redo log size increase and performance

Learning never stops!

Comments

Post a Comment

Popular posts from this blog

A Poetic MasterPiece By Faraz.....

-
I am a big fan of good poetry. I am not a poet myself  but where ever I do find anything good written, I try to collect and share it. Surely enough, my first preference would always be Punjabi poetry. But there is no such thing that I wont read from any where else. Whatever is good, I try to make sure that I don't miss it! There are some poets which have created history with their writings. Late Ahmed Faraz is among those handful which wrote timeless pieces from his pen. Saying anything about him would like showing torch to the sun. So without wasting any more time, I would like to share a poetic masterpiece from him which I read today only and instantly fell in love with it. This is in Hindi and I shall translate it English in a while. Please note, this does has lots of words from Urdu as well.I shall put the meanings of those words in the end of both Hindi and English versions. First, in Hindi, Dost ban kar bhi nahin saath nibhane wala, Wohi andaaz hai jaalim ka jamane
Read more

Feelings Revealed Truly & Musically....

-
In music, out of the most pure forms of it, one is Qawalli . This is that form of music which is sung by the people who are not mere singers but devotees of God. This form of music was not a part of commercial music industry some time ago but due to its magic, its now very common to hear this in almost every where. Despite its used now in the commercial music industry, still the original form of it with minimum music instruments and claps of the singers while singing is the most popular one and remains untouchable. There are many singers who sing this form of music but some have made it a household name due to their singing. Late Nusrat Fateh Ali Khan   is among those very few who singers who are known as the masters of this devine music form. Out of millions of Qawalli songs available, there are some which hit straight in the heart. There is one that I am listening from some time and thought to share with you all. This one was specially recommended to me by my friend Sumit who himsel
Read more

Hello From Singapore….

-
Yes, I am at Singapore . Its been a while since I have come to this office where I am sitting right now, Suntec Tower 4 . The last time when I came here was in 2006. That was the first time when I came overseas for delivering a training program and this time again, the reason is same. Its so good to be back here and meet few persons whom I had met long time back and who actually taught me the few of the first lessons about the tactics of delivering a sessions. The session which I am handling right now is a VERY tough one and I am trying my best to keep things running smoothly. Hope all remains and goes fine. Its time to go for lunch. Been very long that I have seen food courts here at Suntec . Hope will find something to eat :-) .
Read more