How to set initial and next extent in TEMP

[cfidba]

I have a 1.5 GB temporary tablespace and allocated 5 mb sort_area_size. How should I set my initial and next extent of the temporary tablespace?

[beppo]

When a sort in memory is exeeding sort_area_size it will start using the temp table space and the extent size it choose is the same as sort_area_size, so you don't need to bother about extents!

/Beppo

[jmodic]

Originally posted by beppo
... it will start using the temp table space and the extent size it choose is the same as sort_area_size...

It can't simply "choose" the size of extent! The extent size in temporary tablespace is fixed when the tablespace is created, and Oracle must use that size, it has no other option!

As for the sizing of temporary extents: set them to the same size as your sort_area_size and you'll be fine. Or at least size them so that sort_area_size will be a multiple of extent size. And it goes without saying that INITIAL and NEXT should be the same....

[beppo]

Of course you'r right jmodic, I was just thinking of the allocation of temp segments. Sorry, cfidba if I confused you!

/Beppo