SQL Performance (MOSC)

MOSC Banner

Understanding DBMS_SQLTUNE.REPORT_TUNING

edited Nov 11, 2017 4:00AM in SQL Performance (MOSC) 7 commentsAnswered

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         
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center