-
Data files getting full
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
-
Originally Posted by 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
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.
-
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
-
well someone is putting data in - you should check what objects are taking up all the space
-
PCT INCREASE 1 iks a great way of fragmenting your space. PCTINCREASE 0 is what you want. Why MAXEXTENTS 999 on indexes?
-
data files getting full
you mean to say that PCTINCREASE should be 0 and about the maxextends 999 ( it was former DBA who has design this stuff)
-
Originally Posted by alpesh
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.
-
Originally Posted by slimdave
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.
-
Originally Posted by gandolf989
So unlimited extents might not be an option.
It's specified as unlimited for the other TS though.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|