Re: One datafile vs Several

From: Umar FArooq <umar.farooq_at_cressoft.com.pk>
Date: 1998/05/14
Message-ID: <355A9EF5.C6695DB5@cressoft.com.pk>#1/1

Brian Schanblatt wrote:

> hello!
> we:
> ORACLE 7.3.3.4
> AIX 4.1.2
>
> We have a 1GB tablespace spread out over 5 datafiles.
> I would like to export everything,
> drop the tablespace, recreate it with 1 large datafile
> and re-import.
>
> Is this worthwhile? Are there advantages to having one datafile
> for a tablespace instead of several?
> All suggestions welcome!
> brigo_at_idt.net
> bshan_at_ymail.yu.edu

using a single datafile would ease the maintenance ie backups etc but would reduce the concurrency of data access and hence will adversely affect performance.

Umar Farooq Ch.
umar.farooq_at_cressoft.com.pk Received on Thu May 14 1998 - 00:00:00 CDT