Path: news.easynews.com!easynews!out.nntp.be!propagator-SanJose!news-in!newshub2.rdc1.sfba.home.com!news.home.com!news1.rdc1.va.home.com.POSTED!not-for-mail From: "Sathish Balas" Newsgroups: comp.databases.oracle.server References: <2518ff19.0109062129.27d31a10@posting.google.com> Subject: Re: Diagnosing causes to ORA-4031 Lines: 27 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Message-ID: Date: Sun, 09 Sep 2001 14:53:38 GMT NNTP-Posting-Host: 24.7.176.188 X-Complaints-To: abuse@home.net X-Trace: news1.rdc1.va.home.com 1000047218 24.7.176.188 (Sun, 09 Sep 2001 07:53:38 PDT) NNTP-Posting-Date: Sun, 09 Sep 2001 07:53:38 PDT Organization: Excite@Home - The Leader in Broadband http://home.com/faster Xref: easynews comp.databases.oracle.server:117638 X-Received-Date: Sun, 09 Sep 2001 07:53:21 MST (news.easynews.com) I think you can either apply a patch or just add a undocumented parameter _db_handles_cached to non zero . You might be running into a known bug . - Sathish "Matthias Gresz" wrote in message news:mJZl7.7603$4z.32485@www.newsranger.com... > ORA-04031 unable to allocate string bytes of shared memory > ("string","string","string","string") > > Cause: More shared memory is needed than was allocated in the shared pool. > > Action: If the shared pool is out of memory, either use the DBMS_SHARED_POOL > package to pin large packages, reduce your use of shared memory, or increase the > amount > of available shared memory by increasing the value of the initialization > parameters SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE. If the large pool is > out of > memory, increase the initialization parameter LARGE_POOL_SIZE. > > >