Home » RDBMS Server » Enterprise Manager » Debug Queries
Debug Queries [message #451463] Wed, 14 April 2010 14:53 Go to next message
janets20
Messages: 1
Registered: April 2010
Junior Member
Hi,

I worked on SQL Server used a GUI,SQL Server Profiler, to debug queries. In ORACLE how to debug queries.Is there any GUI utility for debugging?.Can i see all the queries run by a specific user?.


Regards
Janet
Re: Debug Queries [message #451491 is a reply to message #451463] Thu, 15 April 2010 02:15 Go to previous message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
janets20 wrote on Wed, 14 April 2010 14:53
Hi,

I worked on SQL Server used a GUI,SQL Server Profiler, to debug queries. In ORACLE how to debug queries.Is there any GUI utility for debugging?.Can i see all the queries run by a specific user?.

Regards
Janet


SQL Server Profile is state of Art DB Profile ( which makes developer LAZY ) and same facility is not available in Oracle.

In oracle we have following tools/ways to debug queries..

1/ Explain Plan
2/ Tkprof utility
3/ OEM ( this gives All ( Most of ) info about DB.)

Quote:


Can i see all the queries run by a specific user?.


Yes , Check for Session.

[Updated on: Thu, 15 April 2010 03:12]

Report message to a moderator

Previous Topic: Installing new agent on RAC servers - experience?
Next Topic: OEM not starting
Goto Forum:
  


Current Time: Fri Aug 29 07:15:21 CDT 2014

Total time taken to generate the page: 0.21239 seconds