shell指令碼實現自動生成awr報告
主要實現自動生成awr報告,程式碼思想非本人,但是有進行部分改造,之前網上的不能執行,經過部分改造可以正常執行的
生成語法
[oracle@hxy ~]$ bash ./dba_oracle_awr.sh -s HXY -f 20131125140000 -t 20131125150000 -p text -h /u01/app/oracle/product/10.2.1/db_1
指令碼如下
[oracle@hxy ~]$ cat dba_oracle_awr.sh
#!/usr/bin/bash
# ********************************
# * dba_oracle_awr.sh
# ********************************
# Usage: dba_oracle_awr.sh -s [instance_name]
# -f [from time]
# -t [to time]
# -p [report type, html or text]
# -h [oracle home]
# -n [tns admin]
#
# time format: 'yyyymmddhh24miss'.
# E.g 201311251300 means 05:00:00pm, oct 04, 2013
#
#
# **********************
# get parameters
# **********************
while getopts ":s:f:t:p:h:n" opt
do
case $opt in
s) instance=$OPTARG
;;
f) from=$OPTARG
;;
t) to=$OPTARG
;;
p) type=$OPTARG
type=$(echo $type|tr "[:upper:]" "[:lower:]")
;;
h) oracle_home=$OPTARG
;;
n) tns_admin=$OPTARG
;;
'?') echo "$0: invalid option -$OPTARG">&2
exit 1
;;
esac
done
if [ "$instance" = "" ]
then
echo "instance name(-s) needed"
echo "program exiting..."
exit 1
fi
if [ "$from" = "" ]
then
echo "from time (-f} needed"
echo "program exiting..."
exit 1
fi
if [ "$to" = "" ]
then
echo "to time (-t) needed"
echo "program exiting..."
exit 1
fi
if [ "${oracle_home}" = "" ]
then
echo "oracle home (-h) needed"
echo "program exiting..."
exit 1
fi
sqlplus="${oracle_home}/bin/sqlplus"
echo $sqlplus
if [ "$type" = "" ]
then
type="html"
fi
# ********************
# trim function
# ********************
function trim()
{
local result
result=`echo $1|sed 's/^ *//g' | sed 's/ *$//g'`
echo $result
}
# *******************************
# get begin and end snapshot ID
# *******************************
define_dur()
{
begin_id=`$sqlplus -s /nolog<
set pages 0
set head off
set feed off
select max(SNAP_ID) from DBA_HIST_SNAPSHOT where
BEGIN_INTERVAL_TIME<=to_date($from,'yyyymmddhh24miss');
EOF`
ret_code=$?
if [ "$ret_code" != "0" ]
then
echo "sqlplus failed with code $ret_code"
echo "program exiting..."
exit 10
fi
end_id=`$sqlplus -s /nolog<
set pages 0
set head off
set feed off
select min(SNAP_ID) from DBA_HIST_SNAPSHOT where
END_INTERVAL_TIME>=to_date($to,'yyyymmddhh24miss');
spool off
EOF`
ret_code=$?
if [ "$ret_code" != "0" ]
then
echo "sqlplus failed with code $ret_code"
echo "program exiting..."
exit 10
fi
begin_id=$(trim ${begin_id})
end_id=$(trim ${end_id})
# echo "begin_id: $begin_id end_id: $end_id"
}
# *******************************
# generate AWR report
# *******************************
generate_awr()
{
awrsql="${oracle_home}/rdbms/admin/awrrpt.sql"
if [ ! -e $awrsql ]
then
echo "awrrpt.sql does not exist, exiting..."
exit 20
fi
tmp1_id=${begin_id}
#echo "begin_id is: $begin_id"
#echo "tmp1_id is: $tmp1_id"
while [[ ${tmp1_id} -lt ${end_id} ]]
do
let tmp2_id=${tmp1_id}+1
if [ $type == "text" ]
then
report_name="awrrpt_${instance}_${tmp1_id}_${tmp2_id}.txt"
else
report_name="awrrpt_${instance}_${tmp1_id}_${tmp2_id}.html"
fi
#echo $report_name
$sqlplus -s "/ as sysdba">/dev/null<
define report_type=$type
define num_days=1
define begin_snap=${tmp1_id}
define end_snap=${tmp2_id}
define report_name=${report_name}
@${oracle_home}/rdbms/admin/awrrpt.sql
exit;
EOF
tmp1_id=${tmp2_id}
done
}
# *******************************
# main routing
# *******************************
#read_act
define_dur
generate_awr
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17172228/viewspace-1062096/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 一個自動生成awr報告的shell指令碼指令碼
- AWR報告自動生成指令碼指令碼
- 自動生成awr報告指令碼指令碼
- 【AWR】自動生成AWR報告指令碼以及用法指令碼
- awr報告每天自動生成指令碼指令碼
- Oracle10g 自動生成AWR報告的指令碼Oracle指令碼
- 【AWR】Oracle批量生成awr報告指令碼Oracle指令碼
- 生成awr報告的指令碼指令碼
- Oracle10g自動生成AWR分析報告的指令碼Oracle指令碼
- 自動生成AWR HTML報告HTML
- 指令碼:定時生成awr報告指令碼
- 自動生成ASH報告指令碼指令碼
- 定時自動生成awr報告
- 轉貼:批量生成awr報告指令碼指令碼
- 使用shell自動傳送Oracle AWR報告Oracle
- AWR Report 自動生成指令碼 [final]指令碼
- Shell指令碼實現生成SSL自簽署證書指令碼
- awr自動收集指令碼指令碼
- 使用shell生成orabbix自動化配置指令碼指令碼
- 通過shell指令碼抓取awr報告中的問題sql指令碼SQL
- 透過shell指令碼抓取awr報告中的問題sql指令碼SQL
- 自動生成AWR報告並以郵件附件傳送
- 【效能優化】sqlplus中使用指令碼生成awr報告優化SQL指令碼
- 透過shell指令碼定位效能sql和生成報告指令碼SQL
- 通過shell指令碼定位效能sql和生成報告指令碼SQL
- Oracle生成awr報告Oracle
- Oracle 生成awr報告Oracle
- SHELL指令碼實現Oracle自啟動與關閉指令碼Oracle
- [shell]shell指令碼實現每天自動抽取資料插入hive表指令碼Hive
- 手工生成AWR分析報告
- [Shell] 自動生成oracle awr report並mail出來OracleAI
- 使用shell定製awr指令碼指令碼
- [Shell] Shell 生成 HTML指令碼HTML指令碼
- 利用shell指令碼生成動態sql指令碼SQL
- linux透過shell指令碼實現ssh互動式自動化Linux指令碼
- 巧用shell指令碼生成快捷指令碼指令碼
- 自動生成Statspack的指令碼指令碼
- ORACLE自動備份shell指令碼Oracle指令碼