Mark Bole wrote:
> bigToe wrote:
> > We are investigating pinning packages in the shared pool. I don't
> > think I can use the DBMS_SHARED_POOL.SIZES procedure to give me sizes
> > of all our packages. Is there another way to do this?
>
> exec dbms_shared_pool.sizes(0);
>
>
> See also:
>
> Metalink note 1012047.6
> Subject: How To Pin Objects in Your Shared Pool
>
> Metalink note 61760.1
> Subject: Using the Oracle DBMS_SHARED_POOL Package
>
> Note:301171.1
> Subject: Toolkit for dynamic marking of Library Cache objects as Kept
> (PIND)
>
> Note:101627.1
> Subject: How to Automate Pinning Objects in Shared Pool at Database Startup
>
> -Mark Bole
Feel free to benchmark and prove that pinning is still useful this
century, but from what I've read (e.g. on AskTom) it seems that it is
not.
Received on Fri Sep 23 2005 - 18:49:07 CDT
