| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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 -----------------------------------------------------------------Received on Fri Feb 13 2004 - 09:33:58 CST
 |
 |