[Oracle@localhost admin]$ pwd /home/oracle/oracle/product/10.2.0/db_1/rdbms/admin [oracle@localhost admin]$ sqlplus sys/
[oracle@localhost admin]$ pwd
/home/oracle/oracle/product/10.2.0/db_1/rdbms/admin
[oracle@localhost admin]$ sqlplus sys/lubinsu as sysdba
SQL*Plus: Release 10.2.0.1.0 – Production on Sun May 19 15:12:52 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options
SQL> @/home/oracle/oracle/product/10.2.0/db_1/rdbms/admin/awrrpt.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
———– ———— ——– ————
1326384392 ORCL 1 orclsid
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: html（也是缺省值）
Type Specified: html
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
———— ——– ———— ———— ————
* 1326384392 1 ORCL orclsid localhost.lo
caldomain
Using 1326384392 for database Id
Using 1 for instance number
Specify the number of days of snapshots to choose from
千图设计室AI海报
千图网旗下的智能海报在线设计平台
51 查看详情
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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: 2
Listing the last 2 days of Completed Snapshots
Snap
Instance DB Name Snap Id Snap Started Level
———— ———— ——— —————— —–
orclsid ORCL 220 19 May 2013 10:18 1
221 19 May 2013 11:00 1
222 19 May 2013 11:42 1
223 19 May 2013 12:00 1
224 19 May 2013 12:30 1
225 19 May 2013 13:00 1
226 19 May 2013 13:30 1
227 19 May 2013 14:00 1
228 19 May 2013 14:30 1
229 19 May 2013 15:00 1
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 228
Begin Snapshot Id specified: 228
Enter value for end_snap: 229
End Snapshot Id specified: 229
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_228_229.html. To use this name,
press to continue, otherwise enter an alternative.
可以设置文件名，报告分析之后：我们可以在浏览器中查看报告（这里列出了数据库的整体运行情况，执行时间长的前几条SQL，，参数文件，等等，注意AWR只是一个报告，并不会帮助我们分析该如何优化，在后面的ADDM报告则会为我们提供优化的建议）：
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。
如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至 chuangxiangniao@163.com 举报，一经查实，本站将立刻删除。
发布者：程序猿，转转请注明出处：https://www.chuangxiangniao.com/p/555012.html
微信扫一扫 
支付宝扫一扫 
