• 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: 5,170,636
• Captured SQL account for 14.3% of Total
• Total UnOptimized Read Requests: 5,170,636
• Captured SQL account for 14.3% of Total
• Total Optimized Read Requests: 1
• Captured SQL account for 0.0% of Total
UnOptimized Reads in Oracle Database 11gR2
https://www.perftuning.com/blog/unoptimized-reads-in-oracle-database-11gr2/
AWR 中 ，这行 SQL ordered by Physical Reads (UnOptimized) 是什么意思？
http://www.itpub.net/thread-2072381-1-1.html
Exadata的东西，不用关心：）
是普通的 VMWARE 虚拟机上的数据库，
对，什么硬件都会有这个信息，但是非exadata没有参考意义
