RE: ORA-4030 Out of Process Memory

Samir,

Does ulimit -a indicate anything? From my Solaris 8 system:

$ ulimit -a

time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        8192
coredump(blocks)     unlimited
nofiles(descriptors) 256
vmemory(kbytes)      unlimited

Also look at '/etc/sysdef':

*
* Process Resource Limit Tunables (Current:Maximum)
*
          Infinity:Infinity             cpu time
          Infinity:Infinity             file size
          Infinity:Infinity             heap size
0x0000000000800000:Infinity             stack size
          Infinity:Infinity             core file size
0x0000000000000100:0x0000000000000400   file descriptors
          Infinity:Infinity             mapped memory

Hth,
John Kanagaraj
Oracle Applications DBA
DB Soft Inc
Work : (408) 970 7002

Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

>-----Original Message-----
>From: SARKAR, Samir [mailto:Samir.SARKAR_at_nottingham.sema.slb.com]
>Sent: Wednesday, August 14, 2002 3:59 AM
>To: Multiple recipients of list ORACLE-L
>Subject: ORA-4030 Out of Process Memory
>
>
>Hi All,
>
>This is 8.1.6.3 (32-bit) on Solaris 8. We have been trying to run a
>transaction on the database
>and it is throwing up ORA-4030. The process is indeed a big
>process and we r
>getting this
>error only while running a particular transaction. On running
>'maxmem', we
>get the following :
>
> Memory starts at: 137992 ( 21b08)
> Memory ends at: 2147483647 (7fffffff)
> Memory available: 2147345655 (7ffde4f7)
>
>Can anybody help me finding out how to increase the Memory
>available to more
>than 2 Gig ?? I think
>that this memory limitation is why my process is dying when
>its grown to
>circa 2 Gig. Also, do I need to
>increase the swap space and bounce the server ?? My swap info
>is as under :
>
> swapfile dev swaplo blocks free
>/dev/vx/dsk/swapvol 239,8 16 16774704 16774704
>/dev/vx/dsk/rootdg/v_swap 239,6 16 34815984 34815984
>
>Any other checks/inputs on this will be highly appreciated as this is a
>production database and I have
>an impatient client.
>
>Thanks,
>Samir
>
>Samir Sarkar
>Oracle DBA
>SchlumbergerSema
>Email : ssarkar2_at_slb.com
>Phone : +44 (0) 115 - 957 6028
>EPABX : +44 (0) 115 - 957 6418 Ext. 76028
>Fax : +44 (0) 115 - 957 6018
>
>
>
>_________________________________________________________
>This email is confidential and intended solely for the use of the
>individual to whom it is addressed. Any views or opinions
>presented are
>solely those of the author and do not necessarily represent those of
>SchlumbergerSema.
>If you are not the intended recipient, be advised that you
>have received
>this email in error and that any use, dissemination,
>forwarding, printing,
>or copying of this email is strictly prohibited.
>
>If you have received this email in error please notify the
>SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
>_________________________________________________________
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: SARKAR, Samir
> INET: Samir.SARKAR_at_nottingham.sema.slb.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).