log switches occuring too quickly
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: log switches occuring too quickly

  1. #1
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547

    log switches occuring too quickly

    Oracle 8 on Solaris
    I have a situation where log switches are occuring too quickly (within seconds) at one site. log_checkpoint_interval is set to 0 and its not occuring in other sites with similar configuration.
    Any pointers on which direction to proceed?? What should I check further?

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi Raminder,
    Is your site experiencing heavy transaction which might be writing too fast into the redo log and switching.And also what is the size of your redo log files.

    Regards
    anandkl
    anandkl

  3. #3
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    How big are they?
    Do you have archivelogs - how big are they?
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  4. #4
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    The size of the redologs is about 10 M each (there are three) and its in Archivelog mode.
    Anand, how to find whether the site is featuring 'heavy' transactions and the size of transactions? I am not getting the correct dynamic view right now.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Use the following query to know just how many transactions are taking place in your system.

    select to_char(sysdate,'dd-mon-yyyy hh24:mi:ss') ttime,
    name,
    value
    from v$sysstat
    where name like '%user commit%' ;

  6. #6
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    Thanks Tamil
    The problem seems to be solving on its own. Maybe it was a temporary phase when transaction volumes/sizes increased tremendously.
    Thanks everyone for help.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Check your alert.log to see if you have any "Checkpoint not complete" messages. If not, don't worry about it. If you do have these messages, you probably need more redo for the next time you experience a heavy load.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    None of those messages right now. I will keep a track, though. Thanks Jeff.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

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