I was not asking about how to set up a temporary tablespace or LMT or the advantages of LMT, I am already aware of that!

I was asking about Dictionary tablespaces and the discussion I had with an Oracle consultant. I was asking whether or not he was correct in his statement, to establish whether or not my company should hire him as a consultant for advice when I am not available.

I'll repeat what he said, all I want is for someone to agree or disagree with this statement.
He said :
Every session that adds extents to the temporary sort segment always adds the value of initial_extent to the chain of current extents and all subsequent extents will be sized at the value of next_extent FOR THAT SESSION. If this is so you would have a sort segment with different extent lengths all the way through it.

I was saying that initial extent is at the segment level and not the session level, regardless of whether it is a temp tablespace or not! There is only one extent at the value of initial_extent and that is the first one. All subsequent extent sizes are set at the value of next_extent no matter which session causes its creation in temp tablespace.

If you read Oracle documentation regarding DMT TEMP tablespaces, it states that the extent size of the sort segment should be a multiple of sort_area_size + 1 block. Hence, my initial_extent is a multiple of sort_area_size + 1 block and next_extent is a mulitple of sort_area_size alone.

P.S. The consultant charges £1200 a day. I want to make sure he knows his stuff.






[Edited by Sureshy on 06-26-2002 at 10:33 AM]