On Fri, Nov 02, 2001 at 03:37:53PM -0800, another oracle dba wrote:
> Hi.
>
> I have a query which completes in about 9 sec when executed alone,
> but the time grows dramatically when I execute several similar
> queries at the same time. If I execute 3 queries the time grows to
> 27-40sec, for 5
Hi.
I have a query which completes in about 9 sec when executed alone,
but the time grows dramatically when I execute several similar
queries at the same time. If I execute 3 queries the time grows
to 27-40sec, for 5 queries - toabout 1min, for 20 queries ran
simultaniously the time jumps to 2-4