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

Thread: how to convert \udmp\ .TRC files into readable

  1. #1
    Join Date
    Nov 2000
    Posts
    33
    How can i convert \udump\*.trc files into readable format

    this will help me to debug the user dump and background dump processes.

    Thanks in advance


    from Anuj Pathak
    india

  2. #2
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    use the TKPROF utility, see the docs for syntax, examples & more info.

    []s
    Chiappa

  3. #3
    Join Date
    Nov 2000
    Posts
    33
    Thanks JChiappa

    When ever i run tkprof like

    tkprof inputfile.trc output.txt

    It always gives same output in output.txt as below copied though trc files are different in size from 10 kb to 5 mb

    Waiting for yr reply

    from Anuj

    TKPROF: Release 8.1.5.0.0 - Production on Fri Feb 23 17:55:24 2001

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

    Trace file: orclsmon.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: orclsmon.trc
    Trace file compatibility: 7.00.12
    Sort options: default

    3 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.
    94147 lines in trace file.



  4. #4
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    In order to convert *.trc files in readable format ,please run the tkprof utility.It takes two arguments one name of the trace file and other ur output file name.

    for e.g if ur trace file name is ora0001.trc run the following command
    C:\tkprof ora0001.trc a.txt
    this will create readable trace file.U can go through it to find the necessary information.

    If any queries please write to me at rohitsn@hotmail.com

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    hi there

    you gotta alter your initsid.ora parameter max_dump_file_size to a larger value as the current settings are to small hence oracle is not able to dump the entire trace file.hope it helps

    hrishy

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