THIS SCRIPT CHECKS, IF A PARAMETER IN THE DATABASE IS SET OR NOT
================================================================

#!/bin/ksh

export s_val=$1
export s_file=myx.out

sqlplus -s "app_sysdba/g#0ra34v as sysdba" <<-EOSQL 2>&1 1>/dev/null
        set pages 0
        set lines 200
        set heading  off
        set feedback off

        spool ${s_file}
        select value from v\$parameter where name = '${s_val}';
        spool off

EOSQL

if [[ -s $s_file ]]
then
   if [ $(cat $s_file | sed -e's/ //g' | wc -c) -gt 1 ]
   then
      cat $s_file
   else
      echo "$s_file has just blanks."
   fi
else
   echo "$s_file has no data."
fi

#rm ${s_file}

exit
____________________________________________________________________________________________________________________________

SAMPLE
======

myhost:orcl:/export/home/oracle/dev$ ./myx
myx.out has no data.

myhost:orcl:/export/home/oracle/dev$ ./myx rollback_segments
myx.out has just blanks.

myhost:orcl:/export/home/oracle/dev$ ./myx spfile
/app/istp/oracle/1120/db/product/11.2.0.4/dbs/spfileISTPDB.ora