Re: 2 GB myth

wizofoz2k_at_yahoo.com.au (Noons) wrote in message news:<73e20c6c.0411270357.33c6873e_at_posting.google.com>...

>
> Until recently, the default maximum file units per process
> in *nix was 100. It was raised to 1000 somewhere in the
> late 90s/early 00's (noughties?). But even these may still
> cause problems in some odd versions of *nix. So, if you plan
> to use lots and lots of files (above 100) in a database server
> process, make sure you check the internals doco or the system
> doco to find out if you need to reconfigure the kernel.
> Nothing to do with the database limit.
>
> The penalty is that *nix will behind the scenes start to
> dynamically close and re-open file units as accesses are made.
> Not a major problem if your I/O access follows a pre-determined
> pattern, but definitely a huge problem if it is random in nature.

This is good to know, I always thought (based on older experience) Oracle would barf with an OS error when it tried to open one too many files. Would you know which platform(s) the penalty applies to?

jg

--
@home.com is bogus.
That darn Akamai:  http://news.bbc.co.uk/1/hi/technology/3958665.stm