SEO

#1 (**permalink**) 02-25-2008, 02:23 AM

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.

#2 (**permalink**) 02-25-2008, 02:24 AM

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

#3 (**permalink**) 02-25-2008, 02:29 AM

On Thu, 16 Feb 2006 21:58:54 -0800, serge 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.

Maybe you should post your question few more times to elicit some
answers? Have you considered cross-posting to all oracle groups?

--
http://www.mgogala.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

PL/SQL statements caching in a Dedicated Server mode