| 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....
You asked for any thoughts....
I've seen a similar case to yours. In the 1-tier environment, users connected under their own Oracle accounts. In the 3-tier environment users connected as a generic WEB_USER account. It turned out that there was a TRANSACTIONS table that tracked activity by locking a row based on the username. When everyone had separate logins; no problem. But contention occurred now that all were logging in under the same account.
A simple lock monitoring script would reveal this problem.
You could provide platform and version information, and whether you have introduced any new software (Forms?) or made configuration changes.
Ray
-----Original Message-----
From: Chris Stephens [mailto:ChrisStephens_at_affina.com]
Sent: Friday, February 13, 2004 3:34 PM
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 ----------------------------------------------------------------- ___________________________________________________________________________ This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. ---------------------------------------------------------------- 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 - 10:14:54 CST
 |
 |