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

Other related posts: