rendered paste body(spinner1)oracle@spinner[~]$ cat -v test2.sh#!/bin/bashexport IFS="^M"ORACLE_SID=spinner1#ORACLE_HOME etc etcRESULT=`sqlplus -s "/ as sysdba" <<EOFSET PAGESIZE 1000SET LINESIZE 100COLUMN machine FORMAT a35COLUMN dummy NOPRINTCOMPUTE SUM OF KOUNT ON dummyBREAK ON dummy SKIP 1 SELECT username dummy , username , machine , count(1) KOUNT FROM v\\\$sessionGROUP BY username , machineORDER BY username , machine/EOF`echo --echo $RESULT(spinner1)oracle@spinner[~]$ ./test2.sh--USERNAME MACHINE KOUNT------------------------------ ----------------------------------- ----------SYS spinner.marketpipe.com 1 ---------- 1WESTLB3_4_PROD dragon.marketpipe.com 2 ---------- 2 spinner.marketpipe.com 18 ---------- 18(spinner1)oracle@spinner[~]$