[RAC Clusterware] 【技术分享】开Oracle调优鹰眼，深入理解AWR性能报告

查看: 38640| 回复: 107

wom

51^#

发表于 2013-3-3 23:51:13

会议时间刚好上班，看来只能好好看看刘大的讲稿了

回复只看该作者道具举报

graemes

52^#

发表于 2013-3-4 08:19:04

一定支持

回复只看该作者道具举报

张沛

53^#

发表于 2013-3-4 09:01:03

顶起顶起

回复只看该作者道具举报

longandy9

54^#

发表于 2013-3-4 09:39:09

十二分的期待中~~~，感谢maclean老大！

回复只看该作者道具举报

baolei

55^#

发表于 2013-3-4 09:51:41

很强大，上班也要听

回复只看该作者道具举报

archerhong

56^#

发表于 2013-3-4 10:14:52

看了分享的文档真心不错

回复只看该作者道具举报

Ling.QIu

57^#

发表于 2013-3-4 10:20:55

ML 论坛里的所写的Oracle-base的脚本，由于某些原因(你懂的)，给不会的童鞋贴在这里
-- -----------------------------------------------------------------------------------
-- File Name : http://www.oracle-base.com/dba/1 ... ple_awr_reports.sql
-- Author    : DR Timothy S Hall
-- Description  : Generates AWR reports for all snapsots between the specified start and end point.
-- Requirements : Access to the v$ views, UTL_FILE and DBMS_WORKLOAD_REPOSITORY packages.
-- Call Syntax  : Create the directory with the appropriate path.
--             Adjust the start and end snapshots as required.
--             @generate_multiple_awr_reports.sql
-- Last Modified: 02/08/2007
-- -----------------------------------------------------------------------------------
CREATE OR REPLACE DIRECTORY awr_reports_dir AS '/tmp/';

DECLARE
  -- Adjust before use.
  l_snap_start    NUMBER := 1;
  l_snap_end       NUMBER := 10;
  l_dir             VARCHAR2(50) := 'AWR_REPORTS_DIR';

  l_last_snap       NUMBER := NULL;
  l_dbid          v$database.dbid%TYPE;
  l_instance_number  v$instance.instance_number%TYPE;
  l_file          UTL_FILE.file_type;
  l_file_name       VARCHAR(50);

BEGIN
  SELECT dbid
  INTO l_dbid
  FROM v$database;

  SELECT instance_number
  INTO l_instance_number
  FROM v$instance;

  FOR cur_snap IN (SELECT snap_id
               FROM dba_hist_snapshot
               WHERE  instance_number = l_instance_number
               AND snap_id BETWEEN l_snap_start AND l_snap_end
               ORDER BY snap_id)
  LOOP
IF l_last_snap IS NOT NULL THEN
   l_file := UTL_FILE.fopen(l_dir, 'awr_' || l_last_snap || '_' || cur_snap.snap_id || '.htm', 'w', 32767);

   FOR cur_rep IN (SELECT output
                  FROM TABLE(DBMS_WORKLOAD_REPOSITORY.awr_report_html(l_dbid, l_instance_number, l_last_snap, cur_snap.snap_id)))
   LOOP
      UTL_FILE.put_line(l_file, cur_rep.output);
   END LOOP;
   UTL_FILE.fclose(l_file);
END IF;
l_last_snap := cur_snap.snap_id;
  END LOOP;

EXCEPTION
  WHEN OTHERS THEN
IF UTL_FILE.is_open(l_file) THEN
   UTL_FILE.fclose(l_file);
END IF;
RAISE;
END;
/

回复只看该作者道具举报