FAQ
Anyone know what the 11.2.0.2 AWR report section

SQL ordered by Physical Reads (UnOptimized)

is showing?

Kyle
http://dboptimizer.com

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs %Opt -
Optimized Reads as percentage of SQL Read Requests %Total - UnOptimized
Read Reqs as a percentage of Total UnOptimized Read Reqs Total Physical
Read Requests: 846,978

Captured SQL account for 100.2% of Total

Total UnOptimized Read Requests: 846,978

Captured SQL account for 100.2% of Total

Total Optimized Read Requests: 1

Captured SQL account for 0.0% of Total

UnOptimized Read Reqs Physical Read Reqs Executions UnOptimized Reqs per
Exec %Opt %Total 434,022 434,022 1 434,022.00 0 51.24 379,573 379,573 1
379,573.00 0 44.81 11,951 11,951 37 323 0 1.41 11,747 11,747 2 5,873.50 0
1.39 4,228 4,228 2 2,114.00 0 0.5 4,004 4,004 213 18.8 0 0.47 1,411 1,411
1 1,411.00 0 0.17 640 640 22,314 0.03 0 0.08 638 638 12 53.17 0 0.08 406
406 23,058 0.02 0 0.05

Search Discussions

  • Karl Arao at May 21, 2011 at 3:20 am
    Kyle,

    There's a good explanation about that metric here

    Oracle Exadata and OLTP Applications
    http://www.oracle.com/webfolder/technetwork/Exadata/MAA-BestP/OLTP/021511_93778_source/index.htm

    on slide #15 and #16

    --
    Karl Arao
    karlarao.wordpress.com
    karlarao.tiddlyspot.com

    --
    http://www.freelists.org/webpage/oracle-l
  • Tanel Poder at May 21, 2011 at 2:25 pm
    These slides fail to mention that the optimized reads statistic is also
    incremented when smart scans can "optimize IO" by avoiding doing it thanks
    to storage indexes. So, if your OLTP database has some smart scanning
    happening in it (usually thanks to various reports, etc) then the optimized
    reads may be either due to flash cache hits or storage index IO elimination.

    --
    Tanel Poder
    http://blog.tanelpoder.com
    On Sat, May 21, 2011 at 6:20 AM, Karl Arao wrote:

    Kyle,

    There's a good explanation about that metric here

    Oracle Exadata and OLTP Applications

    http://www.oracle.com/webfolder/technetwork/Exadata/MAA-BestP/OLTP/021511_93778_source/index.htm

    on slide #15 and #16
    --
    http://www.freelists.org/webpage/oracle-l
  • Karl Arao at May 21, 2011 at 5:25 pm
    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
  • Tanel Poder at May 21, 2011 at 6:01 pm
    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 wrote:


    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
  • Jonathan Lewis at May 21, 2011 at 8:59 pm
    Original Message -----
    From: "Tanel Poder"
    To:
    Cc:; "ORACLE-L"
    Sent: Saturday, May 21, 2011 3:25 PM
    Subject: Re: SQL ordered by Physical Reads (UnOptimized)
    These slides fail to mention that the optimized reads statistic is also
    incremented when smart scans can "optimize IO" by avoiding doing it thanks
    to storage indexes. So, if your OLTP database has some smart scanning
    happening in it (usually thanks to various reports, etc) then the optimized
    reads may be either due to flash cache hits or storage index IO elimination.

    --
    Tanel Poder
    http://blog.tanelpoder.com
    And why is my laptop reporting optimized reads ?

    Regards

    Jonathan Lewis
    http://jonathanlewis.wordpress.com
  • Andy Klock at May 21, 2011 at 9:47 pm
    Wow. So did you purchase a half rack for your laptop? Or did you go full?
    And why is my laptop reporting optimized reads ?

    Regards

    Jonathan Lewis
    http://jonathanlewis.wordpress.com


    --
    http://www.freelists.org/webpage/oracle-l
  • Jonathan Lewis at May 22, 2011 at 10:50 am
    Original Message -----
    From: "Andy Klock"
    To:
    Cc: "ORACLE-L"
    Sent: Saturday, May 21, 2011 10:47 PM
    Subject: Re: SQL ordered by Physical Reads (UnOptimized)
    Wow. So did you purchase a half rack for your laptop? Or did you go full?
    Half-rack, of course.

    It's only a 32-bit laptop.

    (And the full rack wouldn't fit in the overhead locker on a plane anyway)

    Regards

    Jonathan Lewis
    http://jonathanlewis.wordpress.com

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMay 21, '11 at 12:24a
activeMay 22, '11 at 10:50a
posts8
users5
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase