Hi guru,
in awr i've read this section:
Module: JDBC Thin Client
SELECT DISTINCT ................................
2,965 3,114 9 346.0 4.8 0.3 46yd4cxsngmqy
Module: JDBC Thin Client
^LSQL ordered by Physical Reads (UnOptimized)DB/Inst: DININV/dininv1 Snaps: 15
-> 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: 6,628,255
-> Captured SQL account for 36.2% of Total
-> Total UnOptimized Read Requests: 911,592
-> Captured SQL account for 13.6% of Total
-> Total Optimized Read Requests: 5,716,663
-> Captured SQL account for 39.8% of Total
UnOptimized Physical UnOptimized
Read Reqs Read Reqs Executions Reqs per Exe %Opt %Total SQL Id
----------- ----------- ---------- ------------ ------ ------ -------------
SELECT DISTINCT ........................................
Can every one explain what it means?
thanks all.