Tuning: very frequent log switches..... - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Tuning: very frequent log switches.....

  1. #11
    Join Date
    Jan 2001
    Posts
    318
    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

  2. #12
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    [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
  •  



Click Here to Expand Forum to Full Width