Use either DB Monitor Expert or DB Application Expert. Both of them do that. In DB Monitor go to Tools/Connections, pick a session by id, user or os user and switch to the SQL page. In DB Application there are many ways how to drill-down to the SQL. It can also group it by application name. : I am evaluating the DBTools product and trying to get
: it to capture and display the sql commands going to
: another Oracle 9i server from an application. In effect
: I am trying to mimic what is possible with SQLServers
: Profiler. I can trace commands sent from the DBA Notepad,
: but not view any other session sql. Any ideas?
: Many thanks in advance : Alex Macovich
|
