SHELL中执行Oracle SQL语句查询性能视图

时间:2019-10-09 18:38:13   收藏:0   阅读:151

 

查询alert日志出现错误

#!/bin/bash

loadsql="SELECT count(1)
FROM  v\$diag_alert_ext 
WHERE
  originating_timestamp > ( sysdate - interval ‘1‘ HOUR )
 and
  ( message_text LIKE ‘%error%‘
OR message_text LIKE ‘%ORA-%‘
OR message_text LIKE ‘%terminating the instance%‘
OR message_text LIKE ‘%CRS-%‘);"

loadsql="$loadsql"
result=`sqlplus -s /nolog  <<EOF
        set echo off feedback off heading off underline off;
		conn / as sysdba;
        $loadsql
        exit;
EOF`

echo $result

 查询session

 

原文:https://www.cnblogs.com/elontian/p/11643403.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!