RE: question about dbms_syste.set_sql_trace_in_session

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 03 Mar 2004 15:47:23 +0000
Message-Id: <s045fe19.060@bristol21.bristol.ac>

> 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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Mar 03 2004 - 09:47:56 CST