Question on MAXDATAFILES and Control Files.

I have been doing some reading and research into the MAXDATAFILES and db_files parameters. The only reason that Oracle gives for not setting the MAXDATAFILES to the max allowed by Operating system and database version are that they increase the size of the control files.

First off lets say that the size of the control files really matters, on my 10 Gig database their size was insignificant. Has anyone done any experiments to see how much setting them to system max from a reasonable number does affect size? Beside control file size has anyone discovered any other reason?

Thanks Received on Sun Oct 29 2000 - 23:18:31 CST