Re: What MB/s is pulled from your buffer cache?

From: Martin Klier <>
Date: Tue, 12 Feb 2013 22:20:45 +0100
Message-ID: <>

Sorry, obviously my numbers (TB column) were wrong. This is the new one:


---------------- ------------------- --------------------- -----------
-------------- -------------
         2.5E+16         22718.03589 16.12.2012 18:11:49         58.17
      5025692    4970209998

So it's 4,970,209,998 Bytes per second overall. Fairly less than yours. :)

Background: This is a devel DB, so usually they are doing fuzzy stuff.

Martin Klier schrieb:

>> It's over 100MB/s, which my knee jerk (emphasis on the latter) tells me that
>> this seems abnormally high for our li'l DB.
>> I'm curious to see how that number compares to other installations, if folks
>> are willing.

> This heavily depends on the quality of your execution plans - have a
> look at SQL "SQL ordered by Buffer Gets" in AWR/Statspack reports. I
> don't think that number to be abnormally high...

> The DB is less than 2TB.

Martin Klier

Usn's IT Blog for Linux, Oracle, Asterisk

Received on Tue Feb 12 2013 - 22:20:45 CET

Original text of this message