Data files getting full
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Data files getting full

  1. #1
    Join Date
    Nov 2006
    Posts
    23

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,027
    Quote 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 space intentionally left blank

  3. #3
    Join Date
    Nov 2006
    Posts
    23
    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

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    well someone is putting data in - you should check what objects are taking up all the space

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    PCT INCREASE 1 iks a great way of fragmenting your space. PCTINCREASE 0 is what you want. Why MAXEXTENTS 999 on indexes?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  6. #6
    Join Date
    Nov 2006
    Posts
    23

    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)

  7. #7
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Quote 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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  8. #8
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,027
    Quote 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.
    this space intentionally left blank

  9. #9
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Quote Originally Posted by gandolf989
    So unlimited extents might not be an option.
    It's specified as unlimited for the other TS though.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width