Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Questions on extents, etc.

Questions on extents, etc.

From: <argosy22_at_my-deja.com>
Date: 2000/04/20
Message-ID: <8dliqa$rqh$1@nnrp1.deja.com>#1/1

HI all,

I've been reading about tablespaces, rollback segments, extents, and I have some questions about them.

If I use this statement to create a tablespace:

Create tablespace	ROLLBACK_TBS
DATAFILE	'/rollback/somefile.dbf'
SIZE 			25M

DEFAULT STORAGE
(
INITIAL			160K
NEXT			160K
PCTINCREASE		0
MINEXTENTS		2
MAXEXTENTS		100

)

and then 3 rollback segments with this statement:

Create ROLLBACK SEGMENT roll1_rbs
(roll2_rbs, roll3_rbs)
TABLESPACE ROLLBACK_TBS
STORAGE
(

INITIAL		160K
NEXT			160K
MINEXTENTS		2
MAXEXTENTS		30

)

I'm wondering:
- is the whole tablespace being used, or, am I limiting
its use to 16 megs (160k * 100 = 16000K = 16M) ? If so, can we ensure all the 25M is used by just leaving out the MAXEXTENTS clause?

I've read what I could on these subjects, but it's not quite clear yet (as you can tell).

Thanks,

Argosy

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Apr 20 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US