At 02:57 PM 4/02/2004 +1300, you wrote:

> >>>
> >>The transaction difference of 100 is for a short duration (10-20 secs)
> >>when the app is processing records. After that it is ok. And that is the
> >>only thing this app does.
> >>
> >>
> >
> >One "run" of this process starts 100 transactions? What is it doing (both
> >sides of the wire)?
> >
>
>There are few tables that are updated, and most of the stuff is done
>using Stor Procs.

Sandeep, if the cause of your problem is a single process that needs 100
concurrent transactions (which is pretty abnormal) then how do suppose this
"problem description" is going to help find the source of your
problem? You are reporting something that shouldn't occur. If you
seriously want to find and fix the problem, you will make the effort to
describe the conditions where it occurs. If you don't, I fail to see the
point of starting a support thread on the topic in two lists.

Helen