Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: package size

Re: package size

From: Mark Bole <makbo_at_pacbell.net>
Date: Thu, 22 Sep 2005 18:30:42 GMT
Message-ID: <mLCYe.1378$xc4.1244@newssvr13.news.prodigy.com> 





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
Received on Thu Sep 22 2005 - 13:30:42 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US