Re: TableSpace Storage Parameters?

Jeannine

The approach I always like (appeals to the bastard in me no doubt!) is to set initial and next greater than the tablespace size. That forces developers to think of what the sizing really should be, because if they don't put a size on the objects, the creation will fail.

Of course, there are many arguments supporting a less draconian approach, like let's create small, medium and large tablespaces with small, medium, and large initial extent sizes. One thing to keep in mind is to try to make the extents a multiple of the block size, and to ensure initial and next are either the same or multiples of each other.

HTH. Pete

"Gin, Jeannine (EXCHANGE:QUAL:7S02)" wrote:

> How does one choose an appropriate initial and next extent sizes of a
> tablespace?
>
> For example:
>
> create tablespace mytablespace
> datafile '/disk9/isd/data/mytablespace.dbf' size 100M
> default storage (initial ??M next ??M pctincrease 0);
>
> Thanks in advance,
>
> Jeannine

--

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)

Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA