Re: AWR Report for missing Snapshot Time

From: Sanjay Mishra <>
Date: Wed, 17 Feb 2010 14:51:31 -0800 (PST)
Message-ID: <>

thanks John

From: John Kanagaraj <> To:
Sent: Wed, February 17, 2010 5:09:39 PM
Subject: Re: AWR Report for missing Snapshot Time

Hi Sanjay,

> Oracle will skip the Snap ID if the database is bounced. So suppose if the
> Database is Crashed at 10:45, then I cannot generate 10-11 AWR report but as
> the information is already passed from ASH to Workload Repository tables due
> to high transaction, is it possible to get this report manually from the
> Tables directly. Can someone share their experience as how we can get that
> information from WR

ASH collects session level states - it does NOT collect system wide stats (such as from V$SYSTEM_EVENT and V$SYSSTAT) that AWR does. You might be able to get some of the High load SQL, and try and draw some conclusion about the type and count of Wait events encountered, but that is about it. For instance, the ASH report will show you the Top 5 User events, but what you will get is the %Acitivity and the AAS (Average Active Sessions).

John Kanagaraj <>< (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **

Received on Wed Feb 17 2010 - 16:51:31 CST

Original text of this message