1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
su - ora${user} -c "sqlplus -s system/manager <<!
set head off
set pages 100
set lines 200
set feedback off
SELECT rpad(Total.tablespace_name,15,' ') \"Tablespace Name\",
lpad((Free_space),15,' ') \"Espace Space\",
round(((Free_space/total_space)*100),0) \"Free Space Percentage\"
FROM
(select tablespace_name, sum(bytes) Free_Space
from sys.dba_free_space
group by tablespace_name
) Free,
(select tablespace_name, sum(bytes) TOTAL_SPACE
from sys.dba_data_files
group by tablespace_name
) Total
WHERE Free.tablespace_name = Total.tablespace_name;
!" | awk -f - -v <<-EOF
NR > 1 {
if ($3 >= 5)
print "ALERTE : Pour la base le tablespace ",$1,"ne lui reste plus que ",$3,"% de libre"
}
EOF |
Partager