Understanding DBMS_SQLTUNE.REPORT_TUNING
hello gurus Oracle,
I would like understand the "REPORT_TUNING_TASK" from the advisor oracle.
i read this next advisor :
>>>>>
1- Restructure SQL finding (see plan 1 in explain plans section) | |
---------------------------------------------------------------- | |
An expensive cartesian product operation was found at line ID 68 of the |
Therefore i would like understand what are the tables which have not any link between them.
I join you my report.
thank you for your help
JP
execution plan
>>>>>
I go to the ID 68 and i read :
>>>>>>
| 68 | | MERGE JOIN CARTESIAN | | | | | 14 | 5782 | | 13 (0)| 00:00:01 | | |||
| 69 | | NESTED LOOPS | | | | | | | | | | | | | |
| 70 | | NESTED LOOPS | | | | | 1 | | 94 | | 4 (0)| 00:00:01 | | ||
| 71 | | TABLE ACCESS BY INDEX ROWID| PA_PROJECTS_ALL | | | 1 | | 66 | | 3 (0)| 00:00:01 | | |||
|* 72 | | INDEX RANGE SCAN | | PA_PROJECTS_U1 |