Calculating Free Buffer Wait
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Calculating Free Buffer Wait

  1. #1
    Join Date
    Jun 2006
    Posts
    7

    Calculating Free Buffer Wait

    Hi,
    Currently we are calculating Free Buffer Wait with following formula:
    SQL> select NAME,VALUE from V$SYSSTAT where NAME in ('free buffer inspected', 'free buffer requested');

    NAME VALUE
    -------------------------------- ------------
    free buffer requested 3194990
    free buffer inspected 3138511


    % Free Buffer Wait=
    (free buffer inspected*100)/free buffer requested

    Sometimes its going far beyond 100%(even upto >150 also).

    Is this formula correct?
    Can this be considered as a normal behavior?
    Please do let me know.

    Thanks,
    Pallavi.

  2. #2
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Wouldn't it be:

    % Free Buffer Wait=
    (free buffer inspected/free buffer requested )*100
    Assistance is Futile...

  3. #3
    Join Date
    Jun 2006
    Posts
    7
    Hi,

    The result will be same obviously,as for * and / the order does not matter.

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    What's the value for "dirty buffers inspected"?

    Tamil

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