ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle 10g awr性能收集工具的用法

oracle 10g awr性能收集工具的用法

原创 Linux操作系统 作者:paulyibinyi 时间:2009-02-05 11:56:04 0 删除 编辑

     oracle 10g addm工具根据awr收集的信息能给出个解决方案,以下是awr脚本的用法

和statspack工具差不多。

C:\Documents and Settings\Administrator>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 2月 5 11:52:18 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> @?/rdbms/admin/awrrpt.sql

Current Instance
~~~~~~~~~~~~~~~~

   DB Id    DB Name      Inst Num Instance
----------- ------------ -------- ------------
 1199626219 ORCL                1 orcl


Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Would you like an HTML report, or a plain text report?
Enter 'html' for an HTML report, or 'text' for plain text
Defaults to 'html'
输入 report_type 的值:  text

Type Specified:  text


Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   DB Id     Inst Num DB Name      Instance     Host
------------ -------- ------------ ------------ ------------
* 1199626219        1 ORCL         orcl         PRIMARY
* 1199626219        1 ORCL         orcl         RAC1
* 1199626219        1 ORCL         orcl         STANDBY

Using 1199626219 for database Id
Using          1 for instance number


Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed.  Pressing without
specifying a number lists all completed snapshots.


输入 num_days 的值:  4

Listing the last 4 days of Completed Snapshots

                                                        Snap
Instance     DB Name        Snap Id    Snap Started    Level
------------ ------------ --------- ------------------ -----
orcl         ORCL                25 03 2月  2009 13:53     1

                                 26 03 2月  2009 15:00     1
                                 27 03 2月  2009 16:00     1
                                 28 03 2月  2009 16:05     1
                                 29 03 2月  2009 16:06     1
                                 30 03 2月  2009 16:07     1
                                 31 03 2月  2009 16:09     1
                                 32 03 2月  2009 17:00     1

                                 33 05 2月  2009 09:42     1

 

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
输入 begin_snap 的值:  28
Begin Snapshot Id specified: 28

输入 end_snap 的值:  29
End   Snapshot Id specified: 29

 

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_28_29.txt.  To use this name,
press to continue, otherwise enter an alternative.

输入 report_name 的值:d:\awrrpt_1_28_29.txt  即可

 通过以下视图可以查出,做快照的间隔时间和保留多长时间

select snap_interval, retention
from dba_hist_wr_control;

SNAP_INTERVAL       RETENTION
------------------- -------------------
+00000 01:00:00.0   +00007 00:00:00.0

这些 SQL 语句显示快照每小时采集一次,采集的数据保留 7 天。要修改设置 例如,快照时间间隔为 30 分钟,保留时间为三天 您可以发出以下命令。参数以分钟为单位。

begin
   dbms_workload_repository.modify_snapshot_settings (
      interval => 30,
      retention => 3*24*60
   );
end;
具体awr报告比statspack报告多了很多东西出来,还有待具体研究

                                                            

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7199859/viewspace-545351/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
学习数据库

注册时间:2007-12-11

  • 博文量
    902
  • 访问量
    6596310