extents tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: extents tablespace

  1. #1
    Join Date
    Mar 2004
    Posts
    53

    extents tablespace

    we have a table with 3.4 million records.

    segment_type = table
    header_file=9
    header_block = 677217
    bytes= 347422720
    blocks = 42410
    extents = 327
    initial_extent = 221184
    next_extent = 1048576
    min_extents = 1
    max_extents = 420
    pct_increase = 0

    Recently, max_extents was increased to 420 using the following,

    alter table tablename storage (maxextents 420) i.e maxextents was increased when extents > 0.9 * maxextents.

    Could somebody please explain how many times this could be done on this table? Is there a limit? And how does this influence tablespace? Is there anything that needs to be taken care of? Is this correct approach? Any suggestions/explanations will be very useful.

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Put maxextents to unlimited ... the only advantage of limiting the number of extents is to cause your database to suddenly stop working if 501 extents are required and you've only allowed 500.
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

  3. #3
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    There is no limit to the number of times you can change the maxexnte storage parameter.

    My suggestion is to increase your next extent size.. mebbe 32m will do.
    -nagarjuna

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