RE: Datafile sizes

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of daniel.hubler_at_aurora.org   Sent: Wednesday, May 02, 2007 9: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