SQL Performance (MOSC)

MOSC Banner

I have query, we have the successfull plan.But when ever App team runs the query they were running t

edited Apr 18, 2017 5:03AM in SQL Performance (MOSC) 3 commentsAnswered

Hello Team,

Here is my scenario:

I have sql_id and I have good plan  working for that query. But the plan is getting changed since App team is running stats before that batch Job. I tried to force use that plan, still it is changing. Is there a way that I can do hard enforce that plan for that query irrespective of stats been run?

This issue is on Prod, so help in getting this resolved.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center