redo space wait ratio
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: redo space wait ratio

  1. #1
    Join Date
    Aug 2000
    Location
    NJ
    Posts
    54

    Angry

    Hi ,

    I am runnign oracle 8i database.
    I used TOAD to check the hit ratio and later I found that
    the redo space wait ratio = 1.7567.
    What do I do to improve performace.
    I am also seeing high parse to execute ratio = 100.54

    Please advice.

    Geo

  2. #2
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    high parse to execute ratio,look at this recent thread
    http://www.dbasupport.com/forums/sho...threadid=11292

    Gert

  3. #3
    Join Date
    Aug 2000
    Location
    NJ
    Posts
    54
    Thanks,

    What about the redo space wait ratio = 1.7567.




    geo

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Add more redo logs. To reduce the waits, also make sure that they are sufficient enough.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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