Re: Recommended datafile sizes.

From: mlarson <mdlarson_at_brain.uccs.edu>
Date: 1997/04/02
Message-ID: <33430027.BD1@brain.uccs.edu>#1/1

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_at_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_at_health.wa.gov.au.
  DMR Consulting Group Australia
  +619 222 4116

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

Received on Wed Apr 02 1997 - 00:00:00 CST