Datafile sizes

Looking for comments & experiences regarding sizes of datafiles.

We have a large (6+ TB) OLTP database, which currently has 2300+ 
A while ago, we stopped adding datafiles and were exclusively extending 
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.


Dan Hubler
Database Administrator
Aurora Healthcare

Other related posts: