Elapsed time VS DB TIme
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Elapsed time VS DB TIme

  1. #1
    Join Date
    May 2008
    Posts
    29

    Elapsed time VS DB TIme

    Snap Id Snap Time Sessions Cursors/Session
    Begin Snap: 1663 21-Jul-08 10:00:28 80 10.9
    End Snap: 1686 21-Jul-08 16:08:01 172 11.5
    Elapsed: 367.55 (mins)
    DB Time: 4,879.90 (mins)

    I am looking at the "DB Time" of 4879.90 minutes; and comparing the value with my elapsed time - not sure if its ok to see a higher DB time than elapsed time.

    Thanks,
    Govind

  2. #2
    Join Date
    Jun 2007
    Location
    Milwaukee,WI
    Posts
    27
    Elapsed time is the duration of your snapshot. DB time means CPU time consumed during that elapsed time. So you should have definitely more then 4879.90/367.55 >= 14 cpu. Now check your cpu utilization , let's say if it's 50%, that means you got 14*(100/50)=28 cpu.

    Akash
    OCP 8i


  3. #3
    Join Date
    Nov 2001
    Posts
    335
    I am not so sure that snapshot differentiate between different cpu's . I never have seen db time higher than elapsed time. Could it be a bug ?
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  4. #4
    Join Date
    Jun 2007
    Location
    Milwaukee,WI
    Posts
    27
    No i do not think it's a bug, if you got a very busy system(cou intensive operations)with multpile cpus, you can see it.

    Akash
    OCP 8i


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