SQL ordered by Physical Reads (UnOptimized)
- From: kyle Hailey <kylelf@xxxxxxxxx>
- To: ORACLE-L <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 20 May 2011 17:24:06 -0700
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
Other related posts:
