From oracle-l-bounce@freelists.org Wed Mar 3 10:14:06 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i23GE6m14133 for ; Wed, 3 Mar 2004 10:14:06 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i23GE6o14127 for ; Wed, 3 Mar 2004 10:14:06 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5351539496E; Wed, 3 Mar 2004 11:13:29 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2004 11:12:07 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from agminet01.oracle.com (agminet01.oracle.com [141.146.126.228]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 558A63950DD for ; Wed, 3 Mar 2004 11:12:04 -0500 (EST) Received: from rgmgw5.us.oracle.com (rgmgw5.us.oracle.com [138.1.191.14]) by agminet01.oracle.com (Switch-3.1.2/Switch-3.1.0) with ESMTP id i23GE65m026028 for ; Wed, 3 Mar 2004 08:14:27 -0800 Received: from rgmgw5.us.oracle.com (localhost [127.0.0.1]) by rgmgw5.us.oracle.com (Switch-2.1.5/Switch-2.1.0) with ESMTP id i23GE4Y20438; Wed, 3 Mar 2004 09:14:04 -0700 (MST) Received: from PETE (dhcp-amer-vpn-gw2-east-141-144-67-123.vpn.oracle.com [141.144.67.123]) by rgmgw5.us.oracle.com (Switch-2.1.5/Switch-2.1.0) with ESMTP id i23GDpY20030; Wed, 3 Mar 2004 09:13:52 -0700 (MST) Message-Id: <200403031613.i23GDpY20030@rgmgw5.us.oracle.com> From: Pete Sharman To: oracle-l@freelists.org Cc: "Peter Ross. Sharman" Subject: RE: question about dbms_syste.set_sql_trace_in_session Date: Thu, 4 Mar 2004 03:14:22 +1100 X-Sent-Folder-Path: Sent Items X-Mailer: Oracle Connector for Outlook 9.0.4 51121 (10.0.2627) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis X-archive-position: 176 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: peter.sharman@oracle.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Niall Litchfield Sent: Thursday, March 04, 2004 2:47 AM To: oracle-l@freelists.org 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@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 ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------