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

Thread: more into needed

  1. #1
    Join Date
    Aug 2000
    Posts
    163
    Thank you Shreddy. It was exactly information I was looking for. I quote the autor of one of the posts.
    'It's best if INITIAL=NEXT and PCT_INCREASE=0 for the tablespace. Drop and recreate if necessary. This relates to the limited duration of temporary objects. Once their usefulness is ended, temporary objects are dropped and the extents allocated to them are returned to the tablespace for later use by other sorts or temporary operations. They are not deallocated. The next time any operation goes looking for space it will find an extent ready and waiting.'
    Please someone explain this sentence to me:'They are not deallocated.'
    Thank you.

  2. #2
    Join Date
    Aug 2000
    Posts
    163

    Cool previous post

    I am sorry. I meant to post a reply to already existing discussion and accidently created a new one.
    Anyway, all of the above applies to the temporary tablespaces.

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    You can lock this thread, if you do not want it to be continued.
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    They are not deallocated means:

    As soon as the sort operation is done (for which it aquired the extent) the extent is not going to be released or deallocated but, will be released only when other sort operation needs extent for sorting and there is no extent to allocate. That moment the extent will be released which was used for prior SORT operation.

    Thats what I See from the explaination you mentioned above.

    [Edited by sreddy on 03-08-2001 at 05:23 PM]
    Reddy,Sam

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