Re: 10g: Setting events for a all sessions of a given module

On Mon, 13 Sep 2004 12:23:41 -0700 (PDT), Jeremiah Wilton <jwilton_at_speakeasy.net> wrote:
> I think someone posted recently about the ability in 10g to set events
> over the scope of all sessions of a given module. Can anyone point me
> at the package that does that?

DBMS_MONITOR. specifically it sounds like you are looking for

DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE catchy name huh?

The utility for - to use a technical term - munging the relevant trace together is trcsess

C:\WINDOWS>trcsess
oracle.ss.tools.trcsess.SessTrcException: SessTrc-00002: Session Trace Usage error: Wrong parameters passed.
trcsess [output=<output file name >] [session=<session ID>] [clientid=<clientid>] [service=<service name>] [action=<a ion name>] [module=<module name>] <trace file names>

output=<output file name> output destination default being standard output. session=<session Id> session to be traced. Session id is a combination of session Index & session serial number e.g. 8.13. clientid=<clientid> clientid to be traced. service=<service name> service to be traced. action=<action name> action to be traced. module=<module name> module to be traced. <trace_file_names> Space separated list of trace files with wild card '*' supported.

HTH

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l