Home » Other » General » Oracle Apps / DB Server Response Slow (11.5.8/ windows 2003 Server)
Oracle Apps / DB Server Response Slow [message #343467] Wed, 27 August 2008 06:41 Go to next message
umar79
Messages: 3
Registered: June 2008
Location: Dubai
Junior Member
Hello All
We have migrated our oracle single tire server into dual tire one (db server) other (apps, applet, concurent servers) for Oracle E-Busniess Suite ver. 11.5.8 with OS Win Server 2003 with some newly updated server machines.

After migration its performance become very poor. we have more then 100 users on 8 different location all over UAE.

Any body have an idea why servers are reponsing poorly. While we restart the application so many time and in contact with Oracle Corrportation.

Regards
Umar Farooq
Re: Oracle Apps / DB Server Response Slow [message #343526 is a reply to message #343467] Wed, 27 August 2008 08:21 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Becuase it is bad your using WINDOWS for oracle application.

after migration did you gather DATABASE/SCHEMA statistics.?
Re: Oracle Apps / DB Server Response Slow [message #343550 is a reply to message #343526] Wed, 27 August 2008 09:00 Go to previous messageGo to next message
umar79
Messages: 3
Registered: June 2008
Location: Dubai
Junior Member
Yes we did.
Re: Oracle Apps / DB Server Response Slow [message #343557 is a reply to message #343550] Wed, 27 August 2008 09:15 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Then generate STATSPACK/AWR report and analyze.

Previous Topic: CSI Number
Next Topic: dba questions
Goto Forum:
  


Current Time: Fri Mar 29 09:41:59 CDT 2024