sqlplus ryan/ryan098<< EOF
set feed off
set linesize 500;
set pagesize 50
spool ${filedir}
select a.tablespace_name 表空间名称,total_space/(1024*1024) 总量,free_space/(1024*1024) 剩余量,trunc((free_space/total_space)*100)||'%' 剩余比例 from (select tablespace_name,sum(bytes) free_space from dba_free_space group by tablespace_name) a,(select tablespace_name,sum(bytes) total_space from dba_data_files group by tablespace_name) b where a.tablespace_name = b.tablespace_nameorder by (free_space/total_space );
spool off
exit
EOF
使用这个脚本监控 表空间。执行时发现,屏幕输出很规范,但是 spool ${filedir}的日志里 还是以前的很乱的格式。
设置了col 表空间名称 for a40...等等也不行,好奇怪
------------------------------------------
屏幕输出结果:
表空间名称
总量 剩余量 剩余比例
------------------------------ ---------- ---------- -----------------------------------------
EXAMPLE
138.125.4375 0%
XDB
45
.25 0%
CWMLITE
20
5 25%
SYSTEM
3864
1052.1875 27%
DRSYS
20
10.3125 51%
ODM
20
10.4375 52%
SPOOL里日志结果:
表空间名称
总量 剩余量 剩余比例
------------------------------ ---------- ---------- -----------------------------------------
EXAMPLE
138.125.4375 %
XDB
45.25 0%
CWMLITE
20
5 25%
|