Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2012
    Posts
    1

    Unanswered: Execution Time in Tkprof vs, A-time in Plan statistics

    This query is valid for both Oracle 10g and 11g.
    What is the relationship between A-time we see in execution Plan statistics of last cursor with option 'ALLSTATS' and the diffrent timings we see in Tkprof. Is it CPU time, fetch time or together??

  2. #2
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    Provided the information you are showing, you don't even understand the question, do you ?
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >This query is valid for both Oracle 10g and 11g.
    what query?

    >What is the relationship between A-time we see in execution Plan statistics of last cursor with option 'ALLSTATS' and the diffrent timings we see in Tkprof.
    I don't see anything.

    >Is it CPU time, fetch time or together??
    I don't know above means or to what it refers.

    Below is a free clue.
    We only know what you post & in this case it is only a collection of words without any real world context.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Tags for this Thread

Posting Permissions

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