|
python@s1jibvorcl013 (TNS V1-V3)
运行的检测脚本视乎是你们自己写的检测脚本吗?
SELECT df.tablespace_name TABLESPACE, ROUND((df.bytes - SUM(fs.bytes)) * 100 / df.bytes, 2) USED
FROM (
SELECT TABLESPACE_NAME, BYTES
FROM sys.sm$ts_free fs
UNION ALL
SELECT TABLESPACE_NAME, FREE_SPACE
FROM DBA_TEMP_FREE_SPACE) FS, (
SELECT tablespace_name, SUM(bytes) bytes
FROM sys.sm$ts_avail
GROUP BY tablespace_name
UNION ALL
SELECT TABLESPACE_NAME, SUM(bytes)
FROM SYS.DBA_TEMP_FILES
GROUP BY tablespace_name) df
WHERE fs.tablespace_name(+) = df.tablespace_name
AND df.tablespace_name = 'UNDOTBS1'
GROUP BY df.tablespace_name, df.bytes
ORDER BY 1
--好像这个是某个厂家开发的监控数据库的脚本.. |
|