temp_tbs
emcs
42次下载
511次浏览
2019-07-24
4.5

脚本内容

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;

评论

贡献排行榜