Log Switch Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Log Switch Problem

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    Log Switch Problem

    Dear all,
    i am facing log switches every minute
    redo log space request 100452

    I have 20Mb log_buffer and 5 Redo log file groups of 10MB each
    I am facing now facing performance degradatrion ,
    Although it is very vast query (Perfomane Degradation ),Nobody can answer this in one or two sentences
    But my question is ,will it provide performance enhancement if i increase the size of redo log file size and reduce the size of redo log_buffer

    Can anybody help me in this regard

    thanx in advance

  2. #2
    Join Date
    Jun 2006
    Location
    Chennai, INDIA
    Posts
    72

    Wink

    Hi,
    Is that occured suddenly or normal to your database?

  3. #3
    Join Date
    Jun 2006
    Location
    Chennai, INDIA
    Posts
    72

    Wink

    Hi,
    Have u tried querying dba_waiters for any blocking session?

  4. #4
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    10 Megs is too low. Make them 100M
    Lowering the buffer has nothing to deal wit that
    The question does that happend lately is quite reasonable. If so, try to find what is generating so much of redo. But in general 10M is too low on OLTP systems

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,015
    You should increase the size of the redo logs, but you should also add additional redo logs, so that the logs wrap around less often.
    this space intentionally left blank

  6. #6
    Join Date
    Jan 2007
    Posts
    1
    How can i take rman ?

  7. #7
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    gmurughan what do you mean?

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