DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: # of waits for redo log buffer space

  1. #1
    Join Date
    Mar 2001
    Posts
    18
    Hi ,

    Anybody can help me to suggest,how we can find out
    # of waits for redo log buffer space.


    Thanks
    CHEERS

  2. #2
    Join Date
    Apr 2001
    Posts
    42
    Try this query, it shows the number of requests, which should be the same as # of waits:

    select name, value from v$sysstat
    where name = 'redo log space requests'
    Utep

  3. #3
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    Quick note : while tunning, this statistic alone don´t means anything, you need to compare it with the TOTAL redo generated("redo entries"), the "redo blocks written" and the time("redo log space wait time" ).
    I have seen ** many ** books and authors saying "if the 'redo log space requests' is > X", then performance will suffer, what isn´t exactly allways right.

    Regards,

    Chiappa

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