Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: dbms_monitor not generating trace files

Re: dbms_monitor not generating trace files

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Fri, 13 Oct 2006 20:37:13 -0400
Message-ID: <c2213f680610131737t2069b013h220f61689ea01e5@mail.gmail.com>


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_at_freelists.org <oracle-l-bounce_at_freelists.org> 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
>
>
> --
> http://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
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 13 2006 - 19:37:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US