Re: Online creation/extension of Tablespaces possible??

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 11 Sep 2004 18:12:58 -0700
Message-ID: <1094951643.293181@yasure>

Sybrand Bakker wrote:

> On Sun, 12 Sep 2004 06:44:47 +1000, "Howard J. Rogers"
> <hjr_at_dizwell.com> wrote:
>
>

>>Too many data files in a database are themselves not a terribly good idea
>>for efficient checkpoints etc, so I wouldn't want to see 2000 files of 10MB
>>each to make a 20GB database, either. 

>
>
> Which was exactly the context I was implicitly referring to.
> I don't think there is much disagreement between us, if I can, I would
> limit my datafiles to 2G
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

How does this correspond with using an uncooked file system? Surely you wouldn't break up a 70GB drive into 35 separate partitions? So why the concern about file size?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Sat Sep 11 2004 - 20:12:58 CDT