Re: Pinned procedures, how to identify them?

The KEPT column on v$db_object_cache is what you want. This is a great view; the SHARABLE_MEM column will tell you how much memory the object occupies, LOADS and EXECUTIONS will tell you how many times the object was loaded into memory and how many times it has been executed.

Wes Riding

James Dickson wrote:
>
> 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 Fri Feb 07 1997 - 00:00:00 CST