Could I recommend running an ASH at the time of the incident? ASH is a great
way to get a view of the environment at small units of time and to see what was
going on at that time. ADDM and AWR do rely on snapshots, where ASH will run
against the samples which are collected all the time.
Hope this helps,
Kellyn
On Jul 11, 2016, at 1:55 PM, <fmhabash@xxxxxxxxx> <fmhabash@xxxxxxxxx> wrote:
Whatever this query tells you
select startup_time, min(snap_id), max(snap_id) from dba_hist_snapshot group
by startup_time
STARTUP_TIME MIN(SNAP_ID) MAX(SNAP_ID)
------------ ------------ ------------
7/8/2016 1:1 84508 84974
5/26/2016 7: 82251 84507
12/11/2015 4 80058 82250
----------------------------------------
Thank you
From: David Ramírez Reyes <mailto:dramirezr@xxxxxxxxx>
Sent: Monday, July 11, 2016 3:06 PM
To: 'oracle-l@xxxxxxxxxxxxx' (oracle-l@xxxxxxxxxxxxx)
<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: AWR Report
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
