Re: 11g Adaptive Cursor Sharing does not work for PL/SQL?
- From: LS Cheng <exriscer@xxxxxxxxx>
- To: Martin Klier <usn@xxxxxxxxx>
- Date: Mon, 8 Mar 2010 11:44:48 +0100
Hi
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@xxxxxxxxx> 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
>
>
Other related posts:
