linux脚本查询oracle数据库

#!/bin/sh
case $1 in

#查看ASM磁盘组剩余空间
dgs)
sqlplus -s " / as sysdba"<<EOF
select name "磁盘组名称",total_mb/1024 "总大小(GB)",(total_mb-free_mb)/1024 "用户使用(GB)",free_mb/1024 "剩余磁盘组(GB)",(total_mb-free_mb)/total_mb*100 "磁盘组使用率%" from v$asm_diskgroup;
exit
EOF
;;

esac;

 

 

 

jobs