RE: v$sql problem
- From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 7 Jul 2004 18:44:20 -0400
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@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tanel P=F5der
Sent: Wednesday, July 07, 2004 6:43 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, July 08, 2004 1:23 AM
Subject: RE: v$sql problem
> Always 1010 instead of 2000
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx =3D
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tanel P=3DF5der
> Sent: Wednesday, July 07, 2004 6:23 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
