SQL Performance (MOSC)

MOSC Banner

sql plan getting change after database upgrade from 11.2.0.4 to 12.1.0.2

edited Nov 1, 2018 5:07AM in SQL Performance (MOSC) 2 commentsAnswered

we  are  encountering the issue i.e  sql plan often  getting change  after EBS database upgrade from 11.2.0.4  to 12.1.0.2  also observed at time when sql plan getting change and optimizer choosing bad plan  .

when optimizer choosing bad plan ,we are seeing at time high hard parsing (db sequential read)  which  leading to high CPU  also high swapping leading to performance issue

Please advise how we can avoid optimizer choosing bad  plan and how to avoid hard parsing and swapping

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