脚本内容
set lines 1000 pages 1000 SELECT TABLESPACE_NAME,ROUND(SUM(BYTES_USED)/(1024*1024*1024),2) USED_SPACE,ROUND(SUM(BYTES_FREE)/(1024*1024*1024),2) FREE_SPACE FROM V$TEMP_SPACE_HEADER GROUP BY TABLESPACE_NAME; set lines 160 col file_name for a100 select TABLESPACE_NAME,file_name from dba_temp_files;
评论
贡献排行榜