RE: dbms_monitor not generating trace files

  • From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
  • To: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
  • Date: Sat, 14 Oct 2006 09:24:46 -0400

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
> --

Best regards,
Alex Gorbachev

The Pythian Group
Sr. Oracle DBA


Other related posts: