Re: PL/SQL procedures and packages

In article <34AEFF3E.591C_at_bellsouth.net>, Amoda Kulkarni <amodk_at_bellsouth.net> writes
>Hi All,
> How do I make PL/SQL procedures and functions stay in memory?
>
>Thanks in Advance
>Amod

Amod,

Packages can be pinned into the buffer pool via the dbms_shared_pool package and its keep and unkeep procedures.

Pinning a package means that it will not be swapped out of memory until the database is shut down or explicitly unpinned. Is this what you were asking?

SQL> exec dbms_shared_pool.keep ('andy.my_package') and
SQL> exec dbms_shared_pool.unkeep ('andy.my_package')

Andy

-- 
Andy Hardy
Senior IT Systems Engineer
Cegelec AEG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions are mine and do not necessarily reflect those of Cegelec AEG