ideal Indexed Tablespace size for 150 to 200 Columns

[dbarookie]

I have a separate indexed tablespace for all indexed columns averaging about 150 – 200 primary keys columns. I keep getting the ORA-01658: unable to create INITIAL extent for segment in tablespace.

1. Is there any suggestion on ideal sizes for such a large groups of indexes? Please advice on ideal values for the Initial size, Next size, Min size, Increment size by, Minimum number, and Max number?

2. Here is the storage parameters for when creating the Primary key column tablespace LOS_INDEX PCTFREE 10 STORAGE (INITIAL 2864K NEXT 1424K PCTINCREASE 50) - Is the storage parameter for each index too high or what?

Please advice….

[marist89]

Depends, how many rows? What are your table sizes?

[dbarookie]

The rows are approx 1 million and All my tables size are default as follows

)
TABLESPACE LOS_DATA NOLOGGING
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 6569984
NEXT 3276800
PCTINCREASE 50
MINEXTENTS 1
MAXEXTENTS 121
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE;

Any advise

[grjohnson]

PCTINCREASE = 50.... yeach!.... fragmentation coming up. Set this to 0, and consider making INITIAL and NEXT the same size.