Hi there,
Is there any way to trace SQL statements as well as responses between Bentley Map and Oracle?
I noticed there's a log file that you can enable but it doesn't log SQL statements...
Does anyone knows if TOAD allows you to trace an application (Bentley Map) session?
Thank you,
Fernando
Hi. One way is to enable logging on the Oracle server. You can use a trigger such as this to only log when a specific Oracle user is logged:
grant ALTER SESSION to system;
CREATE OR REPLACE TRIGGER BENTLEY_ORA_CON_TRACE
After logon on database
Begin
if ( user='FERNANDO') then
execute immediate 'alter session set sql_trace=true';
execute immediate 'alter session set events ''10046 trace name context forever, level 12''';
End if;
END;
/
Obviously you must replace 'FERNANDO' with the actual account used Don't forget to drop the trigger once you're done so you don't slow down all requests.
Martin