Re: Brain Death

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 9 May 2001 15:14:42 +0100
Message-ID: <989417541.19980.0.nnrp-10.9e984b29@news.demon.co.uk>

A file copy is probably not a reasonable test. 3rd party apps are notorious for indulging in lengthy row-at-a-time dialogues with Oracle, and such dialogues are synchronous.

File transfer protocols generally work on the basis -

    Here's 8K
    Here's another 8K
    Here's another 8K
    Here's another 8K
    Here's another 8K
    Here's another 8K
    Oh, you missed the 3rd bit did you
        here it is again.

One indicator is to hit a sample session with 10046 at level 8, with timed_statistics turned on, and look at:

the number of selects/fetches
the tim = figure on each line

If there are lots of calls to the database in a short period of time, the app is at fault. If the time lag between calls is anomalous (e.g. 5/100 second between FETCH calls)
then the network, or other infrastructure item (such as Windows DLLs) could be
the problem.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Niall Litchfield wrote in message
<3af94bf7$0$12245$ed9e5944_at_reading.news.pipex.net>...


>we run a 3rd party financials solution in a WAN environment.

>

>Problem is that remote sites report a (very real) loss of performance in

>OLTP work. However

>

>a) local sites do not report this problem, suggesting database tuning is

>adequate and

>b) also report.txt gives no undue waits,locks or bad hit ratios etc.

>

>So I turn to the network. This is my weak point.

>

>File copies run at acceptable speed utilising the available bandwidth

>appropriately. Routers etc report no problems (I'm relying on my CISCO guy

>here).

>

>Network is IP only so all traffic uses same protocol. Only affected

>application appears to be this one. other oracle based solutions are

>performing normally somwehat suggesting database.

>

>Any suggestions as to where to look. especially is a file copy an adequate

>test of network performance or is there more I could do? Ping and tracert

>are OK.

>

>any suggestions that this problem has chosen to rear its ugly head after I

>went down the pub are entirely justified.

>

>

>

>--

>Niall Litchfield

>Oracle DBA

>Audit Commission UK

>

>

Received on Wed May 09 2001 - 09:14:42 CDT