#!/bin/bash
set -x
ORACLE_BASE=/opt/app/oracle
ORACLE_SID=OSTESTA
ORACLE_HOME=/opt/app/oracle/product/10.2/db_1
CRS_HOME=/opt/app/oracle/product/10.2/crs_1

RESULTS=`sqlplus -s "/ as sysdba" <<EOF
SELECT machine , count(1) KOUNT
FROM v$session
WHERE username = "TESTER"
GROUP BY machine
ORDER BY machine ;

EOF
`

echo SQLPLUS said: $RESULTS