On Mon, 13 Sep 2004 12:23:41 -0700 (PDT), Jeremiah Wilton 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=] [session=]
[clientid=] [service=] [action=] [module=]
output= output destination default being standard output.
session= session to be traced.
Session id is a combination of session Index & session serial number e.g. 8.13.
clientid= clientid to be traced.
service= service to be traced.
action= action to be traced.
module= module to be traced.
Space separated list of trace files with wild card
'*' supported.
HTH
