temp tablespace 확인 (GB단위)

SELECT inst_id,

       tablespace_name,

       segment_file,

       Round(( total_blocks * 8 ) / 1024 / 1024, 2) TOTAL_GB,

       Round(( used_blocks * 8 ) / 1024 / 1024, 2)  USED_GB,

       Round(( free_blocks * 8 ) / 1024 / 1024, 2)  FREE_GB,

       Round(( max_blocks * 8 ) / 1024 / 1024, 2)   MAX_GB,

       free_requests,

       freed_extents

FROM   gv$sort_segment

ORDER  BY tablespace_name,

          inst_id;

------------------------------------------------------------------------------------------

SELECT inst_id,

       tablespace_name,

       segment_file,

       Round(( total_blocks * 8 ) / 1024 , 2) TOTAL_MB,

       Round(( used_blocks * 8 ) / 1024 , 2)  USED_MB,

       Round(( free_blocks * 8 ) / 1024 , 2)  FREE_MB,

       Round(( max_blocks * 8 ) / 1024 , 2)   MAX_MB,

       free_requests,

       freed_extents

FROM   gv$sort_segment

ORDER  BY tablespace_name,

          inst_id;