OraFAQ Forum: Performance Tuning » Required tool for SQL Query

Home » RDBMS Server » Performance Tuning » Required tool for SQL Query (ORACLE 10g 10.2.0.1.0)

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

Required tool for SQL Query [message #480908]

Thu, 28 October 2010 02:07

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Hi All,

Can anyone name some database tool from which I can check the SQL Queries which my application is running.

NOTE: I donot want to chech the queries which I am executing at the SQL command prompt but queries that are being run by my application at the backend.

Quick help will be really appreciated.

Thanks & Regards
Deepak

Report message to a moderator

Re: Required tool for SQL Query [message #480931 is a reply to message #480908]

Thu, 28 October 2010 03:53

cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester

Senior Member

The correct way to do that would be to use sql trace

Report message to a moderator

Re: Required tool for SQL Query [message #480942 is a reply to message #480931]

Thu, 28 October 2010 06:58

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Thanks for the reply Sir, but will it return the sql queries that my application is running on the database from the front end?

Regards
Deepak

Report message to a moderator

Re: Required tool for SQL Query [message #480943 is a reply to message #480942]

Thu, 28 October 2010 07:01

cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester

Senior Member

That's the main reason why it exists.

Report message to a moderator

Re: Required tool for SQL Query [message #480944 is a reply to message #480943]

Thu, 28 October 2010 07:05

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Thanks for the Reply.Help Appreciated.

Regards
Deepak

Report message to a moderator

Previous Topic:	Oracle 11g r2 result_cache is Not working
Next Topic:	union in one go

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 06:54:25 CST 2024