Database Tuning (MOSC)

MOSC Banner

conflicting reports in tuning

edited Aug 24, 2014 5:00AM in Database Tuning (MOSC) 4 commentsAnswered

I ran ADDM report and its asking me to run SQL tuning advisor on the UPDATE statement but when i run SQL tuning advisor its saying no recommendations are needed?

   Recommendation 3: SQL Tuning
   Estimated benefit is .31 active sessions, 15.37% of total activity.
   -------------------------------------------------------------------
   Action
      Run SQL Tuning Advisor on the INSERT statement with SQL_ID
      "1d4zjkqjjkt6w".
      Related Object
         SQL statement with SQL_ID 1d4zjkqjjkt6w.
         INSERT INTO TRAFFIC_EVENT_HISTORY(SRC_ROW_SEQUENCE_NO,TRAFFIC_EVENT_I
         D,MESSAGE_CD,HIST_ETC_NO,HIST_TRAFFIC_TYPE_CD,HIST_COLLECTED_TOLL_AM,
         HIST_CHARGED_TOLL_AM,HIST_FULL_TOLL_AM,SOURCE_PROCESSED_TS,SOURCE_SYS

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