RE: v$sql problem

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Wed, 7 Jul 2004 18:44:20 -0400
Message-ID: <D6424CD4C8A3C044BBC49877ED51C5187D925A@ex2003.metratech.com>

10g on win2k
I am selecting 1000 records using bulk collect limit 1000 and insert = using forall loop........
If both sessions run serially they update 1000 correctly.......

-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tanel P=F5der Sent: Wednesday, July 07, 2004 6:43 PM
To: oracle-l_at_freelists.org
Subject: Re: v$sql problem

Hm, starts to sound like a bug for me, if you're following exactly the = same
procedures in both sessions..

Which version/platform?
Can you elaborate, how are you doing the insert batches? From pl/sql or = from
some external client?

What happens when you run both sessions serially, not concurrently?

Tanel.

Original Message -----=20 From: "Harvinder Singh" <Harvinder.Singh_at_MetraTech.com> To: <oracle-l_at_freelists.org> Sent: Thursday, July 08, 2004 1:23 AM Subject: RE: v$sql problem

> Always 1010 instead of 2000
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org =3D
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tanel P=3DF5der
> Sent: Wednesday, July 07, 2004 6:23 PM
> To: oracle-l_at_freelists.org
> Subject: Re: v$sql problem
>
> So, every time you run them in parallel, does the execution count =
always
> increment by 1010 or does the number fluctuate somewhat?
>
> Tanel.

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 Wed Jul 07 2004 - 17:41:01 CDT