Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 11g R2 - AWR Section UnOptimized Read Reqs / Optimized Read Reqs

725921Mar 16 2011 — edited Jun 30 2011
Hello guys,
using Oracle 11g R2 more and more i have checked out the new AWR and its sections.

I have found some section lke this
SQL ordered by Physical Reads (UnOptimized)DB/Inst: SID/sid  Snaps: 20296-202
-> 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:         151,508
-> Captured SQL account for   25.3% of Total
-> Total UnOptimized Read Requests:         151,508
-> Captured SQL account for   25.3% of Total
-> Total Optimized Read Requests:               1
-> Captured SQL account for    0.0% of Total
What the heck is "Optimized Read Reqs" and "UnOptimized Read Reqs"? These terms are used very often right now in AWR of Oracle 11g R2.

Does anyone know what this term means and how it is defined? Don't find any information on web and documentation.

Thanks guys!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 28 2011
Added on Mar 16 2011
6 comments
4,990 views