#!/bin/bash

export DATABASE=BCMSPQA
export ORACLE_SID=BCMSPQA1
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.3.7
export PATH=$PATH:$PATH:$ORACLE_HOME/bin

echo "*** Dumping awr report"
sqlplus "/ as sysdba" @report_tm1_awr