RE: Trouble with multiple versions of same statement in V$SQL

It looks like I'll file a TAR to see if there actually is a problem and = to see if it's fixed in 10.2... :)

Thanks Jonathan and Steve!

Rich

-----Original Message-----
Sent: Thursday, September 23, 2004 5:10 PM Subject: RE: Trouble with multiple versions of same statement in V$SQL

Hi Rich,

If multiple sessions attempt to parse the same statement simultaneously = then they can each get their own child cursor. However, that is unlikely to give you hundreds of children unless you also have = invalidations.

My guess would be that CURSOR_SHARING =3D SIMILAR is to blame (again). = Try FORCE and the problem is likely to disappear.

@ Regards,
@ Steve Adams

--
http://www.freelists.org/webpage/oracle-l