Generate AWR Reports


[oracle@BAKUANARDBDB dpdump]$ sqlplus "/ as sysdba";

SQL*Plus: Release 11.2.0.3.0 Production on Sun Nov 10 19:57:46 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
 Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
 With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

SQL> select name from v$database;

NAME

---------

ANARDB

SQL> @?/rdbms/admin/awrrpt

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

DB Id DB Name Inst Num Instance
 ----------- ------------ -------- ------------
 4040405938 ANARDB 1 ANARDB

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
 ------------ -------- ------------ ------------ ------------
 * 4040405938 1 ANARDB ANARDB BAKUANARDBDB

Using 4040405938 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> without
 specifying a number lists all completed snapshots.

Enter value for num_days:

Listing all Completed Snapshots

Snap
 Instance DB Name Snap Id Snap Started Level
 ------------ ------------ --------- ------------------ -----
 ANARDB ANARDB 64 02 Nov 2013 05:00 1
 65 02 Nov 2013 06:00 1
 66 02 Nov 2013 07:00 1
 67 02 Nov 2013 08:00 1
 68 02 Nov 2013 09:00 1
 69 02 Nov 2013 10:00 1
 70 02 Nov 2013 11:00 1
 71 02 Nov 2013 12:00 1
 72 02 Nov 2013 13:00 1
 73 02 Nov 2013 14:00 1
 74 02 Nov 2013 15:00 1
 75 02 Nov 2013 16:00 1
 76 02 Nov 2013 17:00 1
 77 02 Nov 2013 18:00 1
 78 02 Nov 2013 19:00 1
 79 02 Nov 2013 20:00 1
 80 02 Nov 2013 21:00 1
 81 02 Nov 2013 22:00 1
 82 02 Nov 2013 23:00 1
 83 03 Nov 2013 00:00 1
 84 03 Nov 2013 01:00 1
 85 03 Nov 2013 02:00 1
 86 03 Nov 2013 03:00 1
 87 03 Nov 2013 04:00 1
 88 03 Nov 2013 05:00 1
 89 03 Nov 2013 06:00 1
 90 03 Nov 2013 07:00 1
 91 03 Nov 2013 08:00 1
 92 03 Nov 2013 09:00 1
 93 03 Nov 2013 10:00 1
 94 03 Nov 2013 11:00 1
 95 03 Nov 2013 12:00 1
 96 03 Nov 2013 13:00 1
 97 03 Nov 2013 14:00 1
 98 03 Nov 2013 15:00 1
 99 03 Nov 2013 16:00 1
 100 03 Nov 2013 17:00 1
 101 03 Nov 2013 18:00 1
 102 03 Nov 2013 19:00 1
 103 03 Nov 2013 20:00 1
 104 03 Nov 2013 21:00 1
 105 03 Nov 2013 22:00 1
 106 03 Nov 2013 23:00 1
 107 04 Nov 2013 00:00 1
 108 04 Nov 2013 01:00 1
 109 04 Nov 2013 02:00 1
 110 04 Nov 2013 03:00 1
 111 04 Nov 2013 04:00 1
 112 04 Nov 2013 05:00 1
 113 04 Nov 2013 06:00 1
 114 04 Nov 2013 07:00 1
 115 04 Nov 2013 08:00 1
 116 04 Nov 2013 09:00 1
 117 04 Nov 2013 10:00 1
 118 04 Nov 2013 11:00 1
 119 04 Nov 2013 12:00 1

Snap
 Instance DB Name Snap Id Snap Started Level
 ------------ ------------ --------- ------------------ -----
 ANARDB ANARDB 120 04 Nov 2013 13:00 1
 121 04 Nov 2013 14:00 1
 122 04 Nov 2013 15:00 1
 123 04 Nov 2013 16:00 1
 124 04 Nov 2013 17:00 1
 125 04 Nov 2013 18:00 1
 126 04 Nov 2013 19:00 1
 127 04 Nov 2013 20:00 1
 128 04 Nov 2013 21:00 1
 129 04 Nov 2013 22:00 1
 130 04 Nov 2013 23:00 1
 131 05 Nov 2013 00:00 1
 132 05 Nov 2013 01:00 1
 133 05 Nov 2013 02:00 1
 134 05 Nov 2013 03:00 1
 135 05 Nov 2013 04:00 1
 136 05 Nov 2013 05:00 1
 137 05 Nov 2013 06:00 1
 138 05 Nov 2013 07:00 1
 139 05 Nov 2013 08:00 1
 140 05 Nov 2013 09:00 1
 141 05 Nov 2013 10:00 1
 142 05 Nov 2013 11:00 1
 143 05 Nov 2013 12:00 1
 144 05 Nov 2013 13:00 1
 145 05 Nov 2013 14:00 1
 146 05 Nov 2013 15:00 1
 147 05 Nov 2013 16:00 1
 148 05 Nov 2013 17:00 1
 149 05 Nov 2013 18:00 1
 150 05 Nov 2013 19:00 1
 151 05 Nov 2013 20:00 1
 152 05 Nov 2013 21:00 1
 153 05 Nov 2013 22:00 1
 154 05 Nov 2013 23:00 1
 155 06 Nov 2013 00:00 1
 156 06 Nov 2013 01:00 1
 157 06 Nov 2013 02:01 1
 158 06 Nov 2013 03:00 1
 159 06 Nov 2013 04:00 1
 160 06 Nov 2013 05:00 1
 161 06 Nov 2013 06:00 1
 162 06 Nov 2013 07:00 1
 163 06 Nov 2013 08:00 1
 164 06 Nov 2013 09:00 1
 165 06 Nov 2013 10:00 1
 166 06 Nov 2013 11:00 1
 167 06 Nov 2013 12:00 1
 168 06 Nov 2013 13:00 1
 169 06 Nov 2013 14:00 1
 170 06 Nov 2013 15:00 1
 171 06 Nov 2013 16:00 1
 172 06 Nov 2013 17:00 1
 173 06 Nov 2013 18:00 1
 174 06 Nov 2013 19:00 1
 175 06 Nov 2013 20:00 1

