Assuming you are not using 10g bigfile tablespaces, the maximum size for a datafile is just over 4 million blocks. So for a tablespace with an 8k block the max datafile size is just over 32000MB.
I'm not a VMS expert, but with Unix, the more datafiles there are, the more file descriptors are required and there is some overhead with that. Thus sometimes bigger files is better than more, although this does impact recovery strategy.
Regards, Greg Rahn http://structureddata.org -------- Original Message -------- Subject: Datafile sizes From: daniel.hubler@xxxxxxxxxx To: oracle-l@xxxxxxxxxxxxx Date: 5/2/2007 8:50 AM
Looking for comments & experiences regarding sizes of datafiles. We have a large (6+ TB) OLTP database, which currently has 2300+ datafiles.A while ago, we stopped adding datafiles and were exclusively extending them. But we are wondering how far we can/should go, with the size of individual data files.Currently about 30% of the datafiles are at 8 gig. BTW - this particular application resides on VMS. Any ideas/thoughts/comments would be appreciated. Thanks. Dan Hubler Database Administrator Aurora Healthcare daniel.hubler@xxxxxxxxxx