Re: how to get the list of SQL's

Main Entry: snap�shot
Pronunciation: \?snap-?sh�t\
Function: noun
Date: 1890

1 : a casual photograph made typically by an amateur with a small handheld camera
2 : an impression or view of something brief or transitory <a snapshot of life back then>

What you are asking is the equivalent of:

"I have a picture of my hometown in the early 1920s. I have a picture of my hometown today. I'd like to know about all the constructions/destructions that occurred in between".

I can tell you that with my own hometown if you miss some information about the 1940s it will be rather difficult. http://virtedit.free.fr/app00014.JPG?41,45

The only thing you have (in the DBA_HIST views) is counters about the number of executions in the interval, the equivalent (to keep with my image) of "that building that you see standing here has been photographed that many times since the previous snapshot you have".

In other words, you CANNOT have a list of everything that happened. But if the pattern of what is running is regular enough, which is generally the case, you can with confidence say what put brought your database to its knees.

Stephane Faroult
RoughSea Ltd <http://www.roughsea.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>

Ojha, Ajeet (GE Healthcare, consultant) wrote:
>
> Hello
>
> I want to get the list of SQL’s /pl/sql programs/ and any other thing
> which ran in database during a specific timeframe say 10am to 12 am.
>
> We are using oracle 10.2.0.4 and AWR snaps are being taken at every 30
> minutes.
>
> What I really want is write a SQL which will take the AWR snap numbers
> as input and then give me all the SQL’s executed between those 2 sanps.
>
> Really appreciate if someone can throw some light on this.
>
> Thanks
>

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