I got the module/service_name from v$session, it is even not working for sqlplus module, I tried starting the trace from OEM(which internally used dbms_monitor) and it also showing trace enabled but no trace files generated -----Original Message----- From: Alex Gorbachev [mailto:gorbyx@xxxxxxxxx] Sent: Fri 10/13/2006 8:37 PM To: Harvinder Singh Cc: oracle-l Subject: Re: dbms_monitor not generating trace files I guess you want to make sure your set correct module/service_name. Try to simulate it from another session - set it so that module_name and service_name are as defined in dbms_monitor call. See if it produces the trace. On 10/13/06, oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> wrote: > Hi, > > I need to enable the trace on particular module of the application and > using the following command but don't see any trace files generated: > EXEC DBMS_MONITOR.serv_mod_act_trace_enable(service_name=>'test', > module_name=>'test.exe',waits=>TRUE, binds=>FALSE); > (service_name,module_name values are in v$session) > > If I use Alter system or alter session then it works fine but I need to > use for particular module. I don't get any error when ran the above > command, do I need to set up something more to get trace files? > > Thanks > --Harvinder > > > -- > //www.freelists.org/webpage/oracle-l > > > -- Best regards, Alex Gorbachev The Pythian Group Sr. Oracle DBA http://www.pythian.com/blogs/author/alex/ http://blog.oracloid.com -- //www.freelists.org/webpage/oracle-l