一个自动收集statspack snap的脚本
时间：2010-07-20 来源：oracle狂热分子
虽然,有spauto.sql可以用,但是我还是喜欢用这个脚本来收集信息,比较直观
#!/bin/bash
ORACLE_HOME=/u01/app/oracle/11.2
if [ $@ -gt 1 ] then echo "bad usage"
eliff [ $@ -eq 1 ] then
case "$0" in
-help|-h|--help|-h|?)
echo "execute scripts with no parameter"
;; --version|-version|--v|-v)
echo "program 1.0"
;;
esac else
echo "please enter total time:" read total echo "please enter interval time:" read interval echo "The log file is /tmp/snap.log" tmp=$interval while [ $interval -lt $total ]
do $ORACLE_HOME/bin/sqlplus > /tmp/snap.log /nolog <<EOF
conn perfstat/perfstat;
execute statspack.snap;
exit;
EOF ##这个EOF要在一行的顶端,前面不能有空格
interval=$interval+$tmp
sleep $tmp
done
if [ $@ -gt 1 ] then echo "bad usage"
eliff [ $@ -eq 1 ] then
case "$0" in
-help|-h|--help|-h|?)
echo "execute scripts with no parameter"
;; --version|-version|--v|-v)
echo "program 1.0"
;;
esac else
echo "please enter total time:" read total echo "please enter interval time:" read interval echo "The log file is /tmp/snap.log" tmp=$interval while [ $interval -lt $total ]
do $ORACLE_HOME/bin/sqlplus > /tmp/snap.log /nolog <<EOF
conn perfstat/perfstat;
execute statspack.snap;
exit;
EOF ##这个EOF要在一行的顶端,前面不能有空格
interval=$interval+$tmp
sleep $tmp
done
相关阅读 更多 +
