SQL Performance (MOSC)

MOSC Banner

understanding the log advisor Section 4 Retructure SQL finding

edited Nov 14, 2013 6:58AM in SQL Performance (MOSC) 3 commentsAnswered
hello,
       I would like understand the report sql-tune that i joined.
i have found the FINDINGS SECTION (4 findings)
and in the comment 4- i do understand what i have to remove because i do not see the section 4.

which guru may help me ?

best regards
JP
        DBMS_SQLTUNE.REPORT_TUNING_TASK('TASK_64155')                                                                                                                                                          
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Text: SELECT SUM(NVL(DECODE(PCT.EXPENDITURE_CATEGORY,'R2-ACHATS',PCT.ACCT_                                                                                                                         
          BURDENED_COST,0),0)),SUM(NVL(DECODE(PCT.EXPENDITURE_CATEGORY,'R2-ACH                                                                                                                         
          ATS',0,PCT.ACCT_BURDENED_COST),0))   FROM PA_COMMITMENT_TXNS_V                                                                                                                               
          PCT,FND_FLEX_VALUES FFV,HR_ALL_ORGANIZATION_UNITS HAOU  WHERE                                                                                                                                
          PCT.PROJECT_ID = :b1  AND HAOU.ORGANIZATION_ID =                                                                                                                                             

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