Awr-compares two stages of performance

In the actual environment, you need to compare two different time points of performance, so the production of two points of time ARW and make some comparisons!

Example: A AWR report that produces an entire database. In this case, Oracle's home directory is

S:\app\Administrator\product\11.2.0\dbhome_1

Run the script Awrrpt.sql.

Sql> @?/rdbms/admin/awrddrpt.sql

Current Instance

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

DB ID DB ID db Name inst num Inst num Instance

----------- ----- ------ ------------ -------- -------- ------------

1337234614 1337234614 ORCL 1 1 ORCL

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: HTML

Type specified:html

Instances in this workload Repository schema

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

DB Id Inst Num db Name Instance Host

------ ------ -------- ------------ ------------ ------------

* 1337234614 1 ORCL ORCL JINRI185

Database Id and Instance number for the ' the ' Pair of snapshots

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

Usi ng 1337234614 for Database Id for the ' the ' the ' the ' the ' the ' a snapshots

Using 1 for Instance number for the ' pair ' of snapshots

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 <return> 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

------------ ------------ ------- -- ------------------ -----

ORCL ORCL 1136 24 April 2013 00:00 1

1137 24 April 2013 01:00 1

1138 24 April 2013 02:00 1

1139 24 April 2013 03:00 1

1140 24 April 2013 04:00 1

1141 24 April 2013 05:00 1

1142 24 April 2013 06:00 1

1143 24 April 2013 07:00 1

1144 24 April 2013 08:00 1

1145 24 April 2013 09:00 1

1146 24 April 2013 10:00 1

1147 24 April 2013 11:00 1

1148 24 April 2013 12:00 1

1149 24 April 2013 13:00 1

1150 24 April 2013 14:00 1

1151 24 April 2013 15:00 1

1152 24 April 2013 16:00 1

1153 24 April 2013 17:00 1

1154 24 April 2013 18:00 1

1155 24 April 2013 19:00 1

1156 24 April 2013 20:00 1

1157 24 April 2013 21:00 1

1158 24 April 2013 22:00 1

1159 24 April 2013 23:00 1

1160 25 April 2013 00:00 1

1161 25 April 2013 01:00 1

1162 25 April 2013 02:00 1

1163 25 April 2013 03:00 1

1164 25 April 2013 04:00 1

1165 25 April 2013 05:00 1

1166 25 April 2013 06:00 1

1167 25 April 2013 07:00 1

1168 25 April 2013 08:00 1

1169 25 April 2013 09:00 1

1170 25 April 2013 10:00 1

1171 25 April 2013 11:00 1

1172 25 April 2013 12:00 1

1173 25 April 2013 13:00 1

1174 25 April 2013 14:00 1

1175 25 April 2013 15:00 1

Specify the ' Pair ' of Begin and end Snapshot Ids

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

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/