RE: RE: Unable to do a 10046 trace on another users session

From: <k.sriramkumar_at_iflexsolutions.com>
Date: Tue, 27 Apr 2004 10:29:20 +0530
Message-ID: <10898BE7CA96D611988B000802255AAF03427DE3@FMGRT.rt.i-flex.com>

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_at_itpub.net] Sent: Monday, April 26, 2004 7:58 AM
To: oracle-l_at_freelists.org
Subject: Re: RE: Unable to do a 10046 trace on another users session

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_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Arghadeep=
Chatterjee
>Sent: Monday, April 26, 2004 5:18 AM
>To: oracle-l_at_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_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
>----------------------------------------------------------------=
-
>
>----------------------------------------------------------------=

>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------=

=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_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
-----------------------------------------------------------------


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_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
-----------------------------------------------------------------

-- 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_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 Mon Apr 26 2004 - 23:53:53 CDT