#!/bin/bash

. ~/.bash_profile

AWR_FORMAT=html

NUM_DAYS=1

reportname=shanxi

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`

MIN_SNAP_ID=`expr $MAX_SNAP_ID - 1`

AWR_LOG=/tmp/AWR_$reportname_`date '+%Y%m%d_%H%M'`.html

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

#生成最后2个快照的awr

ITPub博客

awr_report.sh生成awr报告