Home » RDBMS Server » Performance Tuning » Query "Statements run in past 24 hrs with execution time" (Oracle 10.2.0.4)
Query "Statements run in past 24 hrs with execution time" [message #402307] Fri, 08 May 2009 11:35 Go to next message
harshkumar
Messages: 34
Registered: February 2008
Location: Delhi
Member
Hi All,

Is there any query to get the information about the queries that run in the database in past 24 hours and the execution time taken by the query and how many time a query is executed.

If any possibility to get the same information from AWR.

Please provide the query.

Thanks
Harsh
Re: Query "Statements run in past 24 hrs with execution time" [message #402310 is a reply to message #402307] Fri, 08 May 2009 11:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64101
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALL queries, there is no way.
The most consuming ones, have a look at dba_hist% views.

Regards
Michel
Re: Query "Statements run in past 24 hrs with execution time" [message #402312 is a reply to message #402307] Fri, 08 May 2009 12:08 Go to previous messageGo to next message
harshkumar
Messages: 34
Registered: February 2008
Location: Delhi
Member
Hi Michal,

Thanks for the reply.

Can you provide the sql to find out that "How many times the particular query executed and time take per exection" in say last one hour.

Thanks,
Harsh
Re: Query "Statements run in past 24 hrs with execution time" [message #402313 is a reply to message #402312] Fri, 08 May 2009 12:25 Go to previous message
Michel Cadot
Messages: 64101
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you try to find in the views I mentionned?

Regards
Michel
Previous Topic: get list of all sql's executed in a session with out sql trace
Next Topic: Gets and GetHits difference ?
Goto Forum:
  


Current Time: Fri Dec 02 13:55:19 CST 2016

Total time taken to generate the page: 0.20666 seconds