Re: Creating datafiles for 500GB database

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Tue, 13 Apr 2004 19:58:23 +1000
Message-ID: <407bbb5b$1$12740$afc38c87@news.optusnet.com.au>

"Joel Garry" <joel-garry_at_home.com> wrote in message news:91884734.0404121512.7ff69c4a_at_posting.google.com...

> Are you sure this is all it does? I would think there is some impact
> on kernel requirements, for unix systems, at least (maxfiles, ninode,
> nfiles).

Yes, but that impact is with the OS and nothing to do with the control file iself.

> Don't know much about windows, but there must be some impact
> on the OS of opening all those files at the same time (
> http://support.microsoft.com/default.aspx?scid=kb;en-us;163202 maybe
> proves it irrelevant?).

Cripes! That could be a problem. 2Mb per root file? Thank God for very large file handling then...

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

Received on Tue Apr 13 2004 - 04:58:23 CDT