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

  • Anjo Kolk at Nov 1, 2002 at 9:33 am
    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).

Related Discussions

Discussion Navigation
viewthread | post
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 © 2022 Grokbase