increasing next extent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: increasing next extent

  1. #1
    Join Date
    Oct 2000
    Posts
    56
    can anyone tell me what a good measurement is for increasing next extent??

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095

    It really depends on how fast your table is growing.

    If your table is growing really fast, it wouldn't be unreasonable to make the next extent double the size of the last extent. After a couple of days, see how many times you have extended and re-evaluate.

  3. #3
    Join Date
    Nov 2000
    Posts
    71
    To avoid fragmentation nex extent should be equal to initial extent.
    For data tablespace in a DB with not very big table an atent of 128 k is what Oracle raccomanded.
    However you should analyze with particular attention your DB structure and size

  4. #4
    Join Date
    Nov 2000
    Posts
    62
    This month's Oracle Magazine has a very interesting article regarding tablespace management -Locally managed tablespace ~.
    you can also see this issue online [url]http://www.oracle.com/oramag/oracle/00-nov/o60o8i.html[/url]

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