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

From: Martin Klier <>
Date: Mon, 08 Mar 2010 11:15:36 +0100
Message-ID: <>

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?

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

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

Original text of this message