oracle linux使用情况,查看各linux服务器的空间使用情况并将其插入到oracle数据库中...

#!/bin/sh

rsh vpbDb df -g|awk  '/\// {print "insert into host_space values(\047vpbDb\047,\047"$1"\047,"$2,","$3",\047"$4"\047,"$5",\047

"$6"\047,\047"$7"\047,sysdate);"}'>/orahome/space.sql

rsh docContent df -g|awk  '/\// {print "insert into host_space values(\047docContent\047,\047"$1"\047,"$2,","$3",\047"$4"\047

,"$5",\047"$6"\047,\047"$7"\047,sysdate);"}'>>/orahome/space.sql

rsh docDb df -g|awk  '/\// {print "insert into host_space values(\047docDb\047,\047"$1"\047,"$2,","$3",\047"$4"\047,"$5",\047

"$6"\047,\047"$7"\047,sysdate);"}'>>/orahome/space.sql

rsh docIndex df -g|awk  '/\// {print "insert into host_space values(\047docIndex\047,\047"$1"\047,"$2,","$3",\047"$4"\047,"$5

",\047"$6"\047,\047"$7"\047,sysdate);"}'>>/orahome/space.sql

rsh portalDb df -g|awk  '/\// {print "insert into host_space values(\047portalDb\047,\047"$1"\047,"$2,","$3",\047"$4"\047,"$5

",\047"$6"\047,\047"$7"\047,sysdate);"}'>>/orahome/space.sql

rsh docWebtop df -g|awk  '/\// {print "insert into host_space values(\047docWebtop\047,\047"$1"\047,"$2,","$3",\047"$4"\047,"

$5",\047"$6"\047,\047"$7"\047,sysdate);"}'>>/orahome/space.sql

rsh nimServer df -g|awk  '/\// {print "insert into host_space values(\047nimServer\047,\047"$1"\047,"$2,","$3",\047"$4"\047,"

$5",\047"$6"\047,\047"$7"\047,sysdate);"}'>>/orahome/space.sql

rsh tscba1 df -g|awk  '/\// {print "insert into host_space values(\047tscba1\047,\047"$1"\047,"$2,","$3",\047"$4"\047,"$5",\0

47"$6"\047,\047"$7"\047,sysdate);"}'>>/orahome/space.sql

rsh TS-Dev1 df -g|awk  '/\// {print "insert into host_space values(\047TS-Dev1\047,\047"$1"\047,"$2,","$3",\047"$4"\047,"$5",

\047"$6"\047,\047"$7"\047,sysdate);"}'>>/orahome/space.sql

rsh TS-Dev2 df -g|awk  '/\// {print "insert into host_space values(\047TS-Dev2\047,\047"$1"\047,"$2,","$3",\047"$4"\047,"$5",

\047"$6"\047,\047"$7"\047,sysdate);"}'>>/orahome/space.sql

rsh TS-Dev3 df -g|awk  '/\// {print "insert into host_space values(\047TS-Dev3\047,\047"$1"\047,"$2,","$3",\047"$4"\047,"$5",

\047"$6"\047,\047"$7"\047,sysdate);"}'>>/orahome/space.sql

rsh TS-Dev4 df -g|awk  '/\// {print "insert into host_space values(\047TS-Dev4\047,\047"$1"\047,"$2,","$3",\047"$4"\047,"$5",

\047"$6"\047,\047"$7"\047,sysdate);"}'>>/orahome/space.sql

rsh TS-Test1 df -g|awk  '/\// {print "insert into host_space values(\047TS-Test1\047,\047"$1"\047,"$2,","$3",\047"$4"\047,"$5

",\047"$6"\047,\047"$7"\047,sysdate);"}'>>/orahome/space.sql

rsh TS-Test2 df -g|awk  '/\// {print "insert into host_space values(\047TS-Test2\047,\047"$1"\047,"$2,","$3",\047"$4"\047,"$5

",\047"$6"\047,\047"$7"\047,sysdate);"}'>>/orahome/space.sql

rsh TS-Test3 df -g|awk  '/\// {print "insert into host_space values(\047TS-Test3\047,\047"$1"\047,"$2,","$3",\047"$4"\047,"$5

",\047"$6"\047,\047"$7"\047,sysdate);"}'>>/orahome/space.sql

rsh TS-Test4 df -g|awk  '/\// {print "insert into host_space values(\047TS-Test4\047,\047"$1"\047,"$2,","$3",\047"$4"\047,"$5

",\047"$6"\047,\047"$7"\047,sysdate);"}'>>/orahome/space.sql

rsh TS-TestNIM df -g|awk  '/\// {print "insert into host_space values(\047TS-TestNIM\047,\047"$1"\047,"$2,","$3",\047"$4"\047

,"$5",\047"$6"\047,\047"$7"\047,sysdate);"}'>>/orahome/space.sql

rsh ts-db01 df -g|awk  '/\// {print "insert into host_space values(\047ts-db01\047,\047"$1"\047,"$2,","$3",\047"$4"\047,"$5",

\047"$6"\047,\047"$7"\047,sysdate);"}'>>/orahome/space.sql

su - oracle -c "sqlplus userid/passwd@db"<

@/orahome/space.sql;

delete from host_space where to_char(insert_date,'yyyy-mm-dd')

commit;

EOF