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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
