From oracle-l-bounce@freelists.org Fri Nov 11 09:47:27 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jABFlQGv011177 for ; Fri, 11 Nov 2005 09:47:26 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id jABFlJvX011140 for ; Fri, 11 Nov 2005 09:47:24 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5DAF4225235; Fri, 11 Nov 2005 10:47:11 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09287-07; Fri, 11 Nov 2005 10:47:11 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D8447225284; Fri, 11 Nov 2005 10:47:10 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 11 Nov 2005 10:45:16 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 942FE225272 for ; Fri, 11 Nov 2005 10:45:16 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08901-09 for ; Fri, 11 Nov 2005 10:45:16 -0500 (EST) Received: from smtp-out3.tiscali.nl (smtp-out3.tiscali.nl [195.241.79.178]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5D123225023 for ; Fri, 11 Nov 2005 10:45:16 -0500 (EST) Received: from [82.170.239.143] (helo=LAPTOPLEX) by smtp-out3.tiscali.nl with esmtp (Tiscali http://www.tiscali.nl) id 1Eab5X-0000hy-86; Fri, 11 Nov 2005 16:45:15 +0100 From: "Lex de Haan" To: , Cc: Subject: RE: sql_trace deprecated on 10gr2 what to use instead? Date: Fri, 11 Nov 2005 16:45:13 +0100 Organization: Natural Join BV MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_000C_01C5E6DF.49621F70" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 thread-index: AcXmz+COWWs/dIJcQciDFjKbtZtAoQABr0tQ In-Reply-To: Message-Id: <20051111154516.5D123225023@turing.freelists.org> X-archive-position: 28274 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: lex.de.haan@naturaljoin.nl Precedence: normal Reply-To: lex.de.haan@naturaljoin.nl X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.9 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 ------=_NextPart_000_000C_01C5E6DF.49621F70 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Egor, you probably mean dbms_session.set_sql_trace -- but onfortunately, that procedure doesn't allow you to include/exclude bind and wait info in your trace files... kind regards, Lex. --------------------------------------------------------------------- Jonathan Lewis Seminar http://www.naturaljoin.nl/events/seminars.html --------------------------------------------------------------------- > DBMS_SESSION , few optoins > DBMS_SUPPORT, not documented > DBMS_MONITOR, the winner!! The only problem is that execute of DBMS_MONITOR is not granted by default to PUBLIC (contrary to DBMS_SESSION). So, for ordinary developer dbms_session.session_trace_enable is the winner. As for SQL_TRACE, I think that it's deprecated because you need to have 'alter session' privilege (which might be a bit dangerous) for using it. So it might be better to just revoke 'alter session', grant execute on dbms_session to public and document sql_trace as deprecated. :) ------=_NextPart_000_000C_01C5E6DF.49621F70 Content-Type: text/x-vcard; name="Lex de Haan.vcf" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="Lex de Haan.vcf" BEGIN:VCARD VERSION:2.1 N:de Haan;Lex FN:Lex de Haan ORG:Natural Join B.V. TEL;WORK;VOICE:+31.30.2515022 TEL;HOME;VOICE:+31.30.2518795 TEL;CELL;VOICE:+31.62.2955714 TEL;WORK;FAX:+31.30.2523366 ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands LABEL;WORK;ENCODING=3DQUOTED-PRINTABLE:Pieter Breughelstraat = 10=3D0D=3D0AUtrecht 3583 SK=3D0D=3D0ANetherlands URL;WORK:http://www.naturaljoin.nl EMAIL;PREF;INTERNET:lex.de.haan@naturaljoin.nl REV:20040224T160439Z END:VCARD ------=_NextPart_000_000C_01C5E6DF.49621F70-- -- http://www.freelists.org/webpage/oracle-l