Is there an equivalent Microsoft SQL Profiler for Oracle

Question

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

thanks heaps!

Answer 1

See: Oracle: is there a query tracking tool like Profiler for SQL Server?

and this:

http://www.oradev.com/create_statistics.jsp

Answer 2

Explain the plan

You can use an “explanation plan” to customize individual statements. 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 3

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