Re: 10g: Setting events for a all sessions of a given module
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: jwilton@xxxxxxxxxxxxx
- Date: Tue, 14 Sep 2004 09:10:25 +0100
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
