redo log writer performance
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: redo log writer performance

  1. #1
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250

    Wink

    Happy new year to all of you !!

    I am using spotlight to monitor database performance.
    It keeps issuing warning messages for lgwr-avg redo write time is 70...going sometimes upto 400ms, my redo logs are quite big 14 groups of 50M each, also the log buffer was increased to 1.7M but no significant improvement.

    Database is running on archivelog mode.
    One member of all redolog groups are on the same device. will my moving alternate groups to another location help, in case the archive process is slowing the redo writer process down.

    Please advise.

    Thanx
    KN

  2. #2
    Join Date
    Apr 2001
    Posts
    108

    redo log writer performance

    Try this paper, they have some good ideas.

    http://www.ixora.com.au/tips/creatio..._log_files.htm
    Eric Hanson

    There are 10 types of people in the world:

    Those who understand binary and those who don't!

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