source /home/oracle/.bash_profile

AWR_FORMAT=html

NUM_DAYS=1

MAX_SNAP_ID=`sqlplus -S / as sysdba << EOF

set heading off trimspool on feedback off

SELECT trim(max(SNAP_ID)) FROM DBA_HIST_SNAPSHOT;

EOF`

MAX_SNAP_ID=`expr $MAX_SNAP_ID - 0`

MIN_SNAP_ID=`expr $MAX_SNAP_ID - 1`

AWR_LOG=/dbbak/awrrpt/AWRRPT_`date '+%Y%m%d_%H%M'`_$MIN_SNAP_ID"_"$MAX_SNAP_ID.html

echo $MIN_SNAP_ID

echo $MAX_SNAP_ID

echo $AWR_LOG

echo -e "$AWR_FORMAT\n$NUM_DAYS\n$MIN_SNAP_ID\n$MAX_SNAP_ID\n$AWR_LOG\n"|(sqlplus -S / as sysdba @?/rdbms/admin/awrrpt.sql) > /dev/null

在linux下配置crontab定时执行此脚本。

ITPub博客

配置linxu下使用脚本自动生成AWR报告