about segment setting
From: wqhdebian <wqhdebian_at_263.net>
Date: 8 Jul 2002 18:26:51 -0700
Message-ID: <db288b61.0207081726.587304e8_at_posting.google.com>
Date: 8 Jul 2002 18:26:51 -0700
Message-ID: <db288b61.0207081726.587304e8_at_posting.google.com>
I encounter a problem when read the content of segment setting:
CREATE PUBLIC ROLLBACK SEGMENT rbseg_11
TABLESPACE rbseg
STORAGE(
INITIAL 100K
NEXT 100K
MINEXTENTS 3
MAXEXTENTS 100
OPTIMAL 310K
)
Is that means When the segment if not sufficient to store the data
,then it will increase storage space about 300K(the MINEXTENTS =3,so
the first increasment is 3*100=300),but if it lack storage space
again,it just increase space about 100K,
thanks Received on Tue Jul 09 2002 - 03:26:51 CEST