Realtime SQL Trace like MS SQL Server

I'm looking for a possibility to show all SQL-Statements (testsystem)

in realtime. (Ora 9i R2 Enterprise).

In MSSQL Server 7.0 this tool called SQL Trace and in 2000 called profiler. I need 4 mouse click's and the program runs.

I found in oracle9i a performance manager. But there I found only the SQLs of top sessions.

I need the starttime, exec time and the sql statement in a view in realtime.

I hope, this is possible in ora9i without big effort.

Can anyone show me the way?

Thanks in advance

Regards Thomas Received on Sat Mar 19 2005 - 18:53:29 CET