This content has been marked as final. Show 2 replies
Hello Prakash,1 person found this helpful
Seems you've hit a problem. 184.108.40.206 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 220.127.116.11, for some reason 18.104.22.168 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.