今天用到视图V$TEMPSEG_USAGE，看到有好多对象类型，发现有如下几种临时sort segment type: SEGTYPEVARCHAR2(9)Type of sort segment: SORT  排序HASH  hash join（unindexed joins）DATA  temporary tablesINDEX  temporary indexsLOB_DATA