| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: shot in the dark applications performance problem....
Chris,
Some obvious suggestions:
Have your network people monitor network traffic - do simple trace routes to see if/where the delay is.
Are you using Oracle Multi-Threaded server? I have seen know bugs throw 60 second delays with database connections. You did not say what database level you are using (version #). But this is a possibility.
You need to perform some basic end-to-end tests with all of your technical staff involved. There are just too many pieces that can cause the problem.
Good Luck!
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Chris Stephens [mailto:ChrisStephens_at_affina.com]
Sent: Friday, February 13, 2004 10:34 AM
To: oracle-l_at_freelists.org
Subject: shot in the dark applications performance problem....
Let me preface all of this by stating that I realize there is very little chance of a resolution to this from the explanation I'm about to give...but it thought I'd try and describe the problem here and see if it sparks any suggestions....
The company I work for has outsourced an applications implementation. Everything has been running fine. Currently we run 2 call center apps out of the thing. This past weekend the company changed our architecture from a 1-tier system to a 2-tier system. (not sure if that's standard apps architectures or not) When the reps began taking calls after that change, performance slowed to a halt. They have now been taking phone calls on paper for 5 days now. The company has reverted back to the 1-tier architecture but the performance problem still exists. The people testing the system describe the problem as follows:
==
...one person running the call flows=>performance is fine.
...several persons running the call flows=>EXACTLY 1 minute delays between
screens.
...several more persons running the call flows=>EXACTLY 2 minute delays
between screens.
...several more persons running the call flows=>EXACTLY 3 minute delays
between screens. (weird)
==
apparently there is a script that can be run that just goes through the screens without running ANY of the database code and the wait behavior is the same. ????
I checked the machines involved from top and they are barely being worked.
I checked the waits in the database and the largest event time is from 'sqlnet message from client'.
The company restored the system to a previous incarnation and it worked just fine.
Something is very very wrong.
....and thoughts would be greatly appreciated.
Sorry for the vagueness.
...questions welcomed.
Thanks for any info!!!!
chris
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Feb 13 2004 - 09:50:51 CST
 |
 |