Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "how to get the script of AWR". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

#! / bin/bash#by raysuen#v02. ~ / .bash_profileAWR_FORMAT=htmlNUM_DAYS=2# function to get snapid at a specified time # getsnapID () {BEGIN_ SNAP_ID= `sqlplus-S / as sysdba / dev/null 2 > & 1if [$?-ne 0] Then echo "The valus of-e is invalid date." Exit 97fi# executes function Get snap id####getsnapID ${awrbegintime} ${awrendtime} # define the path to the awr report # # # AWR_LOG=/u02/logout/awr/AWR_$ {awrname} _ ${awrbegintime} _ ${awrendtime} .html # get awr report # # # echo-e "$AWR_FORMAT\ n$NUM_DAYS\ n$BEGIN_SNAP_ID\ n$END_SNAP_ID\ n$AWR_LOG\ n" | (sqlplus-S / as sysdba @? / rdbms/admin/awrrpt.sql) > / dev/null## # help: # parameters are case sensitive #-start time of b awr Format: end time of yyyymmddhh34#-e awr Format: name in yyyymmddhh34#-n awr report # example: #. / GET_AWR.SH-b "2019051708"-e "2019051709"-n test#. / GET_AWR.sh-b `date +'% Y% m% d18'-d'+ 1 day ago' `- e `date +'% Y% m% d19'-d'+ 1 day ago'`-n test# # # so much for the content of "how to get a script for AWR" Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.