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

From: biti_rainy <biti_rainy_at_itpub.net>
Date: Mon, 26 Apr 2004 20:57:55 +0800
Message-Id: <20040426124441.AD38072CC75@turing.freelists.org>

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

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

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

Received on Mon Apr 26 2004 - 07:54:03 CDT