|
SQL> select tablespace_name,extent_size,total_extents,max_sort_blocks
2 from v$sort_segment;
TABLESPACE_NAME EXTENT_SIZE TOTAL_EXTENTS MAX_SORT_BLOCKS
------------------------------- ----------- ------------- ---------------
TEMP 128 0 0
NANUTEMP 128 147 384
NESTTEMP 128 5 384
|