Re: Online creation/extension of Tablespaces possible??

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 12 Sep 2004 09:48:11 -0700
Message-ID: <1095007757.829309@yasure>

Howard J. Rogers wrote:

> Daniel Morgan wrote:
>
>

>>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?

>
>
> An "uncooked file system" is a contradiction in terms, surely? Either one
> has a file system, or one has raw ("uncooked") partitions. But not both.
>
> And yes, I may well break a large hard disk into many smaller partitions. If
> I was using raw, I would probably be talking SCSI rather than IDE, so my
> disk size is likely to be in the 36GB range rather than 70 or 80GB. So the
> problem is not quite so drastic as you make out.
>
> But yes, the concern about file size is one of backup and recovery (for me,
> anyway... can't speak for Sybrand). And that doesn't go away as an issue
> just because you're using raw.
>
> You are aware, too, I'm sure that Oracle's RAC courseware has a slide in it
> where it carefully instructs users of raw devices to create something like
> a *minimum* of 16 separate partitions to house the cluster database. So it
> happens.
>
> Regards
> HJR
I mean't raw ... sorry about any poor choice of verbiage.

And yes I've seen Oracle's slide show and it is not what I teach, it is not what Oracle system specialists on this continent advise, and is in my opinion preposterous.

That said ... I don't see anything anywhere in my shop that has a 2GB limit other than Windows. I agree with sizing for backup/restore purposes. But who has anything in their data center that considers 2GB a size limit?

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

Received on Sun Sep 12 2004 - 11:48:11 CDT