RE: Datafile sizes
- From: "Richard J. Goulet" <rgoulet@xxxxxxxxxx>
- To: <daniel.hubler@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 2 May 2007 20:26:15 -0400
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@xxxxxxxxxx <mailto:rgoulet@xxxxxxxxxx>
........................................................................
.............................................................
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
daniel.hubler@xxxxxxxxxx
Sent: Wednesday, May 02, 2007 11:50 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxx
Other related posts:
