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

Shiv Kumar Batalvi, A Legend....

-
There are so many writers in this world and there is just an ocean of literature. But despite the fact that all the writers are good and the entire literature of the world is nice, I still love Punjabi literature and its writers the most. You may call it whatever you want but this is what I really love and it has reasons. And out of all, the foremost reason is that no culture is as rich in its wealth as Punjabi culture and I have yet to read some thing which is as romantic or as painful or as joyful as Punjabi writer's writing are. There is no disrespect to anyone else or any other language but this is what my choice is! There are a lot of writers but few only have power to become immortals with their work. Only some chosen ones have a power to write fire with their words. Out of those few, Shiv Kumar Batalvi  stands apart. It wont ever happen that anyone would be able to touch even the heights where he is with his writing. Its a pity that Shiv had to leave this world so early b
Read more