Re: dbms_monitor not generating trace files

  • From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
  • To: Harvinder.Singh@xxxxxxxxxxxxx
  • Date: Fri, 13 Oct 2006 20:37:13 -0400

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


Other related posts: