ORA-27102: out of memory in Tru64

Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SVRMGR connect internal Connected. SVRMGR startup pfile ='/app/oracle/admin/devbcm/pfile/initdevbcm.ora' nomount ORA-27102: out of memory Compaq Tru64 UNIX Error: 12: Not enough space Additional

RE: ORA-27102: out of memory in Tru64

SVRMGR connect internal Connected. SVRMGR startup pfile ='/app/oracle/admin/devbcm/pfile/initdevbcm.ora' nomount ORA-27102: out of memory Compaq Tru64 UNIX Error: 12: Not enough space Additional information: 1 Additional information: 98307 My Shm parameters are as given below . $ /sbin

ora-4030 out of memory error

All - I have a user receiving this error on several different Unix boxes with the same query. Oracle says to increase the size limit which was done in 2000. The sort are size parm is set to 10485760. Any suggestions?? LeRoy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

RE: ora-4030 out of memory error

LeRoy Check out Metalink Note 199746.1 Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 23, 2003 3:00 PM To: Multiple recipients of list ORACLE-L All - I have a user receiving this error on several different Unix boxes

Re: ora-4030 out of memory error

] Sent by: cc: [EMAIL PROTECTED] Subject: ora-4030 out of memory error

Re: ora-4030 out of memory error

Kemnitz [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ora-4030 out of memory error Date: Mon, 23 Jun 2003 11:59:53 -0800 All - I have a user receiving this error on several different Unix boxes with the same query. Oracle says

RE: ora-4030 out of memory error

Title: RE: ora-4030 out of memory error LeRoy, Post the query to the list. Just maybe it could tuned or give us an idea of what's going on. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: LeRoy Kemnitz [SMTP

Re: ora-4030 out of memory error

) [EMAIL PROTECTED] edu To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: ora-4030 out of memory error

Re: ora-4030 out of memory error

Services Oracle Engineering [EMAIL PROTECTED] Work Phone :(224) 405 1140 Cell Phone:(513) 850 3721 From: LeRoy Kemnitz [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ora-4030 out of memory error Date: Mon, 23 Jun 2003 11:59:53

Re: ora-4030 out of memory error

Title: RE: ora-4030 out of memory error PGA grows by using the malloc() or sbrk() system calls to extend the heap data segment for process. The new operating system vertual memory is then added to the PGA heap as a new extent. These extents are only a few kilobytes in size , and Oracle may

Out of Memory

I am getting: SQL startup nomount ORA-27102: out of memory Machine Specs: 0) Oracle 8i 8.1.7 1) Sun Solaris 8 fully patched 2) SparcStation5 70Mhz 3) 128MB Ram 4) 256B Swap 5) /etc/system set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set

RE: Out of Memory

startup nomount ORA-27102: out of memory Machine Specs: 0) Oracle 8i 8.1.7 1) Sun Solaris 8 fully patched 2) SparcStation5 70Mhz 3) 128MB Ram 4) 256B Swap 5) /etc/system set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_shmseg=10 set

Re: Out of Memory

:13 PM To: Multiple recipients of list ORACLE-L I am getting: SQL startup nomount ORA-27102: out of memory Machine Specs: 0) Oracle 8i 8.1.7 1) Sun Solaris 8 fully patched 2) SparcStation5 70Mhz 3) 128MB Ram 4) 256B Swap 5) /etc/system set shmsys:shminfo_shmmax=4294967295 set