RE: Datafile size policy

From: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com>
Date: Fri, 24 Nov 2000 10:01:58 -0800
Message-Id: <10690.122861@fatcity.com>

I personally get really annoyed with the databases I have taken over that have a half a million datafiles for a single tablespace. The only time I can think that it would be a benefit (besides manual stripping) is if someone accidentally deletes one file and then you only have a 500M datafile to recover. However, I am thinking that usually a whole directory goes missing. Its especially annoying on TEMP or RBS.

-----Original Message-----
From: O'Neill, Sean [mailto:Sean.ONeill_at_organon.ie] Sent: Friday, November 24, 2000 12:46 AM To: Multiple recipients of list ORACLE-L Subject: Datafile size policy

Some folk, I believe, have a policy of keeping datafiles to a max size of 500MB to facilitate maintenance of systems, backups, recovery etc. Do you agree with this policy and if so why/why not?.

Sean :)

######   ######  ######  ###### 
#    #   #    #  #    #  #    #  Rookie
####     #    #  ######  ######  Data
#   #    #    #  #    #  #    #  Base 
#    #  #######  ######  #    #  Adminstrator
-------------------------------- ------------

Organon (Ireland) Ltd.
E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]

Visit: http://www.egroups.com/group/Oracle-OCP-DBA

The only man who never makes a mistake is the man who never does anything.

Theodore Roosevelt

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: O'Neill, Sean
  INET: Sean.ONeill_at_organon.ie

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Nov 24 2000 - 12:01:58 CST