Time Unit in Sec or Mili Sec?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Time Unit in Sec or Mili Sec?

  1. #1
    Join Date
    May 2008
    Posts
    29

    Time Unit in Sec or Mili Sec?

    I am very confused with the time, are thay in Seconds or Mili seconds

    for example:

    Elapsed times include waiting on following events:
    Event waited on Times Max. Wait Total Waited
    ---------------------------------------- Waited ---------- ------------
    SQL*Net message to client 172176 0.00 0.07
    SQL*Net message from client 172181 277.29 439.32


    Max Wait : 277.29 and total Waited: 439.32 ------------ is it in Seconds?



    And also in V$SQL, the elapsed time or CPU_TIME are they in Seconds.

    Regards

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    depends on version, view and column name

    it can be microseconds, milliseconds, centiseconds or seconds

    look on tahiti.oracle.com

  3. #3
    Join Date
    May 2008
    Posts
    29
    Sure, I will ... by the time here is the detail

    the DB version is 10.2.0.2

    call count cpu elapsed disk query current rows
    ------- ------ -------- ---------- ---------- ---------- ---------- ----------
    Parse 1 0.00 0.00 0 0 0 0
    Execute 1 0.00 4.88 0 6 0 0
    Fetch 0 0.00 0.00 0 0 0 0
    ------- ------ -------- ---------- ---------- ---------- ---------- ----------
    total 2 0.00 4.88

    Does the above 4:88 signify 4 minutes and 88 seconds? Thats how at least I am reading. Want to get confirmed from you.

    Regards

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447

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