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

#!/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