OraFAQ Forum: Performance Tuning » Query "Statements run in past 24 hrs with execution time"

Home » RDBMS Server » Performance Tuning » Query "Statements run in past 24 hrs with execution time" (Oracle 10.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query "Statements run in past 24 hrs with execution time" [message #402307]

Fri, 08 May 2009 11:35

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

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ALL queries, there is no way.
The most consuming ones, have a look at dba_hist% views.

Regards
Michel

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Did you try to find in the views I mentionned?

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 00:02:47 CST 2024