Use of AWR reports

[Oracle @ localhost admin] $ pwd
/Home/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,200 5, Oracle. All rights reserved.

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

SQL> @/home/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
~~~~~~~~~~~~~~~~~~~~~~~
Wocould you like an HTML report, or a plain text report?
Enter 'html' for an html report, or 'text' for plain text
Ults to 'html'
Enter value for report_type: html (also the default value)
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(N) days of snapshots being listed. Pressing <return>
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 1
221 19 May 2013 1
222 19 May 2013 1
223 19 May 2013 1
224 19 May 2013 1
225 19 May 2013 1
226 19 May 2013 1
227 19 May 2013 1
228 19 May 2013 1
229 19 May 2013 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 <return> to continue, otherwise enter an alternative.
You can set the file name. After the report is analyzed, you can view the report in the browser (the overall running status of the database, the first few SQL statements that have been executed for a long time, parameter files, and so on, note that AWR is only a report and does not help us analyze how to optimize it. the ADDM report below will provide us with optimization suggestions ):



-- ===================================================== ====================================
There is also an addm report to help us analyze and provide necessary optimization suggestions:

SQL> @/home/oracle/product/10.2.0/db_1/rdbms/admin/addmrpt. SQL

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

DB Id DB Name Inst Num Instance
-------------------------------------------
1326384392 ORCL 1 orclsid


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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(N) days of snapshots being listed. Pressing <return>
Specifying a number lists all completed snapshots.

Listing the last 3 days of Completed Snapshots

Snap
Instance DB Name Snap Id Snap Started Level
--------------------------------------------------------
Orclsid ORCL 220 19 May 2013 1
221 19 May 2013 1
222 19 May 2013 1
223 19 May 2013 1
224 19 May 2013 1
225 19 May 2013 1
226 19 May 2013 1
227 19 May 2013 1
228 19 May 2013 1
229 19 May 2013 1
230 19 May 2013 1

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 228

Enter value for end_snap: 229
End Snapshot Id specified: 229

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is addmrpt_1_228_229.txt. To use this name,
Press <return> to continue, otherwise enter an alternative.

Enter value for report_name: the default file name can be used.
Detailed addm report for task 'Task _ 000000' with id 1814
------------------------------------------------------

Analysis Period: 19-MAY-2013 from 13:30:50 to 14:00:57
Database ID/Instance: 1326384392/1
Database/Instance Names: ORCL/orclsid
Host Name: localhost. localdomain
Database Version: 10.2.0.1.0
Snapshot Range: from 226 to 227
Database Time: 11 seconds
Average Database Load: 0 active sessions

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

There was not enough database time for addm analysis.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ADDITIONAL INFORMATION
----------------------

There was no significant database activity to run the ADDM.

The database's maintenance windows were active during 99% of the analysis
Period.

The analysis of I/O performance is based on the default assumption that
Average read time for one database block is 10000 micro-seconds.

An explanation of the terminology used in this report is available when you
Run the report with the 'all' level of detail.