Always 1010 instead of 2000 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx = [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tanel P=F5der 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. > session_cached_cursors =3D3D 0 > cursor_space_for_time =3D3DFALSE > > These are the only 2 sessions using the database and they both are = able =3D > to find same insert statement in memory and not try to parse new = insert =3D > statement but only problem is not updating the execution column =3D > properly. ---------------------------------------------------------------- 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 -----------------------------------------------------------------