Initials & Nexts for Tablespaces?

From: Ralf Schneider <soraya_at_berlin.snafu.de>
Date: Sun, 16 Aug 1998 20:26:43 +0200
Message-ID: <6r78j2$skr$2@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 - 13:26:43 CDT