Re: shot in the dark applications performance problem....

From: Arghadeep Chatterjee <dba_at_magma.co.in>
Date: Sat, 14 Feb 2004 12:49:10 +0530
Message-ID: <007401c3f2ca$d75519a0$e50610ac@lan.magma.co.in>

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_at_affina.com> To: <oracle-l_at_freelists.org>
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_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
> -----------------------------------------------------------------

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 Sat Feb 14 2004 - 01:19:10 CST