Is there a Microsoft SQL Profiler equivalent for Oracle

Question

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!

What version of Oracle are you using? – Craig McKeachie Aug 14 '09 at 02:27 — Craig McKeachie, Aug 14 '09 at 02:27

score 1 · Accepted Answer · edited May 23 '17 at 12:19

1

See this: Oracle: is there a tool to trace queries, like Profiler for sql server?

and this:

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

edited May 23 '17 at 12:19

Community

1
1

answered Aug 14 '09 at 06:18

Cătălin Pitiș

14,123
2
39
62

score 0 · Answer 2 · answered Aug 14 '09 at 02:41

0

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

answered Aug 14 '09 at 02:41

Mark Harrison

297,451
125
333
465

score 0 · Answer 3 · answered Aug 14 '09 at 08:39

0

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

answered Aug 14 '09 at 08:39

Ian Carpenter

8,346
6
50
82

score 0 · Answer 4 · answered Dec 30 '20 at 16:35

0

Some kind of profiler tool for Oracle

Hopefully this is what you are looking for

answered Dec 30 '20 at 16:35

XNH

36
5

Is there a Microsoft SQL Profiler equivalent for Oracle

4 Answers4