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

From: April Wells <AWells_at_csedge.com>
Date: Mon, 26 Apr 2004 08:01:26 -0500
Message-ID: <0C3690346404A94CBF4DDDD4724FC6141238300B@csmail.corpsys.csedge.com>

I would open an itar. There has to be a way. Oracle is always wanting the trace files for Financials... and those are all 10046 traces, some with waits, some with binds and waits.

If it can be done in Apps, it can be done ANYWHERE!

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

Received on Mon Apr 26 2004 - 07:57:57 CDT