SQL Performance (MOSC)

MOSC Banner

Hi, is it good idea to remove bad explain plan from the dba_hist_sql_plan view directly?

edited Nov 7, 2016 5:04PM in SQL Performance (MOSC) 1 commentAnswered ✓

I have bad explain plan in the historical AWR view - dba_hist_sql_plan, that plan is really bad, so I have a plan to remove all related rows from dba_hist_sql_plan view.

The question is - it's a normal action or not? If yes, it will enough or I will needed to remove rows from another AWR views which are depends on that. Thanks.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center