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

Thread: Output of trace file

  1. #1
    Join Date
    Feb 2001
    Posts
    125

    Output of trace file

    Hi all
    I am attching a trace file
    plese help me what is indicating.


    I have run TKPROF but unable to get any thing

    copy of TKPROF output

    TKPROF: Release 8.1.7.0.0 - Production on Thu Jun 19 09:20:57 2003

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

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

    1 session 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.
    1605 lines in trace file.


    Thanks in adv.

    P.Soni

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    What type of trace file you are looking into? Is it the file generated by turning trace ON. Or is it an error trace file ? Can you post the trace file itself (as attachment) if it is not too big?
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    I don't think your timed_statistics are on...

    Anyways check this thread for tkprof related usage...

    http://www.dbasupport.com/forums/sho...ghlight=TKPROF
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  4. #4
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Having done that put that trace formatted file in the attachement. Then we'll see...
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  5. #5
    Join Date
    Feb 2001
    Posts
    125
    i am attaching file
    Attached Files Attached Files

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