PATH=$PATH:/usr/local/bin
export PATH
ORACLE_SID=CNWP01
export ORACLE_SID
ORAENV_ASK=NO
export ORAENV_ASK
. /usr/local/bin/oraenv
sqlplus -s "/ as sysdba" <<EOF | sqlplus "/ as sysdba"
set pages 0
set feedback off
select 'analyze table '||owner||'.'||table_name||' compute statistics;' 
from dba_tables where owner in ('COREOS','COREUNISON');
EOF