1 Reply Latest reply: Nov 20, 2012 4:17 AM by Aman.... RSS

    tkprof - how to read this o/p file

      Hi Experts

      I have a o/p file send by a customer using tkprof but no source file

      what can we interpret from this o/p file

      TKPROF: Release - Development on Wed Oct 11 16:31:02 2012

      Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

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

      0 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.
      656399 lines in trace file.
      0 elapsed seconds in trace file.