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
Printable View
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
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 MBQuote:
Originally posted by sonaliak
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
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