Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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