How to generate Oracle AWR reports ____oracle

Source: Internet
Author: User
Tags sqlplus

Oracle performance analysis in the introduction of learning, encountered Oracle database performance problems, the most important step is to export the AWR analysis report, AWR is a new tool introduced in 10g, before this is generally the use of statspack. To export the AWR report, you can do so as long as you use one of Oracle's scripts, and here is the process of exporting AWR reports using a section of the script recording.
First into the $oracle_home/rdbms/admin directory, under the Sqlplus run @awrrpt script, follow the prompts step-by-step can be achieved, the export format has two types, txt format and HTML format.
On the OTN, there is a new feature series DBA, the sixth week is devoted to this feature, you can go there to understand (Chinese)
Script started on Sun-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 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
~~~~~~~~~~~~~~~~~~~~~~~
Would you like an HTML, or a plain text?
Enter ' HTML ' for a HTML, 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) would 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 2008 00:55 1
2008 01:55 1
2008 02:55 1
2008 03:55 1
2008 04:55 1
2008 05:55 1
2008 06:55 1
2008 07:55 1
The 2008 08:55 1
2008 09:55 1
2008 10:55 1
2008 11:55 1
2008 12:55 1
2008 17:54 1
2008 18:55 1
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 "the" Name
~~~~~~~~~~~~~~~~~~~~~~~
The default file name is Awrrpt_1_70_71.txt. To use this name,
Press to continue, otherwise enter a alternative.
Enter value for Report_name:
Using the "the" name Awrrpt_1_70_71.txt
Workload REPOSITORY 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
There are cuts here

————————————————————-
End of the
The 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-2008 08:48:16 PM PST

Own experiment done HTML, feel very good, can view the form of the report, readable, with Firefox commands can view HTML format pages, such as: Firefox awrrpt_1_233_235.html,

You'll see an interface like this:


Excerpt from: http://jxpengtao.javaeye.com/blog/491847

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.