Re: Initials & Nexts for Tablespaces?

The most important thing to keep in mind is :

Define extent sizes at the object level rather that using tablespace defaults as this gives you more control. Any object that exceeds 20 odd extents will start to reduce in performance unless you are using partitions in Oracle8

Rgards
David Russell

Ralf Schneider wrote in message <6r78j2$skr$2_at_unlisys.unlisys.net>...
>Ja aber Hallo!
>
>Is it correct, that the value for the INITIAL and NEXT extent should be
>around about 1/100 of the total SIZE?
>Do I calculate correct?
>The sum of my 3 Datafiles divided by 100 are 3MB for the INITIAL and the
>NEXT
>extent. If I set MAXEXTENTS of 100 do I get the value of the sum of my 3
>Datafiles?
>______________________________________________________________
>___________>>EXAMPLE (Tablespace for Rollback Segmente)<<_________
>CREATE TABLESPACE rbs
>DATAFILE '/opt/c6_db/dbs/rollback_01.dbf' SIZE 100M REUSE,
> '/opt/c6_db/dbs/rollback_02.dbf' SIZE 100M REUSE,
> '/opt/c6_db/dbs/rollback_03.dbf' SIZE 100M REUSE
>DEFAULT STORAGE (
> INITIAL 3M
> NEXT 3M
> MINEXTENTS 20
> MAXEXTENTS 100
> PCTINCREASE 0
> )
>ONLINE
>PERMANENT;
>______________________________________________________________
>... or isn't it better if these values are smaller????
>
>Many Thanks
>Ralle
>
>
Received on Sun Aug 16 1998 - 15:35:29 CDT