Every time you read an 11g AWR report you see a section called
SQL ordered by Physical Reads (UnOptimized) , an UnOptimized read in Oracle 11g is a read that is not found in the Database Smart Flash Cache. On Exadata an UnOptimized read is not found in the Database Smart Flash Cache or in the Exadata Cell Smart Flash Cache.
So don't worry if you see too much UnOptimized Read Reqs
Sources :
http://www.perftuning.com/unoptimized-reads-oracle-database-11gr2/
SQL ordered by Physical Reads (UnOptimized) , an UnOptimized read in Oracle 11g is a read that is not found in the Database Smart Flash Cache. On Exadata an UnOptimized read is not found in the Database Smart Flash Cache or in the Exadata Cell Smart Flash Cache.
So don't worry if you see too much UnOptimized Read Reqs
Sources :
http://www.perftuning.com/unoptimized-reads-oracle-database-11gr2/
No comments:
Post a Comment