Re: PL/SQL procedures and packages

Yes, well this tells you how to store your procedure into the database NOT keep it in memory.

What you need to do is use packages. This is good practice anyway as it enables you to group like objects together.

The first time a package is accessed by any user it is loaded into the SGA an remains there, accessible to all users.

John

>Hi,
>That was good advice from Stevens but I am sure that won't help u with
>the work.
>The PL/SQL compiled version stays in the memory when u compile the same.
>Then even if u delete u'r source file the compiled version will stay
>put.
>So enjoy.
>Always use CREATE OR REPLACE ...when u create procedures..it drops the
>compiled version & re-creates the procedure.
>
>Avinash
>
>Amoda Kulkarni wrote:
>>
>> Hi All,
>> How do I make PL/SQL procedures and functions stay in memory?
>>
>> Thanks in Advance
>> Amod
>
>
>
>
>
>
Received on Tue Jan 06 1998 - 00:00:00 CET