SQL ordered by Physical Reads (UnOptimized)

From: kyle Hailey <kylelf_at_gmail.com>
Date: Fri, 20 May 2011 17:24:06 -0700
Message-ID: <BANLkTimVyAFMUyDKPYk0CrV=4xzV7SzG7Q_at_mail.gmail.com>



Anyone know what the 11.2.0.2 AWR report section

SQL ordered by Physical Reads (UnOptimized)

is showing?

 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

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 20 2011 - 19:24:06 CDT

Original text of this message