Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2232645
  • 博文数量: 310
  • 博客积分: 6853
  • 博客等级: 准将
  • 技术积分: 2833
  • 用 户 组: 普通用户
  • 注册时间: 2005-08-04 16:41
文章分类

全部博文(310)

文章存档

2013年(17)

2012年(42)

2011年(76)

2010年(71)

2009年(99)

2007年(2)

2006年(1)

2005年(2)

分类: Oracle

2012-02-24 13:37:22


Oracle性能分析入門學習中,遇到Oracle數據庫的性能問題,壹般首要的步驟就是導出AWR的分析報告,AWR是10g中新引入的壹個工具,在這之前壹般是利用statspack。要導出AWR報告,只要利用Oracle的壹個腳本即可以完成,下面是我利用script錄制的壹段導出AWR report的過程。
  首先進入$ORACLE_HOME/rdbms/admin目錄,在sqlplus下運行@awrrpt腳本,按照提示壹步壹步就可以達成,導出的格式有兩種,txt格式和html格式。
  在OTN上,有壹個DBA新feature系列,第六周就是專門講的這個feature,大家可以去那裏了解壹下(中文的)
  Script started on Sun 27 Jan 2008 08:47:15 PM PST
  [ractest@sun880-1 /u01/app/oracle/orahome/rdbms/admin]$ cd $ORACLE_HOME/rdbms/admin
  [ractest@sun880-1 /u01/app/oracle/orahome/rdbms/admin]$ sqlplus / as sysdba
  SQL*Plus: Release 10.2.0.4.0 - Production on Sun Jan 27 20:47:38 2008
  Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
  Connected to:
  Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
  With the Partitioning, Real Application Clusters, OLAP, Data Mining
  and Real Application Testing options
  SQL> @awrrpt
  Current Instance
  ~~~~~~~~~~~~~~~~
  DB Id DB Name Inst Num Instance
  ———– ———— ——– ————
  2080780909 ORCLDB 1 orcldb1
  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’
  Enter value for report_type: text
  Type Specified: text
  Instances in this Workload Repository schema
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  DB Id Inst Num DB Name Instance Host
  ———— ——– ———— ———— ————
  * 2080780909 1 ORCLDB orcldb1 sun880-1
  2080780909 4 ORCLDB orcldb4 sun880-4
  2080780909 2 ORCLDB orcldb2 sun880-2
  2080780909 3 ORCLDB orcldb3 sun880-3
  Using 2080780909 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.
  Enter value for num_days: 1
  Listing the last day’s Completed Snapshots
  Snap
  Instance DB Name Snap Id Snap Started Level
  ———— ———— ——— —————— —–
  orcldb1 ORCLDB 66 27 Jan 2008 00:55 1
  67 27 Jan 2008 01:55 1
  68 27 Jan 2008 02:55 1
  69 27 Jan 2008 03:55 1
  70 27 Jan 2008 04:55 1
  71 27 Jan 2008 05:55 1
  72 27 Jan 2008 06:55 1
  73 27 Jan 2008 07:55 1
  74 27 Jan 2008 08:55 1
  75 27 Jan 2008 09:55 1
  76 27 Jan 2008 10:55 1
  77 27 Jan 2008 11:55 1
  78 27 Jan 2008 12:55 1
  83 27 Jan 2008 17:54 1
  84 27 Jan 2008 18:55 1
  85 27 Jan 2008 19:55 1
  Specify the Begin and End Snapshot Ids
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  Enter value for begin_snap: 70
  Begin Snapshot Id specified: 70
  Enter value for end_snap: 71
  End Snapshot Id specified: 71
  Specify the Report Name
  ~~~~~~~~~~~~~~~~~~~~~~~
  The default report file name is awrrpt_1_70_71.txt. To use this name,
  press to continue, otherwise enter an alternative.
  Enter value for report_name:
  Using the report name awrrpt_1_70_71.txt
  WORKLOAD REPOSITORY report for
  DB Name DB Id Instance Inst Num Release RAC Host
  ———— ———– ———— ——– ———– — ————
  ORCLDB 2080780909 orcldb1 1 10.2.0.4.0 YES sun880-1
  Snap Id Snap Time Sessions Curs/Sess
  ——— ——————- ——– ———
  Begin Snap: 70 27-Jan-08 04:55:07 136 16.2
  End Snap: 71 27-Jan-08 05:55:21 141 16.5
  Elapsed: 60.23 (mins)
  DB Time: 5,814.07 (mins)
  Cache Sizes
  ~~~~~~~~~~~ Begin End
  //此處有刪減
  ————————————————————-
  End of Report
  Report written to awrrpt_1_70_71.txt
  SQL> quit
  Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
  With the Partitioning, Real Application Clusters, OLAP, Data Mining
  and Real Application Testing options
  [ractest@sun880-1 /u01/app/oracle/orahome/rdbms/admin]$ exit
  script done on Sun 27 Jan 2008 08:48:16 PM PST
阅读(2089) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~