Re: Brain Death

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:989417541.19980.0.nnrp-10.9e984b29_at_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.

Thanks for the info.

>
> One indicator is to hit a sample session
> with 10046 at level 8, with timed_statistics
> turned on, and look at:
> a) the number of selects/fetches
> b) 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.

Thanks I'll be trying this suggestion.

--
Niall Litchfield
Oracle DBA
Audit Commission UK