开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 数据库系统 > Oracle数据库 > 查看源码
oramon
资源名称：oramon.zip　[点击查看]
上传用户：rjj0351
上传日期：2007-01-07
资源大小：9k
文件大小：3k
源码类别：

Oracle数据库

开发平台：

SQL

oramon：源码内容
  1. Syntax()
  2. {
  3. echo 'oramon 2.1 beta by Raymond Vermeern'
  4. echo 'Usage: oramon [ses cpu|disk      [interval count records]]'
  5. echo '       oramon [usr sid statistic [interval count records]]'
  6. echo '       oramon [sql sid           [interval count records]]'
  7. echo '       oramon [tbs               [interval count records]]'
  8. echo '       oramon [dbf               [interval count records]]'
  9. echo '       oramon [fio nodelta|delta [interval count records]]'
  10. echo '       oramon [rbs               [interval count records]]'
  11. echo 'n'
  12. echo '       ses = session information'
  13. echo '       usr = user information'
  14. echo '       sql = user sql information'
  15. echo '       tbs = tablespace information'
  16. echo '       dbf = datafile information'
  17. echo '       fio = datafile io information'
  18. echo '       rbs = rollback information'
  19. echo 'n'
  20. echo '       default => oramon 5 99999999999999 20 ses disk'
  21. exit 0
  22. }
  24. DISPLAY=$1
  25. case $DISPLAY in
  26. '-h'|'-H'|'-?') Syntax
  27.                 ;;
  28.          'ses') INTERVAL=$3
  29.                 COUNT=$4
  30.                 NUMBER=$5
  31.                 case "${2}" in 
  32.                 'CPU'|'cpu')   PAR1=6
  33.                                ;;
  34.                 'DISK'|'disk') PAR1=5
  35.                                ;;
  36.                 *)             PAR1=5
  37.                                ;;
  38.                 esac
  39.                 ;;
  40.          'usr') INTERVAL=$4
  41.                 COUNT=$5
  42.                 NUMBER=$6
  43.                 PAR1=$2
  44.                 PAR2=$3
  45.                 if [ "${PAR1}" = "" -o "${PAR2}" = "" ]
  46.                  then
  47.                    Syntax
  48.                 fi
  49.                 ;;
  50.          'sql') INTERVAL=$3
  51.                 COUNT=$4
  52.                 NUMBER=$5
  53.                 PAR1=$2
  54.                 if [ "${PAR1}" = "" ]
  55.                  then
  56.                    Syntax
  57.                 fi
  58.                 ;;
  59.          'fio') PAR1=$3
  60.                 PAR2=$4
  61.                 PAR3=$2
  62.                 if [ "${PAR3}" = "" ]
  63.                  then
  64.                    Syntax
  65.                 fi
  66.                 if [ "${PAR1}" = "" ]
  67.                  then
  68.                    PAR1=4
  69.                 fi
  70.                 if [ "${PAR2}" = "" ]
  71.                  then
  72.                    PAR2=99999999999999
  73.                 fi
  74.                 ;;
  75.          *)     INTERVAL=5
  76.                 COUNT=99999999999999
  77.                 NUMBER=20
  78.                 if [ "${1}" = "" ]
  79.                  then
  80.                    DISPLAY=ses
  81.                    PAR1=5
  82.                 fi
  83.                 ;;
  84. esac
  86. [ "${INTERVAL}" = "" ] && INTERVAL=5
  87. [ "${COUNT}" = "" ] && COUNT=99999999999999
  88. [ "${NUMBER}" = "" ] && NUMBER=20
  90. ##echo "@${DISPLAY}mon ${NUMBER} ${PAR1} ${PAR2} ${PAR3}"
  91. ##exit
  92. typeset -Z12 TELLER=0
  93. while [ "$TELLER" -lt ${COUNT} ]
  94. do
  95.    (( TELLER = TELLER + 1 ))
  96.    clear
  97.    sqlplus -s / << EOF
  98.     @hdrmon
  99.     @${DISPLAY}mon ${NUMBER} ${PAR1} ${PAR2} ${PAR3}
  100. EOF
  101.    if [ ${COUNT} -gt 1 ]
  102.     then
  103.       sleep ${INTERVAL}
  104.    fi
  105. done