Re: Help with tablespace sizing.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/17
Message-ID: <958579964.563.0.pluto.d4ee154e@news.demon.nl>#1/1

The general consensus nowadays is all extents should be of uniform size. If you don't do so will end up with a fragmented tablespace where many extents will not be used at all.

Hth,

Sybrand Bakker, Oracle DBA

Greg Akins <gakinsNOgaSPAM_at_gatewayhealthplan.com.invalid> schreef in berichtnieuws 0835fbcf.a913cc37_at_usw-ex0103-023.remarq.com...
> I'm trying to determine my maximum table size given certian
> create tablespace parameters.
>
> create tablespace myData datafile
> 'd:\orant\database\myData.ora' size 150M
> default storage (
> initial 512K
> extent 1024K
> pctincrease 20
> minextents 2
> maxextents 121
> ) ;
>
> It appears that my last extent will be 1024(1.2)^119.
>
> Is this a correct interpretation?
>
> Thanks
>
> -greg
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Wed May 17 2000 - 00:00:00 CDT