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 -> ulimit on AIX 4.3.3 for Oracle 8.1.7.0 32Bit

ulimit on AIX 4.3.3 for Oracle 8.1.7.0 32Bit

From: computer person <fake_address_at_nothing.com>
Date: Mon, 26 May 2003 21:34:57 GMT
Message-ID: <5MvAa.274537$w7k.243762@news04.bloor.is.net.cable.rogers.com>


We have users set up in AIX with the following ulimits

time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         131072
stack(kbytes)        32768
memory(kbytes)       32768
coredump(blocks)     2048

nofiles(descriptors) 2000

Has anyone ever ran into problems executing Oracle stored procedures (or SQL statements for that matter) which produce an ORA-03040 followed by ORA-00600? It seems to point to the users ulimit "memory(kbytes) 32768" being too small but I have never had to increase this value before? Anyone have experience with that?

Thanks Received on Mon May 26 2003 - 16:34:57 CDT

Original text of this message

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