-
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
Sonali
-
[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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|