SQL Performance (MOSC)

MOSC Banner

12c: How to force oracle to use a different plan

edited Sep 6, 2016 5:00AM in SQL Performance (MOSC) 4 commentsAnswered

Hi,

We have a sql which was running under a minute until friday.  From today morning, it is taking more than an hour to complete.   when , I checked the plan,

select  distinct SQL_ID,PLAN_HASH_VALUE from DBA_HIST_SQL_PLAN where SQL_ID='35v2mpxcqha0f';

35v2mpxcqha0f    1398877429

35v2mpxcqha0f    3144203662

it was using plan 1398877429 until friday which runs in less than a minute.   Today morning , it is using plan 3144203662.   How do I force oracle to revert back to old plan?

Thanks

Ram

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