Index size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Index size

  1. #1
    Join Date
    Nov 2001
    Posts
    10
    Is there a point in creating indexes with different INITIAL! =NEXT. Or the next_extent >initial_extent .I am new is this field and maybe I am missing something.
    I have an index with:
    initial_extent=104857600
    next_extent = 4096
    To me looks like this create performance problems. And better recreate it
    What you think?
    Thanks




  2. #2
    Join Date
    Jan 2002
    Posts
    59
    ThumRule for Local Extent Management - Ideal if extents are below two number count ie. below 10.
    To achieve this you would take advantage right starting from Initial extent specifications. and for further DiskManagement ur Next,Pctfree will specifications come into picture.
    Limitations as of the latest version 9i is u cant go beyond 2G of any each extent size ( precise 2147483646).
    To conclude u should consider next extent filling only after ur initial extent is full ** provided u have enough diskspace to accomodate such big extent.

    Thanx
    Sanjay

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You didn't specify if you are using LMT's or not, but I would guess not. The idea behind sizing your extents properly is to reduce fragmentation. Check out http://otn.oracle.com/deploy/performance/pdf/defrag.pdf for details.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Jan 2002
    Posts
    59
    sorry about that!!! i meant Dictionary Managed Extents...

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