RE: question about dbms_syste.set_sql_trace_in_session
- From: "Niall Litchfield" <n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 03 Mar 2004 15:47:23 +0000
> 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
-----------------------------------------------------------------
Other related posts:
