Below is 2 sql plan for same query which is problematic gotten from awrsqrpt report. Which one of th
SQL ID: 3083m
- 1st Capture and Last Capture Snap IDs refer to Snapshot IDs witin the snapshot range
- Select acid,racid,cct_code,schm,ol_id,gl
| # | Plan Hash Value | Total Elapsed Time(ms) | Executions | 1st Capture Snap ID | Last Capture Snap ID |
|---|---|---|---|---|---|
| 1 | 3751407627 | 6,589,346 | 42 | 7701 | 7701 |
| 2 | 1691814405 | 0 | 0 | 7701 | 7701 |
0