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

Thread: Interpret Trace File

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433

    Interpret Trace File

    I collected some trace file which might contains errors detail .
    The trace file is generated from an oracle8.0.5 database and now
    I have only oracle7.3/Oracle8.1.X TKPROF .

    After running tkprof against those trace file . There are no errors reported but the output file is very small and no much information in it ( trace file itself contains quite a lot information , each around 200KB) I am wondering whether it's due to version incompatiable .

    In fact the main error shows in trace file is :
    *** 2002.10.23.09.20.38.190
    *** SESSION ID:(18.1395) 2002.10.23.09.20.34.104
    FATAL ERROR IN TWO-TASK SERVER: error = 12571
    *** 2002.10.23.09.20.38.250
    ksedmp: internal or fatal error
    Current SQL statement for this session:
    SELECT B_BISSUE,B_BITEM,B_BREVISION,B_BITEMD,B_BINOHQTY,B_BMOVEQTY,B_BREMARK FROM B_BISSD WHERE B_BISSUE=:K00000 AND (B_BITEM BETWEEN :L00001 AND :H00001) ORDER BY B_BISSUE,B_BITEM,B_BREVISION
    ----- Call Stack Trace -----

    how to found the details of this kind of error (12571)



    the output looks like :
    TKPROF: Release 8.1.6.0.0 - Production on Mon Oct 28 09:38:05 2002

    (c) Copyright 1999 Oracle Corporation. All rights reserved.

    Trace file: ORA00077.TRC
    Sort options: default

    ********************************************************************************
    count = number of times OCI procedure was executed
    cpu = cpu time in seconds executing
    elapsed = elapsed time in seconds executing
    disk = number of physical reads of buffers from disk
    query = number of buffers gotten for consistent read
    current = number of buffers gotten in current mode (usually for update)
    rows = number of rows processed by the fetch or execute call
    ********************************************************************************
    Trace file: ORA00077.TRC
    Trace file compatibility: 8.00.04
    Sort options: default

    2 sessions in tracefile.
    0 user SQL statements in trace file.
    0 internal SQL statements in trace file.
    0 SQL statements in trace file.
    0 unique SQL statements in trace file.
    5465 lines in trace file.
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    If I am not wrong TKPORF is used on SQL_TRACE files, not on trace files generated by errors.

    Sanjay

  3. #3
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    OIC
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  4. #4
    Join Date
    Feb 2001
    Posts
    125
    THEN HOW TO ANALYZE ORACLE ERROR TRACE FILE.
    BECAUSE I AM ALSO FACING SAME PROBLEM

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    sned them to oracle support

  6. #6
    Join Date
    Feb 2001
    Posts
    125
    sned them to oracle support
    we hv no oracle support.



    P.soni

  7. #7
    Join Date
    Jun 2001
    Posts
    20
    why not?

  8. #8
    Join Date
    Feb 2001
    Posts
    125
    i tried the link provided for oracle support in this forum, but ask some code which we don't know.
    bye-the-way i have gone thru oracle documentation it says that there is a utility DUMPFMT in oracle which format the oracle trace file.
    i searhed my server but couldn't found the utility. anyone hv any idea ??


    P.soni

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    i presume you went to metalink and tired that, but since you haveno support you dont have access to it (i.e it needs to be paid for)

    only thing you can is search forums, google and newsgroups for help

  10. #10
    Join Date
    Feb 2001
    Posts
    125
    any idea about DUMPFMT ?

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