Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1JCt0919343 for ; Thu, 19 Feb 2004 06:55:00 -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 i1JCswo19334 for ; Thu, 19 Feb 2004 06:54:59 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2F132394DB1; Thu, 19 Feb 2004 07:57:21 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 19 Feb 2004 07:56:07 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from aphrodite.espn.com (aphrodite.espn.com [204.149.192.11]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 824413949DB for ; Thu, 19 Feb 2004 07:56:04 -0500 (EST) Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 Subject: RE: Trace on Oracle 9.2.0.1.0 on Windows don't works Date: Thu, 19 Feb 2004 07:57:54 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Trace on Oracle 9.2.0.1.0 on Windows don't works Thread-Index: AcP259LKXEfK4HlDS++u5Q6j3flLZwAABQ0w From: "Jamadagni, Rajendra" To: X-OriginalArrivalTime: 19 Feb 2004 12:57:52.0249 (UTC) FILETIME=[FC03C690:01C3F6E7] X-archive-position: 1221 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Rajendra.Jamadagni@espn.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l log in as sysdba and then do a=20 show parameter sql What do you see? Raj -------------------------------------------------------------------------= ------- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. select standard_disclaimer from company_requirements; QOTD: Any clod can have facts, having an opinion is an art ! -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of dbm@ekenberg.org Sent: Thursday, February 19, 2004 7:55 AM To: oracle-l@freelists.org Subject: RE: Trace on Oracle 9.2.0.1.0 on Windows don't works Hi, Yes I want to trace all the database. (only for 15min and it is a test database). The problem is that no trace file are created even pmon trace files. Best Regards Henrik E. > As well as the possible typo, do you really want to trace *all* = activity > on=3D > the db, including pmon etc? A more usual implementation might be a = log on > =3D > trigger or use of one of the built in packages that enable you to = trace > som=3D > e particular session of interest.=3D20 > > Niall Litchfield > Oracle DBA > Audit Commission > +44 117 975 7805=3D20 > >> -----Original Message----- >> From: dbm@ekenberg.org=3D20 >> Sent: 19 February 2004 11:47 >> To: dbm@ekenberg.org; oracle-l@freelists.org >> Subject: Trace on Oracle 9.2.0.1.0 on Windows don't works >>=3D20 >>=3D20 >> Hello, >>=3D20 >> I need to trace one Oracle 9.2.0.1.0 database on WinXP. >> I insert slq_trace =3D3D TRUE in the init.ora file, then I restart = the >> database. >> I run my query but nothing happends. >> What do I miss ? Is there any know bug on this version ? >>=3D20 >> Best Regards >> Henrik >> -------------------------------------------------------------- >> ------------- >> Henrik Ekenberg / Sweden >>=3D20 >> ---------------------------------------------------------------- >> 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 >> ----------------------------------------------------------------- >>=3D20 >>=3D20 > > > > ********************************************************************** > 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------