When processing queries, Oracle often requires temporary workspace for intermediate
stages of SQL statement parsing and execution. Oracle automatically allocates this disk
space called a temporary segment. Typically, Oracle requires a temporary segment as a
database area for sorting. Oracle does not create a segment if the sorting operation can
be done in memory or if Oracle finds some other way to perform the operation using
indexes.
1. 临时段经常用做SQL解析和执行
2. 典型的情况是临时段用做排序
3. 如果Oracle排序能在内存中完成或者找到利用索引来优化操作的方法 , Oracle不创建临时段