#!/bin/bash
source ~/.bash_profile
. /home/ora10/system_tablespace
sqlplus -S oracle/hao12345@hxy < col BYTES_USED for 9999999999999
set feed off
set linesize 100
set pagesize 200
spool /home/ora10/tablespace.alert
select a.tablespace_name,a.bytes bytes_used,b.largest,round(((a.bytes-b.bytes)/a.bytes)*100,2) percent_used from (select tablespace_name,sum(bytes) bytes from dba_data_files group by tablespace_name) a, (select tablespace_name,sum(bytes) bytes ,max(bytes) largest from dba_free_space group by tablespace_name) b where a.tablespace_name=b.tablespace_name order by ((a.bytes-b.bytes) / a.bytes) DESC;
spool off
exit;
EOF
source ~/.bash_profile
. /home/ora10/system_tablespace
sqlplus -S oracle/hao12345@hxy < col BYTES_USED for 9999999999999
set feed off
set linesize 100
set pagesize 200
spool /home/ora10/tablespace.alert
select a.tablespace_name,a.bytes bytes_used,b.largest,round(((a.bytes-b.bytes)/a.bytes)*100,2) percent_used from (select tablespace_name,sum(bytes) bytes from dba_data_files group by tablespace_name) a, (select tablespace_name,sum(bytes) bytes ,max(bytes) largest from dba_free_space group by tablespace_name) b where a.tablespace_name=b.tablespace_name order by ((a.bytes-b.bytes) / a.bytes) DESC;
spool off
exit;
EOF
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24492954/viewspace-1129893/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24492954/viewspace-1129893/