Re: shot in the dark applications performance problem....
- From: "Arghadeep Chatterjee" <dba@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 14 Feb 2004 12:49:10 +0530
Did you check out the Locks scenario?
Check out the Network switches and see if there are collisions?
Whats baffaling is how can the delay be exactly 1 min or 2 min something is
seriously wron?See the Locking arch ?I am quite sure something is goofy
there.
Deep
----- Original Message -----
From: Chris Stephens <ChrisStephens@xxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, February 13, 2004 9:03 PM
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
>
>
>
>
>
>
>
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
