监控表空间脚本

今天下午想写一个表空间监控脚本，监控表空间使用超过90%的，如果超过则发一封邮件给管理员。可怎么也不成功，很是郁闷。这是前半部分内容

#!/bin/ksh
#2009-11-10
sqlplus "/as sysdba"
set feed off
set linesize 100
set pagesize 200
spool /bakdb/tablespace.alert
SELECT F.TABLESPACE_NAME,
(T.TOTAL_SPACE - F.FREE_SPACE) "USED (MB)",
F.FREE_SPACE "FREE (MB)",
T.TOTAL_SPACE "TOTAL (MB)",
TO_CHAR ((ROUND ((F.FREE_SPACE/T.TOTAL_SPACE)*100)),999) ||'% PER_FREE'
FROM (
SELECT TABLESPACE_NAME,
ROUND (SUM (BLOCKS*(SELECT VALUE/1024
FROM V$PARAMETER
WHERE NAME = 'db_block_size')/1024)
) FREE_SPACE
FROM DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME
) F,
(SELECT TABLESPACE_NAME,
ROUND (SUM (BYTES/1048576)) TOTAL_SPACE
FROM DBA_DATA_FILES
GROUP BY TABLESPACE_NAME
) T
WHERE F.TABLESPACE_NAME = T.TABLESPACE_NAME
AND (ROUND ((F.FREE_SPACE/T.TOTAL_SPACE)*100)) < 10;
spool off
exit

EOF

 

在执行脚本时总是报错说

ERROR at line 1:
ORA-00942: table or view does not exist

单独执行查询语句的时候没问题，：（郁闷。。。

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22779391/viewspace-619327/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22779391/viewspace-619327/