Oracle AWR报告每天自动生成并发送邮箱.docVIP

Oracle AWR 报告 每天自动生成并发送邮箱?一. 准备工作 一般我们都是条用awrrpt.sql 来创建我们的AWR报告。 我们先看下这个脚本的具体内容：[oracle@rac1 admin]$ cat awrrpt.sql | grep -v Rem|grep -v ^-- set echo off heading on underline on;column inst_num heading Inst Num new_value inst_num format 99999;column inst_name heading Instance new_value inst_name format a12;column db_name heading DB Name new_value db_name format a12;column dbid heading DB Id new_value dbid format 9999999999 just c; promptprompt Current Instanceprompt ~~~~~~~~~~~~~~~~ select d.dbid dbid, db_name, i.instance_number inst_num, i.instance_name inst_namefrom v$database d,v$instance i; @@awrrpti undefine num_days;undefine report_type;undefine report_name;undefine begin_snap;undefine end_snap; 在以上的脚本里，我们发现它只是生成了一些变量，然后把这些变量传给了另一个脚本：awrrpti.sql。 我们看下awrrpti.sql 脚本的具体内容： [oracle@rac1 admin]$ cat awrrpti.sql | grep -v Rem|grep -v ^-- set echo off;set veri off;set feedback off; variable rpt_options number; define NO_OPTIONS = 0;define ENABLE_ADDM = 8; begin:rpt_options := amp;NO_OPTIONS;end;/ promptprompt Specify the Report Typeprompt ~~~~~~~~~~~~~~~~~~~~~~~prompt Would you like an HTML report, or a plain text report?prompt Enter html for an HTML report, or text for plain textprompt Defaults to html column report_type new_value report_type;set heading off;select Type Specified: ,lower(nvl(amp;amp;report_type,html)) report_type from dual;set heading on; set termout off;column ext new_value ext;select .html ext from dual where lower(amp;amp;report_type) lt;gt; text;select .txt ext from dual where lower(amp;amp;report_type) = text;set termout on; @@awrinput.sql -- 这个脚本主要是确定SNAP的。@@awrinpnm.sql awrrpt_ amp;amp;ext-- 这个脚本主要是确定AWR 文件名称的 set termout off;column fn_name new_value fn_name noprint;select awr_report_text fn_name from dual where lower(amp;report_type) = text;select awr_report_html fn_name from dual where lower(amp;report_type) lt;gt; text; column lnsz new_value lnsz noprint;select 80 lnsz from dual where lower(