Is there a Microsoft SQL Profiler equivalent for Oracle

Question

Hi,

99% of my time is in SQL Server land and so I'm not at all familiar with Oracle or its products...Is there a similar application to Microsoft SQL Profiler for use against Oracle databases? I'm helping debug/tune an ASP.Net application that connects to Oracle using ODAC etc

thanks heaps!

Answer 1

Explain Plan

For tuning individual statements you can use "explain plan". Try a copy of the free Sql Developer, it has a nice GUI interface for this.

http://www.oracle.com/technology/products/database/sql_developer/index.html

Answer 2

See this: http://stackoverflow.com/questions/148648/oracle-is-there-a-tool-to-trace-queries-like-profiler-for-sql-server

and this:

http://www.oradev.com/create%5Fstatistics.jsp

Answer 3

Along with the answers given so far, it is also worth mentioning the PL/SQL Profiler