Re: ORA-04031 - Which packages should be kept in memory?

Alexander Skwar wrote:
> Hello!
>
> All of a sudden, I'm getting ORA-04031 error messages on of my Ora9i
> databases. On various sites on the internet, like http://www.techonthenet.com/oracle/errors/ora04031.php,
> I find the following:
>
> Use the DBMS_SHARED_POOL package to pin large packages.
>
> How do I know or decide, which packages I should KEEP in memory
> with DBMS_SHARED_POOL.KEEP()? I know that it says to keep "large
> packages" - but I suppose I should only keep those "packages"
> which are needed. How do I know, which packages are needed? What
> is "large"?
>
> Thanks,
>
> Alexander Skwar

Look at the demos at in Morgan's Library at www.psoug.org under DBMS_SHARED_POOL. Also look at DBMS_SESSION.FREE_UNUSED_USER_MEMORY.

But I would suggest symptom fighting is not a long term solution. What version of Oracle (to 3 decimals) and what is causing the problem. That is what needs to be determined.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org