Script para execuções em background(Hp-Ux-Linux)

Script para execuções em background que são longas. Salve com a extensão .sh e execute com o nohup

#!/bin/sh
# Comments:
# Data: 26-03-2012
# Executor: Fabio Alves

export ORACLE_SID=man01
export ORACLE_HOME=/u01/app/oracle/product/10.2/db_1

$ORACLE_HOME/bin/sqlplus /nolog << EOF
connect / as sysdba
set timing on
set echo on
set serveroutput on
spool /home/oracle/execution_log.log
alter session disable parallel query;
prompt Apagando registros

DELETE FROM
MANOLO_PRD.MAN_EXPRESS ATEN
WHERE FG_CURRENT is null
and ATEN.TB_OPT_PRIME
IN ( SELECT TB_OPT_PRIME
FROM ( select COUNT(1) ,TB_OPT_PRIME, BD_TRP, NUM_SEQ
from MANOLO_PRD.MAN_EXPRESS AA
group by TB_OPT_PRIME, BD_TRP, NUM_SEQ HAVING COUNT(1) > 1 ) aa ); commit;

spool off

exit;
EOF
exit 0