This content has been marked as final. Show 2 replies
Hello Prakash,1 person found this helpful
Seems you've hit a problem. 18.104.22.168 should have improved performance in your case. Have you filed an SR?
Please include the following information.
1) Are you in the same environment? If not how do they differ.
2) Are the system parameters the same for each database?
3) Attach a reproducible test case to the SR.
4) If you have both environments please generate an AWR Report for each. Take a AWR snapshot before and after your tests then generate a report for those snap_id's.
Hi Jameson - Thanks for your response.
We thought that would be the case. Have raised a SR with oracle and they are investigating on it. We have also sent an EIFF file to Oracle for investigation.
Both the DBs are in the same environment (AIX 6.1) and DBAs have confirmed both the DBs have the same system parameters.
Even if we keep aside comparing to 22.214.171.124, for some reason 126.96.36.199 seems to be very slow. Even a simple cube (2 Dim and 2 Measures) with 9K records takes around 15 min to get refreshed and it takes ages to view the data.
Havent generated the AWR report, will see if we can do the same.