Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Trouble with multiple versions of same statement in V$SQL
FYI, there is a BUG (3406977) that describes my original problem exactly and also a one-off patch for 9.2.0.5, at least on HPUX. And yes, it's a CURSOR_SHARING=FORCE/SIMILAR problem. Makes me wish I could have come up with better arguments as to why we needed to be programming with binds...
Rich
-----Original Message-----
Sent: Friday, September 24, 2004 9:02 AM
Subject: 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 27 2004 - 13:32:07 CDT
![]() |
![]() |