RE: question about dbms_syste.set_sql_trace_in_session
- From: Pete Sharman <peter.sharman@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 4 Mar 2004 03:14:22 +1100
Untrue, untrue! IIRC, Apps has also been instrumented with the service, module
and action name stuff.
It's the usual thing. We can give you the tools to make life easier for
yourself. If you choose not to use them, more fool you! :)
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Niall Litchfield
Sent: Thursday, March 04, 2004 2:47 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: question about dbms_syste.set_sql_trace_in_session
> If the application sets MODULE and ACTION fields by using
> DBMS_APPLICATION_INFO package,
> one can trace all clients which execute that particular
> module automagically,
> by using the following:
>
> DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE(
> service_name IN VARCHAR2,
> module_name IN VARCHAR2,
> action_name IN VARCHAR2 DEFAULT ALL_ACTIONS);
There are literally thousands of such installations around the world as well,
most of them unfortunately seem to be called sqlplus :(
Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805
**********************************************************************
This email contains information intended for
the addressee only. It may be confidential
and may be the subject of legal and/or
professional privilege. Any dissemination,
distribution, copyright or use of this
communication without prior permission of
the sender is strictly prohibited.
**********************************************************************
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
