SQL Performance (MOSC)

MOSC Banner

SQL Plan Change After Migration

edited Jul 17, 2015 12:08PM in SQL Performance (MOSC) 12 commentsAnswered

Hi All,

I did a migration a few months ago from a single instance to RAC database.

The issue that is happening after the migration is the slow query and when I compared between the old environment and new environment, I can see that the execution plan was different for every single query.

In the new environment, obviously the data has been increasing compared to the old one. However, the increment probably still very low as I observed from the number of rows for each table.

I still can go back to check in the old environment from time to time before the old environment is decommissioned.

Tagged:

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