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

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-04031: unable to allocate 8192 bytes of shared memory

Re: ORA-04031: unable to allocate 8192 bytes of shared memory

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Thu, 01 Jul 2004 22:59:48 GMT
Message-ID: <pan.2004.07.01.22.59.39.434649@sbcglobal.net> 





On Thu, 01 Jul 2004 10:51:28 +0200, cat54me wrote:



> "ORA-04031: unable to allocate 8192 bytes of shared memory"

> 

> What is the cause? How do I fix it?

> 

> Thanks in advance!




It is likely you are encountering feature 1397603 which 
effects 8.1.7. The workaround is to set the following 
init.ora parameter to zero:



_db_handles_cached = 0


-- 
Well-behaved women seldom make history


Received on Thu Jul 01 2004 - 17:59:48 CDT












Original text of this message













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