DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Can I consolidate many trc file into one to analyze it ?

  1. #1
    Join Date
    May 2002
    Posts
    34
    Hi: I use weblogic connection pool to start 30 connection to Oracle , After use dbms_system.set_sql_trace_in_session , I got 30 trc file , Can I consolidate these file in one to analyze ? Thanks!!

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    no?

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Yes you can. Simply concatenate them into one big trace file and run tkprof on it.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you cant get the expalin if they were different user though?

  5. #5
    Join Date
    May 2002
    Posts
    34

    the username is same

    Hi: the user name is same ,connect to oracle user weblogic

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by pando
    you cant get the expalin if they were different user though?
    I can't see why not. Each trace information has user information built in, so there could be no problem about that.

    Even in a single session you can use "ALTER SESSION SET CURRENT_SCHEMA ...." to switch between different schema environments, yet you have no problems in obtaining explain plans from such a trace file. It's the same with concatenated trace files from different sessions.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    nono what I mean is when we tkprof using explain=username/password this normally has to be the user who ran the query (unless there are synonyms and sys can see them)

  8. #8
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by pando
    nono what I mean is when we tkprof using explain=username/password this normally has to be the user who ran the query (unless there are synonyms and sys can see them)
    Well, normaly you don't need to use explain=username/password when using tkprof at all. In trace file all objects are referenced by their object id, not by their names and synonyms. So there is no need to use explain=username/password, the execution paths are allready stored in the trace file. You should use explain=username/password only when you want to see actualy index names instead of their object_ids if neccessary. But if you do use explain=username/password then the explain plan in the output file might in fact be different that the one actualy performed when the trace vas collected!

    See http://asktom.oracle.com/pls/ask/f?p...0_P8_DISPLAYID,F4950_P8_CRITERIA:1264600478591
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    yes I know that you can get different execution plan since tkprof is performaed later and the plan can change, just that the explain plan with tkprof looks more clear rather than the trace file

  10. #10
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by pando
    yes I know that you can get different execution plan since tkprof is performaed later and the plan can change, just that the explain plan with tkprof looks more clear rather than the trace file
    In fact, there is very little one can understand from the trace file. Usually, TKPROF is a must.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width