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