Re: ulimit on AIX 4.3.3 for Oracle 8.1.7.0 32Bit

computer person wrote:

> 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

ORA-00600 is an unhandled error internal to Oracle that has nothing to do with your SQL statement.

Open an iTAR.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)