Re: SQL ordered by Physical Reads (UnOptimized)
From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Sat, 21 May 2011 21:01:53 +0300
Message-ID: <BANLkTi=fMa+Fsw7DZwrWjJmN0PFpV2-45w_at_mail.gmail.com>
I haven't played around with the "regular" flash cache in 11.2... I guess you would still see the "physical reads optimized" metric increase when hitting the in-host flash cache, but instead of "cell flash cache read hits", you'll see "physical read flash cache hits" increasing.
Date: Sat, 21 May 2011 21:01:53 +0300
Message-ID: <BANLkTi=fMa+Fsw7DZwrWjJmN0PFpV2-45w_at_mail.gmail.com>
I haven't played around with the "regular" flash cache in 11.2... I guess you would still see the "physical reads optimized" metric increase when hitting the in-host flash cache, but instead of "cell flash cache read hits", you'll see "physical read flash cache hits" increasing.
-- Tanel Poder http://blog.tanelpoder.com On Sat, May 21, 2011 at 8:25 PM, Karl Arao <karlarao_at_gmail.com> wrote:Received on Sat May 21 2011 - 13:01:53 CDT
>
> Thanks for that additional info Tanel... Hmm.. I wonder how this metric
> works on a non-exadata environment.
>
>
> --
> Karl Arao
> karlarao.wordpress.com
> karlarao.tiddlyspot.com
>
-- http://www.freelists.org/webpage/oracle-l