CREATE TABLE DEPOSIT (
DEPOSITINTTRANID NUMBER (20) NOT NULL,
INTAMNT NUMBER (10,4) NOT NULL,
INTCALCDATE DATE NOT NULL,
DEPOSITTRANID NUMBER (20) NOT NULL,
PRIMARY KEY ( DEPOSITINTTRANID )
USING INDEX
TABLESPACE USR PCTFREE 10
STORAGE ( INITIAL 50K NEXT 50K PCTINCREASE 0 ))
TABLESPACE USR
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 51200
NEXT 51200
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 2147483645
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE;
I have a script as this . I know what each parameter such as
<<
TABLESPACE USR PCTFREE 10
STORAGE ( INITIAL 50K NEXT 50K PCTINCREASE 0 ))
TABLESPACE USR
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 51200
NEXT 51200
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 2147483645
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE;
>>
means.
Somebody elaborating them in a lay man's language would be great anyway.
But how does one calculate the values for these parameters so that it really makes some difference in the performance of the database. I think one should know these deciding factors so that she/he can appreciate the use of it.
.....Thanks In Advance.....
DEPOSITINTTRANID NUMBER (20) NOT NULL,
INTAMNT NUMBER (10,4) NOT NULL,
INTCALCDATE DATE NOT NULL,
DEPOSITTRANID NUMBER (20) NOT NULL,
PRIMARY KEY ( DEPOSITINTTRANID )
USING INDEX
TABLESPACE USR PCTFREE 10
STORAGE ( INITIAL 50K NEXT 50K PCTINCREASE 0 ))
TABLESPACE USR
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 51200
NEXT 51200
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 2147483645
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE;
I have a script as this . I know what each parameter such as
<<
TABLESPACE USR PCTFREE 10
STORAGE ( INITIAL 50K NEXT 50K PCTINCREASE 0 ))
TABLESPACE USR
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 51200
NEXT 51200
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 2147483645
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE;
>>
means.
Somebody elaborating them in a lay man's language would be great anyway.
But how does one calculate the values for these parameters so that it really makes some difference in the performance of the database. I think one should know these deciding factors so that she/he can appreciate the use of it.
.....Thanks In Advance.....