Autoextend - performance?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Autoextend - performance?

  1. #1
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142

    Autoextend - performance?

    In a previous thread I was convinced I should use AUTOEXTEND with MAXSIZE: http://www.dbasupport.com/forums/sho...threadid=34935 and I'm now planning to rebuild my tablespaces bearing this in mind (LMT uniform etc etc as well).

    Extending a file takes some time - does anyone see a performance hit when files are extended?

    I would expect that nothing would "hang", provided that the buffers were big enough to hold all the dirty blocks that are waiting to be written to that file. Have I missed anything?

    TIA - DaPi

  2. #2
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    Maybe if you have lots of datafiles on many harddisks that extend with too small steps, you might encounter waits. Or if you extend with large steps (let's say 128MB).

    If you know the specs of your disk-array (cache, I/O speeds, etc), you can determine the right extend-size, right?

    HTH,
    Erik
    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Also, depends on the value you have specifed for NEXT's of the datafile & the segment in Q which needs to extend.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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