Snap
 Instance DB Name Snap Id Snap Started Level
 ------------ ------------ --------- ------------------ -----
 ANARDB ANARDB 176 06 Nov 2013 21:00 1
 177 06 Nov 2013 22:00 1
 178 06 Nov 2013 23:00 1
 179 07 Nov 2013 00:00 1
 180 07 Nov 2013 01:00 1
 181 07 Nov 2013 02:00 1
 182 07 Nov 2013 03:00 1
 183 07 Nov 2013 04:00 1
 184 07 Nov 2013 05:00 1
 185 07 Nov 2013 06:00 1
 186 07 Nov 2013 07:00 1
 187 07 Nov 2013 08:00 1
 188 07 Nov 2013 09:00 1
 189 07 Nov 2013 10:00 1
 190 07 Nov 2013 11:00 1
 191 07 Nov 2013 12:00 1
 192 07 Nov 2013 13:00 1
 193 07 Nov 2013 14:00 1
 194 07 Nov 2013 15:00 1
 195 07 Nov 2013 16:00 1
 196 07 Nov 2013 17:00 1
 197 07 Nov 2013 18:00 1
 198 07 Nov 2013 19:00 1
 199 07 Nov 2013 20:00 1
 200 07 Nov 2013 21:00 1
 201 07 Nov 2013 22:00 1
 202 07 Nov 2013 23:00 1
 203 08 Nov 2013 00:00 1
 204 08 Nov 2013 01:00 1
 205 08 Nov 2013 02:00 1
 206 08 Nov 2013 03:00 1
 207 08 Nov 2013 04:00 1
 208 08 Nov 2013 05:00 1
 209 08 Nov 2013 06:00 1
 210 08 Nov 2013 07:00 1
 211 08 Nov 2013 08:00 1
 212 08 Nov 2013 09:00 1
 213 08 Nov 2013 10:00 1
 214 08 Nov 2013 11:00 1
 215 08 Nov 2013 12:00 1
 216 08 Nov 2013 13:00 1
 217 08 Nov 2013 14:00 1
 218 08 Nov 2013 15:00 1
 219 08 Nov 2013 16:00 1
 220 08 Nov 2013 17:00 1
 221 08 Nov 2013 18:00 1
 222 08 Nov 2013 19:00 1
 223 08 Nov 2013 20:00 1
 224 08 Nov 2013 21:00 1
 225 08 Nov 2013 22:00 1
 226 08 Nov 2013 23:00 1
 227 09 Nov 2013 00:00 1
 228 09 Nov 2013 01:00 1
 229 09 Nov 2013 02:00 1
 230 09 Nov 2013 03:00 1
 231 09 Nov 2013 04:00 1

Snap
 Instance DB Name Snap Id Snap Started Level
 ------------ ------------ --------- ------------------ -----
 ANARDB ANARDB 232 09 Nov 2013 05:00 1
 233 09 Nov 2013 06:00 1
 234 09 Nov 2013 07:00 1
 235 09 Nov 2013 08:00 1
 236 09 Nov 2013 09:00 1
 237 09 Nov 2013 10:00 1
 238 09 Nov 2013 11:00 1
 239 09 Nov 2013 12:00 1
 240 09 Nov 2013 13:00 1
 241 09 Nov 2013 14:00 1
 242 09 Nov 2013 15:00 1
 243 09 Nov 2013 16:00 1
 244 09 Nov 2013 17:00 1
 245 09 Nov 2013 18:00 1
 246 09 Nov 2013 19:00 1
 247 09 Nov 2013 20:00 1
 248 09 Nov 2013 21:00 1
 249 09 Nov 2013 22:00 1
 250 09 Nov 2013 23:00 1
 251 10 Nov 2013 00:00 1
 252 10 Nov 2013 01:00 1
 253 10 Nov 2013 02:00 1
 254 10 Nov 2013 03:00 1
 255 10 Nov 2013 04:00 1
 256 10 Nov 2013 05:00 1
 257 10 Nov 2013 06:00 1
 258 10 Nov 2013 07:00 1
 259 10 Nov 2013 08:00 1
 260 10 Nov 2013 09:00 1
 261 10 Nov 2013 10:00 1
 262 10 Nov 2013 11:00 1
 263 10 Nov 2013 12:00 1
 264 10 Nov 2013 13:00 1
 265 10 Nov 2013 14:00 1
 266 10 Nov 2013 15:00 1
 267 10 Nov 2013 16:00 1
 268 10 Nov 2013 17:00 1
 269 10 Nov 2013 18:00 1
 270 10 Nov 2013 19:00 1
 271 10 Nov 2013 20:00 1

Specify the Begin and End Snapshot Ids

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

Enter value for begin_snap: 268

Begin Snapshot Id specified: 268

Enter value for end_snap: 271

End Snapshot Id specified: 271

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

Enter value for report_name: /home/oracle/awrrpt_11102013.html

Go to  /home/oracle/ location and open awrrpt_11102013.html. Then Analyze the AWR results :)

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: