RE: Datafile sizes
- From: "Robert Freeman" <robertgfreeman@xxxxxxxxx>
- To: <daniel.hubler@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 2 May 2007 11:20:33 -0600
Wow... that makes for a long dba_data_files query!! My personal thought on
this is for BIG databases, I like to time how long it takes to restore a
given datafile size. If I need to recover a given datafile, how long do I
want that to take? My general rule is no more than 10-15 minutes (depending
on any SLA's of course!). So if it takes 15 minutes to restore 20GB, that
would be my datafile size (assuming the OS can handle a datafile of that
size and so on).
I much prefer fewer, larger datafiles to more, smaller ones. Much easier to
manage among other things.
RF
Robert G. Freeman
Oracle Consultant/DBA/Author
Principle Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints
Father of Five, Husband of One,
Author of various geeky computer titles
from Osborne/McGraw Hill (Oracle Press)
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of daniel.hubler@xxxxxxxxxx
Sent: Wednesday, May 02, 2007 9: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:
