-
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.
-
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.
-
You can lock this thread, if you do not want it to be continued.
Sam
-
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]
