AWR Report

From: David Ramírez Reyes <dramirezr_at_gmail.com>
Date: Mon, 11 Jul 2016 14:04:52 -0500
Message-ID: <CAJt=wvXgcbmnJr11NTzSs-aD8HmWacAwxXXLk3v-DGa6d9pT6g_at_mail.gmail.com>

Hello all,

RHEL 5, 11g R2

DB was hung at 10:15 am; am trying to get an AWR Report from 10 to 10:30 am but the package failed because there was a shutdown in the midle (the DB was restarted to become online again).

Do any know if there's a way to generate the AWR Report from 10:00 am to the time the last statistic was generated?

The files are sequencial and does not let me get it:

Using 3097553944 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: 1
Listing the last day's Completed Snapshots

                                                        Snap
Instance     DB Name        Snap Id    Snap Started    Level
------------ ------------ --------- ------------------ -----
KMMMESV1P    KMMMESV1         14356 11 Jul 2016 00:00      1
                              14357 11 Jul 2016 00:30      1
                              14358 11 Jul 2016 01:00      1
                              14359 11 Jul 2016 01:30      1
                              14360 11 Jul 2016 02:00      1
                              14361 11 Jul 2016 02:30      1
                              14362 11 Jul 2016 03:00      1
                              14363 11 Jul 2016 03:30      1
                              14364 11 Jul 2016 04:00      1
                              14365 11 Jul 2016 04:30      1
                              14366 11 Jul 2016 05:00      1
                              14367 11 Jul 2016 05:30      1
                              14368 11 Jul 2016 06:00      1
                              14369 11 Jul 2016 06:30      1
                              14370 11 Jul 2016 07:00      1
                              14371 11 Jul 2016 07:30      1
                              14372 11 Jul 2016 08:00      1
                              14373 11 Jul 2016 08:30      1
                              14374 11 Jul 2016 09:00      1
                              14375 11 Jul 2016 09:30      1
                              14376 11 Jul 2016 10:00      1
                              14377 11 Jul 2016 10:36      1
                              14378 11 Jul 2016 11:00      1
                              14379 11 Jul 2016 11:30      1
                              14380 11 Jul 2016 12:00      1
                              14381 11 Jul 2016 12:30      1
                              14382 11 Jul 2016 13:00      1
                              14383 11 Jul 2016 13:30      1
                              14384 11 Jul 2016 14:00      1

Specify the Begin and End Snapshot Ids

---

Enter value for begin_snap: 14376
Begin Snapshot Id specified: 14376
Enter value for end_snap: 14377
End Snapshot Id specified: 14377

declare
*
ERROR at line 1:
ORA-20200: The instance was shutdown between snapshots 14376 and 14377 ORA-06512: at line 42

David Ramírez Reyes
Profesión: Padre de Familia y DBA en mis ratos libres Profession: Parent and DBA in my spare time

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 11 2016 - 21:04:52 CEST