RE: Trouble with multiple versions of same statement in V$SQL
- From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
- To: "Steve Adams" <steve.adams@xxxxxxxxxxxx>, "ORACLE-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>, <jonathan@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 24 Sep 2004 09:01:31 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
