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

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?

Answer 1

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.

Answer 2

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.