OraFAQ Forum: Performance Tuning » How to find out all the queries that are executed in particular range of time in oracle instance.

Home » RDBMS Server » Performance Tuning » How to find out all the queries that are executed in particular range of time in oracle instance. (Oracle 10g [10.2.0.3.0] windows 7)

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

How to find out all the queries that are executed in particular range of time in oracle instance. [message #522406]

Fri, 09 September 2011 04:55

gopieee16
Messages: 26
Registered: May 2011
Location: Chennai

Junior Member

Hi experts,

here we have an scenario where we want to find out all the sql statements that are executed in a particular time. The sql statements are executed via our application. I tried in awr report but it shows only the sql query which has taken long time to execute. and i even tried in V$session and V$sqlarea.

can anyone please guide us how to view the executed sql statements in a particular session/current session

Report message to a moderator

Re: How to find out all the queries that are executed in particular range of time in oracle instance [message #522410 is a reply to message #522406]

Fri, 09 September 2011 05:03

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

There is no other way than what awr/ash can give you but put the session in trace mode.

Regards
Michel

Report message to a moderator

Re: How to find out all the queries that are executed in particular range of time in oracle instance [message #522429 is a reply to message #522410]

Fri, 09 September 2011 07:13

gopieee16
Messages: 26
Registered: May 2011
Location: Chennai

Junior Member

Thanks Michel i did what u suggested, but of no use

[Updated on: Fri, 09 September 2011 07:14]

Report message to a moderator

Re: How to find out all the queries that are executed in particular range of time in oracle instance [message #522432 is a reply to message #522429]

Fri, 09 September 2011 07:37

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

More precisely?

Regards
Michel

Report message to a moderator

Previous Topic:	Performance issue
Next Topic:	Don't Know how to start performance tuning.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 06:47:16 CDT 2024