Re: Datafile sizes

  • From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
  • To: daniel.hubler@xxxxxxxxxx
  • Date: Wed, 02 May 2007 10:18:47 -0700

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.


Greg Rahn

-------- 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.


Dan Hubler
Database Administrator
Aurora Healthcare

Other related posts: