SQL Performance (MOSC)

MOSC Banner

I upgrated my dabase (10.2.0.5 ) to (11.2.0.3) then query slower than before

edited Feb 20, 2017 12:34PM in SQL Performance (MOSC) 7 commentsAnswered

Hello,

   I upgrated my dabase (10.2.0.5 ) to (11.2.0.3) then query slower than before in version 10.2.0.5.

My new database is in a new server type ( VMware ) with the same characteritics.

To show and understand my problem I executed my query and show the differences by an explain plan.

1 - Server Physical and Database 10.2.0.4 I have :

The explain plan show 28:26 ( Time ) and the real time is (10.295 sec):

2 - VM server and database in version 11.2.0.3 I have :

The explain plan show 05:16 ( Time ) but the real time is very higher. (40.296 sec)

>>>>> Then May I conclure that my problem is and needs more resources ?

Or maybe the database works less well in a server VM ?

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