Pinned procedures, how to identify them?

From: James Dickson <James.Dickson_at_mail.esrin.esa.it>
Date: 1997/02/06
Message-ID: <32FA1AC3.14B4@mail.esrin.esa.it>#1/1

Greg Burris wrote:

> There is a way to ensure that a table stays in memory, with Oracle7
>
> ALTER TABLE tablename CACHE;

Thanks for that tip Greg.

I have a similar problem; I can pin procedures in memory with dbms_shared_pool.keep
e.g.
> SVRMGR> execute sys.dbms_shared_pool.keep('OWA2DEMO.HELLOWORLD');
> Statement processed.

but what SQL can I run that will tell me what is currently pinned and what is not? None of the fields in v$sqlarea seem to have this field.

Any ideas?

Please CC your news posting to james_at_valhall.esrin.esa.it

Thanks,
James Received on Thu Feb 06 1997 - 00:00:00 CST