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: Sporadic ORA-04030

Re: Sporadic ORA-04030

From: Jining Han <jining.han_at_gmail.com>
Date: 22 Jan 2005 05:56:22 -0800
Message-ID: <1106402182.617926.195250@f14g2000cwb.googlegroups.com> 





    
  
  1.   You mentioned how much physical and virtual memory you have on the
box, but do you know how much your database server is using, including
SGA, shared_pool_size and, if you don't use MTS, the total number of
connections (each will use around 2M?)
  
  2.   Oracle bug: memory leak.  I'd search for it on Metalink
  
  3.   Parameters like db_file_multiblock_read_count set too high?  One
time I raised it from 16 to 64, and that led to a 7GB memory leak in a
matter of few hours, resulting in the problem you have run into.
Good luck
Jining Han



Received on Sat Jan 22 2005 - 07:56:22 CST












Original text of this message













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