使用SHELL自动化生成AWR报告

                                          使用SHELL自动化生成AWR报告

功能:每天定时跑shell 脚本，生成一个固定时间段的awr报告

#!/bin/bash
# writen by xiangdongzou 2013/12/17

export ORACLE_SID=test
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/10.2/db_1

m=`$ORACLE_HOME/bin/sqlplus -S < conn / as sysdba;
set heading off;
select max(snap_id) from dba_hist_snapshot;
EOF`
j=$((m-8))
k=$((m-10))

 

$ORACLE_HOME/bin/sqlplus -S < conn / as sysdba
@/u01/app/oracle/product/11.1.7/db_1/rdbms/admin/awrrpt.sql;
html
1
${k}
${j}
/home/oracle/temp/awrrpt_1_${k}_${j}.html
EOF