From oracle-l-bounce@freelists.org Mon Apr 26 23:53:53 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3R4rc825739 for ; Mon, 26 Apr 2004 23:53:48 -0500 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 i3R4rR625725 for ; Mon, 26 Apr 2004 23:53:37 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BFB5472D012; Mon, 26 Apr 2004 23:44:58 -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 17624-52; Mon, 26 Apr 2004 23:44:58 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C27BD72CF9E; Mon, 26 Apr 2004 23:44:39 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 26 Apr 2004 23:43:22 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8B30172CC13 for ; Mon, 26 Apr 2004 23:43:21 -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 16397-67 for ; Mon, 26 Apr 2004 23:43:21 -0500 (EST) Received: from relay2.iflexsolutions.com (unknown [202.144.91.162]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4608472CD55 for ; Mon, 26 Apr 2004 23:43:15 -0500 (EST) Received: from fmgrt.rt.i-flex.com (pppserver [192.168.50.2]) by relay2.iflexsolutions.com (8.12.3/8.12.3) with ESMTP id i3RANj47019785 for ; Tue, 27 Apr 2004 10:23:45 GMT Received: from fmgrt.rt.i-flex.com ([192.168.50.2]) by fmgrt.rt.i-flex.com with Microsoft SMTPSVC(5.0.2195.6713); Tue, 27 Apr 2004 10:29:20 +0530 X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain Subject: RE: RE: Unable to do a 10046 trace on another users session Date: Tue, 27 Apr 2004 10:29:20 +0530 Message-ID: <10898BE7CA96D611988B000802255AAF03427DE3@FMGRT.rt.i-flex.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: <10898BE7CA96D611988B000802255AAF03427DE3@FMGRT.rt.i-flex.com> Thread-Topic: RE: Unable to do a 10046 trace on another users session Thread-Index: AcQrjx7vUyVL4IQhQMWlaVbTtsh8wAAg9VWZ From: To: X-OriginalArrivalTime: 27 Apr 2004 04:59:20.0567 (UTC) FILETIME=[669BC870:01C42C14] X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 3822 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: k.sriramkumar@iflexsolutions.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi, My understanding is also the same .When we invoke multiple forms, multiple sessions are created. The forms sessions thus invoked , share same server processid (analogous to shared server model sans dispatchers?) . Each form session would have a separate entry in v$session with the same Paddr. Since there are multiple sessions, each of them would have a diffrent sid,serial# which explains the problem . Best Regards Sriram Kumar -----Original Message----- From: biti_rainy [mailto:biti_rainy@itpub.net] Sent: Monday, April 26, 2004 7:58 AM To: oracle-l@freelists.org Subject: Re: RE: Unable to do a 10046 trace on another users session hi I had saw some information from metalink but i can not find= the URL now. oracle forms can spawns many session for a single process .= as you say : > called session doesn't inherit the caller's 10046 trace level= attribute Best regards yahoo id: feng_chunpei A new dba from china ---- from the mail----- >One thing to consider is that some Oracle Forms applications do= a lot of >session spawning. If you don't trace all of the Oracle sessions= that are >involved in your user action, you're not going to see the work= done in >all of those sessions. > >Unfortunately, when one Oracle session spawns another, the= called >session doesn't inherit the caller's 10046 trace level= attribute. The >"trick" is to identify all the Oracle sessions that participate= in your >user action. > > >Cary Millsap >Hotsos Enterprises, Ltd. >http://www.hotsos.com >* Nullius in verba * > >Upcoming events: >- Performance Diagnosis 101: 5/7 Dallas, 5/18 New Jersey, 6/22 >Pittsburgh >- SQL Optimization 101: 4/19 Denver, 5/3 Boston, 5/24 San Diego >- Hotsos Symposium 2005: March 6-10 Dallas >- Visit www.hotsos.com for schedule details... > > >-----Original Message----- >From: oracle-l-bounce@freelists.org >[mailto:oracle-l-bounce@freelists.org] On Behalf Of Arghadeep= Chatterjee >Sent: Monday, April 26, 2004 5:18 AM >To: oracle-l@freelists.org >Subject: Unable to do a 10046 trace on another users session > >Hi All, >I am trying to trace another users session (10046 trace) by= using >DBMS_SYSTEM as mentioned in Cary's book my problem is though= everything >runs out fine the resulting trace file only shows the last line= of my >current SQL and doesnt report any SQL of the application I am= trying to >trace.I am enabling the trace form SQLPLUS while the application= is >Oracle Forms 6i.Any ideas the steps I have followed is exact= replica of >one shown in hotsos.Thanks >Regards >Arghadeep Chatterjee >DBA "KSPL" >----------------------------------------------------------------= >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 >----------------------------------------------------------------= - > >. =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1 ---------------------------------------------------------------- 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 ----------------------------------------------------------------- The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. ---------------------------------------------------------------- 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 ----------------------------------------------------------------- -- Binary/unsupported file stripped by Ecartis -- -- Type: application/ms-tnef -- File: winmail.dat ---------------------------------------------------------------- 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 -----------------------------------------------------------------