Trace

From: Anubha Jalsingh <ajalsingh_at_lycos.com>
Date: Thu, 31 Oct 2002 22:58:31 -0800
Message-ID: <F001.004F9706.20021031225831@fatcity.com>

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). Received on Fri Nov 01 2002 - 00:58:31 CST