Re: Datafile sizes

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_at_aurora.org To: oracle-l_at_freelists.org 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_at_aurora.org

--
http://www.freelists.org/webpage/oracle-l