Rick’s Blog

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”

Oracle forms compile failed with “Out of file descriptors”. Fix: projmod -s -K “process.max-file-descriptor=(basic,10000,deny)” oracle Reference: IBM Resource Limit Configuration