(spinner1)oracle@spinner[~]$ cat -v test2.sh
#!/bin/bash
export IFS="^M"

ORACLE_SID=spinner1
#ORACLE_HOME etc etc

RESULT=`sqlplus -s "/ as sysdba" <<EOF
SET PAGESIZE 1000
SET LINESIZE 100
COLUMN machine FORMAT a35
COLUMN dummy NOPRINT
COMPUTE SUM OF KOUNT ON dummy
BREAK ON dummy SKIP 1

  SELECT username dummy
       , username
       , machine
       , count(1) KOUNT
    FROM v\\\$session
GROUP BY username
       , machine
ORDER BY username
       , machine
/

EOF
`


echo --
echo $RESULT
(spinner1)oracle@spinner[~]$ ./test2.sh
--

USERNAME                       MACHINE                                  KOUNT
------------------------------ ----------------------------------- ----------
SYS                            spinner.marketpipe.com                       1
                                                                   ----------
                                                                            1

WESTLB3_4_PROD                 dragon.marketpipe.com                        2
                                                                   ----------
                                                                            2

                               spinner.marketpipe.com                      18
                                                                   ----------
                                                                           18
(spinner1)oracle@spinner[~]$