[QUOTE][i]Originally posted by sonaliak [/i]
[B]If I understand you Pando, you said that log buffer will flush every 1 mb no matter what it size is ?
Then why would one need log buffer bigger than 1 mb ?
What should be the size of log buffer than ??

Thanks
Sonali [/B][/QUOTE]

Yes why would someone need buffer bigger than 1MB? Well maximum I have used is 3MB because 1/3 of 3MB is 1mb so buffer will be flushed every MB

Now in my previous post I mentioned *unless* there is a hidden parameter we dont know otehrwise, yes log buffer is flushed every 1mb no matter how big is your buffer, this is explained in Oracle 8i concepts manual. The 1/3 algorithm you can change it to other values though, there is a parameter that does the job