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:[EMAIL PROTECTED]]
>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 : [EMAIL PROTECTED]
>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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
