• shell oracle


    #!/bin/sh
    
    traffic=10
    
    rm -rf test.txt
    data=`sqlplus -S anoscfg/anoscfg  <<EOF
    spool test.txt
    set pages 0 
    set feed off
    set heading off;
    set feedback off;
    set verify off;
    set linesize 1000;
    select   TIME_START, SGSN,  round(UL_FLOW/(1024*1024),0), round(DL_FLOW/(1024*1024),0) from    (select * from RT_SGSN_FLOW_5   order  by  TIME_start desc )  where rownum <5;
    EOF`
    
    data_1_up=`echo $data |awk -F' ' '{print $3}'`
    data_2_up=`echo $data |awk -F' ' '{print $7}'`
    data_11_up=`echo $data |awk -F' ' '{print $11}'`
    data_22_up=`echo $data |awk -F' ' '{print $15}'`
    
    
    num_092_up=`expr ${data_11_up} / ${traffic}`
    num_221_up=`expr ${data_22_up} / ${traffic}`
    
    
    if [ ${data_1_up} -lt ${num_092_up} ];then
            echo 'alarm' 'warning' 'is' "SGSN 092 UL_flow   $data_1_up  -lt $data_11_up  `date '+%Y-%m-%d %T'`" "$HOSTNAME" 
    fi
    
    
    if [ $data_2_up -lt $num_221_up ];then
            echo 'alarm' 'warning' 'is' "SGSN 221 UL_flow  $data_2_up -lt $data_22_up  `date '+%Y-%m-%d %T'`" "$HOSTNAME" 
    fi
  • 相关阅读:
    动态内存Treap
    最大流Dinic
    图的遍历
    Aho_Corasick自动机(AC自动机)
    邻接表
    COJ 3007 Mr.Yang的小助手
    COJ 0601&0602 动态规划(二)及加强
    Codeforces 603A Alternative Thinking
    HDU 2222 Keywords Search
    codeforce--600D
  • 原文地址:https://www.cnblogs.com/bokun-wang/p/3880612.html
Copyright © 2020-2023  润新知