Re: 11g Adaptive Cursor Sharing does not work for PL/SQL?

In PLSQL it only parses once and executes many times (not even soft parses) so I thought that adaptive cursor sharing was never going to happen. But who knows there might some way to force more parses (not using dynamic SQL)

Thanks

--
LSC



On Mon, Mar 8, 2010 at 11:15 AM, Martin Klier <usn_at_usn-it.de> wrote:



> I don't think so. My image from a cursor in PL/SQL is that the result

> set is created first, and then the loop is executed. So the SQL

> execution should not be different between user SQL and embedded SQL.

>

> Am I wrong?

> Martin

>

> LS Cheng schrieb:

> > I tested back in 2008 with 11gR1 and it didnt work.

> >

> > I thought it was understandable since in a PL/SQL for loop it would have

> to

> > peek all the time?

> >

> > Thanks

>

>

> --

> Usn's IT Blog for Linux, Oracle, Asterisk

> http://www.usn-it.de

>

>


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