statspack脚本问题

sturm

我做了个自动生成stats报表的脚本，但是用define begin_snap=$BEGIN_SNAP
define end_snap=$END_SNAP来赋值的话就会报

ERROR: Begin Snapshot Id specified does not exist for this database/instance

ERROR: End Snapshot Id specified does not exist for this database/instance

但是如果用define begin_snap=15，define end_snap=30来赋值就没有问题。各位老大帮我看看为什么呀

脚本如下

/home/oracle/.profile


$ORACLE_HOME/bin/sqlplus '/ as sysdba'<<!
set head off
set timing off
spool /home/oracle/statspack/snap_begin.lst
select min(snap_id) snap_id
from stats$snapshot
where snap_time between trunc(sysdate) and trunc(sysdate)+1;
spool off
spool /home/oracle/statspack/snap_end.lst
select max(snap_id) snap_id
from stats$snapshot
where snap_time between trunc(sysdate) and trunc(sysdate)+1;
spool off
exit
!


BEGIN_SNAP=`cat /home/oracle/statspack/snap_begin.lst | tail -n 4|head -2`
END_SNAP=`cat /home/oracle/statspack/snap_end.lst | tail -n 4|head -2`
#END_SNAP=`expr $BEGIN_SNAP + 13`
REPORT_NAME=/home/oracle/statspack/sp`date +%m%d`_ac


$ORACLE_HOME/bin/sqlplus '/ as sysdba'<<!
define begin_snap=$BEGIN_SNAP                           
define end_snap=$END_SNAP
define report_name=$REPORT_NAME
@$ORACLE_HOME/rdbms/admin/spreport
exit
!

将生成脚本改为

$ORACLE_HOME/bin/sqlplus '/ as sysdba'<<!
define begin_snap=15                           
define end_snap=30
define report_name=$REPORT_NAME
@$ORACLE_HOME/rdbms/admin/spreport
exit
!
就没有问题。



$ echo $BEGIN_SNAP
15
$ echo $END_SNAP
30
$