Re: PL/SQL statements caching in a Dedicated Server mode On 16 Feb 2006 21:58:54 -0800, "serge" <serg78@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 |