how to get the list of SQL's

From: "Ojha, Ajeet (GE Healthcare, consultant)" <Ajeet.Ojha@xxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 1 Apr 2010 13:29:58 +0530

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

Follow-Ups:

Re: how to get the list of SQL's
From: Stephane Faroult

how to get the list of SQL's

Other related posts: