Data files getting full

[alpesh]

I am working on Oracle 7.3.4.4 on NT platform and I notice that without much utilization, I mean not much data put into the datafiles but its always going out of space and we have to do reorg. Can somebody help me what needs to be taken care or some tips to improve the space utilization
Thanks

[gandolf989]

I am working on Oracle 7.3.4.4 on NT platform and I notice that without much utilization, I mean not much data put into the datafiles but its always going out of space and we have to do reorg. Can somebody help me what needs to be taken care or some tips to improve the space utilization
Thanks

Add another disk drive! It depends on how tightly packed your data is within each tablespace. Also look at the pctincrease parameter on your tables and indexes. Without knowing your app I can't say beyond that.

[alpesh]

This is the default storage for tables
DEFAULT STORAGE (
INITIAL 256K
NEXT 256K
MINEXTENTS 2
MAXEXTENTS UNLIMITED
PCTINCREASE 1
)
ONLINE
PERMANENT;

This is the default storage for Indexes
DEFAULT STORAGE (
INITIAL 256K
NEXT 256K
MINEXTENTS 2
MAXEXTENTS 999
PCTINCREASE 1
)
ONLINE
PERMANENT

Can you put some light on this.

thanks

[davey23uk]

well someone is putting data in - you should check what objects are taking up all the space

[slimdave]

PCT INCREASE 1 iks a great way of fragmenting your space. PCTINCREASE 0 is what you want. Why MAXEXTENTS 999 on indexes?

[alpesh]

you mean to say that PCTINCREASE should be 0 and about the maxextends 999 ( it was former DBA who has design this stuff)

[slimdave]

you mean to say that PCTINCREASE should be 0 and about the maxextends 999 ( it was former DBA who has design this stuff)

yes -- make maxextents unlimited.

[gandolf989]

yes -- make maxextents unlimited.

As I recall the number of extents is directly controlled by the block size. i.e. 2k will give you 121 extents, 4k is 512 extents, and 8k is 1024 extents, or something like that. So unlimited extents might not be an option.

I agree with what you said about percent increase 0.

[slimdave]

So unlimited extents might not be an option.

It's specified as unlimited for the other TS though.