Re: PL/SQL statements caching in a Dedicated Server mode

On 16 Feb 2006 21:58:54 -0800, "serge" <serg78_at_adelphia.net> wrote:

>Hello everyone, this is my question. Where are most recently executed
>PL/SQL statements stored in a DEDICATED SERVER mode? Are these
>statements stored in the shared PL/SQL area in the library cache or in
>a certain area of the PGA? If it is in the PGA, then what specific part
>
>of the PGA?
>
>Thanks.

sql statements are stored in the shared pool regardless of connection mode.

--
Sybrand Bakker, Senior Oracle DBA