#!/bin/ksh
#Script. to auto genarate statspack report
# Coding by Serol Luo, rollingpig@163.com
username=perfstat
pass=perfstat
targetdb=testdb
function snap_id_list {
sqlplus -S $username/$pass@$targetdb <<EOF
set pages 0 termout off verify off feedback off
select snap_id from stats$snapshot
where snap_time > sysdate - 1
order by snap_id ;
exit
EOF
}
snap_id_list
for snap_id_line in `snap_id_list` ; do
bid="$eid"
eid="$snap_id_line"
if [ "$bid" != "" ] ; then
sqlplus -s $username/$pass@$targetdb <<EOF
set verify off termout off serverout off
define begin_snap=$bid;
define end_snap=$eid;
@?/rdbms/admin/spreport
exit
EOF
fi
done
#End Of Script
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10972173/viewspace-206165/ ，如需转载，请注明出处，否则将追究法律责任。
