Re: Ulimit

Thanks .

Suppose a user A with ulimit for filesize set to about 1G does a direct path SQL LOADER , Should it fail ?
It works on our System on IBM AIX 4.3 and Oracle 8.1.6 .

But the Create Index Statement following the load fails . The Index Tablespace is made up of 2 datafiles
each of 1G and 2G . It does not fail always . It fails sometimes and it works sometimes .
What do i have to check in this case ? Anybody know about any known problems , issues ..........

TIA
Sathish

"santysharma" <santysharma_at_hotmail.com> wrote in message news:9lbn7g$8bd26$1_at_ID-84096.news.dfncis.de...
> ulimit sets the limitation on system resources on unix by user processes
> like file size, core dump size etc. Generally most of values will be
> unlimited unless otherwise specified by system admin. This parameter in
> Oracle got most of the attention because of datafile size limit of 2GB. u
> can get the values of these values by running command in shell
>
> ulimit -a
>
> HTH
> santysharma
> Oracle Certified DBA
> Sun Certified System Admin
>
>
> "Sathish Balas" <sathishudercor_at_home.com> wrote in message
> news:WUce7.278313$qc.33455268_at_news1.rdc1.va.home.com...
> > Could anyone point to information regarding ulimit and how it affects
> local
> > connections by different unix users connecting to the Oracle DB locally
?
> >
> > Thanks
> > Sathish
> >
> >
>
>
Received on Tue Aug 14 2001 - 12:42:27 CDT