Results 1 to 3 of 3

Thread: V$sqlarea

  1. #1
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467

    Unanswered: V$sqlarea

    Setup: 9i

    Is the unit for the elapsed_time column in V$SQLAREA is microseconds? It does not say specifically in the "Performance Tuning" book (that I could see).
    NOTE: Please disregard the label "Senior Member".

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Is the unit for the elapsed_time column in V$SQLAREA is microseconds?
    Yes, according to the Reference manual.
    http://download-west.oracle.com/docs...htm#sthref3490

    ELAPSED_TIME NUMBER Elapsed time (in microseconds) used by this cursor for parsing/executing/fetching
    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.

  3. #3
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    Who would think of putting that kind of information in the reference manual? What where they thinking????

    AtO - I hope I do not cause you to run out of adjectives for your tag line.
    NOTE: Please disregard the label "Senior Member".

Posting Permissions

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