Tracing in oracle
EXECUTE DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE(service_name => ‘betterlogic.com’, waits => TRUE, binds => TRUE, instance_name => ‘bpel1′); select * from dba_enabled_traces; EXECUTE DBMS_MONITOR.SERV_MOD_ACT_TRACE_DISABLE(service_name => ‘cmprod.colo.cmarket.com’, instance_name => ‘bpel1′); oracle@rac34 udump]$ trcsess output=”dump.file” service=”betterlogic.com” module=”JDBC Thin Client”
