Running select from V$ views from remote server

#/bin/ksh -x

NOTIFY_LIST=”pmehta@1800flowers.com”

CONNECT_USER=”/ as sysdba”

TARGET_ORACLE_HOME=/oracle/app/oracle/product/10.1

MY_SQL=”select max(SEQUENCE#) from v$log_history;”

RUNNING=`/usr/local/bin/ssh uocdbprod21 “. /oracle/app/oracle/oraprocs/oracle_env_UOC; $TARGET_ORACLE_HOME/bin/sqlplus -S / a

s sysdba <set pagesize 0 feedback off verify off heading off echo off

$MY_SQL

END”`

echo “RUNNING = $RUNNING”