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 -> ORA-04031: unable to allocate 2097152 bytes of shared memory ("shared pool","unknown object","hash-join subh","QERHJ Hash Table Entries")

ORA-04031: unable to allocate 2097152 bytes of shared memory ("shared pool","unknown object","hash-join subh","QERHJ Hash Table Entries")

From: <purohitatul_at_gmail.com>
Date: Thu, 30 Aug 2007 05:55:19 -0000
Message-ID: <1188453319.294269.181580@m37g2000prh.googlegroups.com> 





We getting the following error in our database:
ORA-04031: unable to allocate 2097152 bytes of shared memory ("shared
pool","unknown object","hash-join subh","QERHJ Hash Table Entries")"



We have already tried the following:


1. Flushing shared pool


2. Bouncing db



Bouncing does resolve the problem temporarily but then it comes back
again?


Size of the shared pool has been same throughtout but problem has
started to appear recently.


Any clues anyone?
Received on Thu Aug 30 2007 - 00:55:19 CDT












Original text of this message













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