I upgrated my dabase (10.2.0.5 ) to (11.2.0.3) then query slower than before
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 ?