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

From: Martin Klier <usn_at_usn-it.de>
Date: Mon, 08 Mar 2010 11:15:36 +0100
Message-ID: <4B94CE48.4080609_at_usn-it.de>

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

Received on Mon Mar 08 2010 - 04:15:36 CST