| Debug Queries [message #451463] |
Wed, 14 April 2010 14:53  |
srkvellanki
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  |
 |
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
|
Senior Member |
|
|
janets20 wrote on Wed, 14 April 2010 14:53Hi,
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
