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
Other related posts:
