1、设置环境变量:
2、脚本
bat文件:
E:
sqlplus system/**** @db @temp.sql >> space%date:~0,10%.txt
sql文件:
SELECT TABLESPACE_NAME,
TABLESPACE_SIZE / 1024 / 1024 / 1024 as "TABLESPACE_SIZE(G)",
(TABLESPACE_SIZE-FREE_SPACE) / 1024 / 1024 / 1024 as "USED_SPACE(G)",
FREE_SPACE / 1024 / 1024 / 1024 as "FREE_SPACE(G)"
from DBA_TEMP_FREE_SPACE;
exit;
3、设置计划任务
2、脚本
bat文件:
E:
sqlplus system/**** @db @temp.sql >> space%date:~0,10%.txt
sql文件:
SELECT TABLESPACE_NAME,
TABLESPACE_SIZE / 1024 / 1024 / 1024 as "TABLESPACE_SIZE(G)",
(TABLESPACE_SIZE-FREE_SPACE) / 1024 / 1024 / 1024 as "USED_SPACE(G)",
FREE_SPACE / 1024 / 1024 / 1024 as "FREE_SPACE(G)"
from DBA_TEMP_FREE_SPACE;
exit;
3、设置计划任务
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28371090/viewspace-1780761/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28371090/viewspace-1780761/