Re: What MB/s is pulled from your buffer cache?
From: Martin Klier <usn_at_usn-it.de>
Date: Tue, 12 Feb 2013 22:20:45 +0100
Message-ID: <511AB22D.1000105_at_usn-it.de>
Sorry, obviously my numbers (TB column) were wrong. This is the new one:
>
> 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...
Date: Tue, 12 Feb 2013 22:20:45 +0100
Message-ID: <511AB22D.1000105_at_usn-it.de>
Sorry, obviously my numbers (TB column) were wrong. This is the new one:
CACHE_READ_BYTES CACHE_READ_BYTES_TB STARTUP_TIME UPTIME_DAYS UPTIME_SECONDS BYTES_PER_SEC
---------------- ------------------- --------------------- ----------- -------------- ------------- 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.
Regards
Martin Klier
-- Usn's IT Blog for Linux, Oracle, Asterisk http://www.usn-it.de -- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 12 2013 - 22:20:45 CET