Question

oracle怎么查询temp表空间

Answer 1

• Oracle查询temp表空间的名字和位置

  select tablespace_name,file_name from dba_temp_files;

• Oracle查询temp表空间的使用率

  select tablespace_name,round(free_space/1024/1024/1024,2) "free(GB)",round(tablespace_size/1024/1024/1024,2） "total(GB)",round(nvl(free_space,0)*100/tablespace_size,3) "Free percent"
  from dba_temp_free_space;
  

Answer 2

SELECT * From v$tempfile;