How can I monitor SQL activity on Oracle? [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

开发者_C百科

Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.

Closed 8 years ago.

Improve this question

I'd like to find a tool for Oracle that is similar to the SQL Server Profiler, but a cursory search hasn't yielded any good results. I just want to see, in real time, the queries that my application are making against the database.

Any suggestions?

---

The v$ views in Oracle (which a lot of tools use) offer a wealth of information if you have access to them.

Here's an example on askTom to find the sql the current users are executing.

---

AWR (automatic workload repository) is the most obvious answer. There's a description here.

But Oracle Enterprise Manager has better interface. Read about it here. You have to pay extra, but it gives you the interactivity you're looking for.

---

Quest software has some really good tools for Oracle. I think that both Foglight Performance Analysis for Oracle and Spotlight do what you're looking for. Not sure for Spotlight though.

---

PL/SQL Developer from Allround Automations is what we use here. More geared towards developers, it does have a session browser which will show locks, SQL statements, etc. Also a nice graphical explain plan window. It's cheaper than TOAD (at last look).