Re: ORA-04030 Out of Process memory

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Sun, 10 Nov 2002 14:48:22 -0800
Message-ID: <F001.004FFC9E.20021110144822@fatcity.com>

How big was the OS process ?

Monitor what the process is doing, any memory allocation in a loop ?

I had this error once and it was an Oracle bug (804 on hpux 10.20), Oracle was having a problem releasing memory so after 100 000 calls of a function the process was crashing (ora-4030) because it was reaching the OS memory limit (700M) .

• Satyendra K Khare <satyendrak_at_delhi.tcs.co.in> a écrit : > Please give some suggestions how to avoid this
  > problem, it comes after 3
  > to 4 hours when i run a process through form, and it
  > terminates then i
  > have to down the database and up again to restart
  > that procedure..
  >
  > ORA-04030 Out of Process memory when trying to
  > allocate 528 Bytes (call
  > heap , user umc)
  > ORA-06512 at OBJ.PS_MATCH, Line 1298
  > ORA-06512 at line 1
  >
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Satyendra K Khare
  > INET: satyendrak_at_delhi.tcs.co.in
  >
  > Fat City Network Services -- 858-538-5051
  > http://www.fatcity.com
  > San Diego, California -- Mailing list and web
  > hosting services
  >
  

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---

Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant stephane_paquette_at_yahoo.com

---

Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: stephane_paquette_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Sun Nov 10 2002 - 16:48:22 CST