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: 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没有参考意义