FAQ
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).

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 2 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedNov 1, '02 at 6:58a
activeNov 1, '02 at 9:33a
posts2
users2
websiteoracle.com

2 users in discussion

Anubha Jalsingh: 1 post Anjo Kolk: 1 post

People

Translate

site design / logo © 2021 Grokbase