Re: procedure call with multiple children

• Original Message ----- From: "Christo Kutrovsky" <kutrovsky.oracle_at_gmail.com> To: "oracle-l" <oracle-l_at_freelists.org> Sent: Wednesday, April 27, 2005 5:35 PM Subject: procedure call with multiple children

The call looks like this:

call package.procedure(:1,:2)

As you can see, it uses 2 parameters which are bound via bind variables.

And we would have 400+ versions of this sql, but only 50-ish rows in v$sql_shared_cursor.

And why would we have 400+ versions of this exact same procedure call.

FYI:=20
cursor_sharing is FORCE
9i database

--=20

Christo Kutrovsky
Database/System Administrator
The Pythian Group
--

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

Given that you have cursor_sharing = force, can you confirm that the call is with REAL bind variables and not system-generated bind variables - viz: :"SYS_B_0" and :"SYS_B_1". Also, what language are you using to call the procedure ?

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Public Appearances - schedule updated April 5th 2005

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 27 2005 - 15:05:42 CDT