RE: Datafile sizes

From: Richard J. Goulet <rgoulet_at_kanbay.com>
Date: Wed, 2 May 2007 20:26:15 -0400
Message-ID: <C3EE2ADD31ACF64DAB1B236044A1968D73078F@miaexc01.kanbay.com>

Assuming Oracle 9.2 or better and an 8kb block size. Max file size is 32GB. I believe.  

........................................................................


............................................................. 

Kanbay <http://www.kanbay.com/>
Dick Goulet, Senior Oracle DBA
45 Bartlett ST | Marlborough, MA 01752 USA Tel: 508.573.1978 | Fax: 508.229.2019 | Cell: 508.742.5795

rgoulet_at_kanbay.com <mailto:rgoulet_at_kanbay.com> 
........................................................................


............................................................. 



 

________________________________

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of daniel.hubler_at_aurora.org
Sent: Wednesday, May 02, 2007 11:50 AM
To: oracle-l_at_freelists.org
Subject: Datafile sizes

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

Received on Wed May 02 2007 - 19:26:15 CDT