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)