Re: 11g Adaptive Cursor Sharing does not work for PL/SQL?
From: LS Cheng <exriscer_at_gmail.com>
Date: Mon, 8 Mar 2010 10:54:37 +0100
Message-ID: <6e9345581003080154j73d4f8a2y2587036c39acf6a4_at_mail.gmail.com>
I tested back in 2008 with 11gR1 and it didnt work.
Date: Mon, 8 Mar 2010 10:54:37 +0100
Message-ID: <6e9345581003080154j73d4f8a2y2587036c39acf6a4_at_mail.gmail.com>
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
-- LSC On Mon, Mar 8, 2010 at 10:46 AM, Martin Klier <usn_at_usn-it.de> wrote:Received on Mon Mar 08 2010 - 03:54:37 CST
> Hi folks,
>
> it was an annoying experience, just in case you hit it:
>
>
> http://www.usn-it.de/index.php/2010/03/08/oracle-11g-adaptive-cursor-sharing-does-not-work-with-plsql/
>
> As far as I know, there is no "real" fix so far.
> Regards
> Martin Klier
> --
> Usn's IT Blog for Linux, Oracle, Asterisk
> http://www.usn-it.de
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-l