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”

This entry was posted on Thursday, September 11th, 2008 at 5:10 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Tracing in oracle”

  1. Laura says:

    just wondering. in this example you enable trace for the service_name=’betterlogic.com’ and disable trace for ‘cmprod.colo.cmarket.com’. Then, you perform a trcsess of service=”betterlogic.com”

    Is that intentional? I would have diabled for service=”betterlogic.com”.

Leave a Reply