Database DataWarehousing (MOSC)

MOSC Banner

Alternative execution plan for the SQL

edited Aug 18, 2017 5:04AM in Database DataWarehousing (MOSC) 2 commentsAnswered

Hi All, I have a below query which is performing very badly. I ran the SQL Tuning advisor which gave me the better execution plan. I ran the accept_sql_profile for query to accept the new plan but still my query is using the old plan. Query is running in the background and i am trying to change the execution plan dynamically.

RECOMMENDATIONS

----------------------------------------------------------------------------------------------------

GENERAL INFORMATION SECTION

-------------------------------------------------------------------------------

Tuning Task Name   : 38fzp0r4mbbmc_TUNING_TASK1

Tuning Task Owner  : SYS

Workload Type      : Single SQL Statement

Scope              : COMPREHENSIVE

Time Limit(seconds): 180

Completion Status  : COMPLETED

Started at         : 06/07/2017 14:46:31

Completed at       : 06/07/2017 14:47:21

-------------------------------------------------------------------------------

Schema Name: GPPSCH

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