View Single Post

   
  #2 (permalink)  
Old 02-25-2008, 03:24 AM
Sybrand Bakker
 
Posts: n/a
Default 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
Reply With Quote