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

Re: ulimit on AIX 4.3.3 for Oracle 8.1.7.0 32Bit

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Tue, 27 May 2003 10:18:18 +0100
Message-ID: <u3GAa.15287$pK2.21313@news.indigo.ie>


Yes... it's possible ... open the data,stack,memory to unlimited and watch the problem go away.
"computer person" <fake_address_at_nothing.com> wrote in message news:5MvAa.274537$w7k.243762_at_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 Tue May 27 2003 - 04:18:18 CDT

Original text of this message

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