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.


Outgrown your current e-mail service? Get 25MB Storage, POP3 Access,
Advanced Spam protection with LYCOS MAIL PLUS.
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 @
postedNov 1, '02 at 6:58a
activeNov 1, '02 at 9:33a

2 users in discussion

Anubha Jalsingh: 1 post Anjo Kolk: 1 post



site design / logo © 2021 Grokbase