Re: Sizing Tablespaces

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 28 Aug 2001 22:30:47 +0100
Message-ID: <3B8C0D87.7549@yahoo.com>

Christian Lang wrote:
>
> Hi all,
> we think to reorganize our Production Database and use the Oracle SAFE to stop
> Fragmentation.
> Did someone already use this Algorithm ?
> What should be the maximim size of a Tablespace ?
>
> any help will be appreciatet
> Thanks

I generally don't go above 2G per file. Often for most systems, one file per tablespace suffices which gives a 2G max on tablespaces as well. There are of course exceptions to every rule.

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

Received on Tue Aug 28 2001 - 16:30:47 CDT