RE: Trace

From: Anjo Kolk <anjo_at_oraperf.com>
Date: Fri, 01 Nov 2002 01:33:41 -0800
Message-ID: <F001.004F9830.20021101013341@fatcity.com>

No you won't get valid output. You need to cut and paste so that each session has a file for all its statements.

Anjo.

-----Original Message-----
Jalsingh
Sent: Friday, November 01, 2002 7:59 AM
To: Multiple recipients of list ORACLE-L

Hi

We are running Baan erp application. Baan opens multilple (upto 4-5) oracle sessions for a single user session. These Oracle sessions have same unix process id but different SID and SERIAL#. In order to diagnose an application performance problem, I set 10046 trace in all sessions of a user. This generated a single trace file as all these session had same process id.
This trace file seems to have all the SQL statements submitted by user. Now if I run tkprof on the trace file , would I get a valid Output ? The trace file contains CURSOR #, which doesn't look unique across the sessions.

Thanks
Manmohan

---

Outgrown your current e-mail service? Get 25MB Storage, POP3 Access, Advanced Spam protection with LYCOS MAIL PLUS. http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus
--

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

Author: Anubha Jalsingh
  INET: ajalsingh_at_lycos.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

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

Author: Anjo Kolk
  INET: anjo_at_oraperf.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Nov 01 2002 - 03:33:41 CST