From: mlarson <mdlarson@brain.uccs.edu>
Subject: Re: Recommended datafile sizes.
Date: 1997/04/02
Message-ID: <33430027.BD1@brain.uccs.edu>#1/1
References: <858760892.13615@dejanews.com>
X-Priority: 3 (Normal)
Organization: Oracle Corporation. Redwood Shores, CA
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server



My vote is for the smaller files.  The large files must be placed on
larger disks, which means one drive head is responsible for more data
retrieval.  A 500Meg file spec is a good one.

Matt

Tim.Middleton@health.wa.gov.au wrote:

  Hi guys & gals,

  I am looking for some comments on the following scenario.

  I have a tablespace which is large (about 8Gb).  When creating the
  datafiles for this tablespace, Is is better to have, say. 2 x 4Gb
  datafiles or should i have 16x500Mb datafiles.

  What are the advantages/disadvantages of each approach.

  Thanks very much.

  Tim Middleton

  PS. Please email me.
  PPS. Also where can i find the FAQ's for this newsgroup. Tar.

  Tim.Middleton@health.wa.gov.au.
  DMR Consulting Group Australia
  +619 222 4116

  -------------------==== Posted via Deja News
  ====-----------------------
        http://www.dejanews.com/     Search, Read, Post to Usenet