10.2.0.5 on windows 2008 64bit
在10g里面temporary tablespace 的extent management为local uniform size,默认为1m。
我的疑问是如何调优 temporary tablespace的extent size呢。今天阅读了一篇关于buffer busy wait的文章,说到如果buffer busy wait on temporary segment header 时,
增大' nest extent'的大小。这里可以理解为,
A large uniform extent size will tend to mean fewer allocations take place. Usually disk acreage for temp is not that much of a concern, since disk SPACE is cheap and you don't have to back up temp space."
这算是 extent size的一个考虑点,那还有其他的考虑点么