hi
I am Korean. so I'm not good at English.
bellow is AWR Report regarding ' SQL ordered by Physical Reads (UnOptimized))'.
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: 3,311,261
- Captured SQL account for 13.5% of Total
- Total UnOptimized Read Requests: 3,311,261
- Captured SQL account for 13.5% of Total
- Total Optimized Read Requests: 1
- Captured SQL account for 0.0% of Total
| UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text |
|---|
| 90,514 | 90,514 | 433,458 | 0.21 | 0.00 | 2.73 | 4xvcd956td1f0 | ktu1022f@kryiap3044 (TNS V1-V3) | insert into KTGWILOG (INST_NO,... |
| 73,662 | 73,662 | 433,494 | 0.17 | 0.00 | 2.22 | 1ru1faqyz5r9y | ktu1022f@kryiap3044 (TNS V1-V3) | select NVL(max(SEQ_NO), 0) int... |
| 55,876 | 55,876 | 167,095 | 0.33 | 0.00 | 1.69 | 917z2sat3xdgx | KTNSTRT@kryiap3044 (TNS V1-V3) | insert into KTJRN (INST_NO, PR... |
| 37,257 | 37,257 | 357,776 | 0.10 | 0.00 | 1.13 | 16m0ab5hhg8p5 | ktu1013f@kryiap3044 (TNS V1-V3) | insert into KTGWILOG (INST_NO,... |
| 35,135 | 35,135 | 46,415 | 0.76 | 0.00 | 1.06 | d064tdyb8gn18 | JDBC Thin Client | insert into ktgwilog (inst_no,... |
| 31,870 | 31,870 | 176 | 181.08 | 0.00 | 0.96 | 9um84jdyfbpvu | SWN1000F@kryiap3044 (TNS V1-V3) | select JRN_NO , BUSINESS_DATE ... |
| 28,277 | 28,277 | 1 | 28,277.00 | 0.00 | 0.85 | 2fanpnu3hbsxb | ELN2002F@kryiap3044 (TNS V1-V3) | select F_ID into :b0 from PCEL... |
| 10,630 | 10,630 | 22,727 | 0.47 | 0.00 | 0.32 | 2gfjgbp685w0g | KTN1201F@kryiap3044 (TNS V1-V3) | insert into KTCOJRNSAF (INST_N... |
| 7,902 | 7,902 | 6 | 1,317.00 | 0.00 | 0.24 | 3gh6vrrh36u61 | PCB2700F@kryiap3044 (TNS V1-V3) | select PTYP , CIFN , HGJA , C_... |
| 7,436 | 7,436 | 6,065 | 1.23 | 0.00 | 0.22 | d0h32pkvpsyp8 | PCN2120F@kryiap3044 (TNS V1-V3) | insert into PCELNJRN (INST_NO,... |
Back to SQL Statistics
Back to Top
Question 1) I want to know what is the mean by 'UnOptimized Read Reqs' and 'Optimized Read Reqs '
Question 2) Please give me an advice what is 'SQL ordered by Physical Reads tuning'
Thank you.