cputime & elapsedtime where to see first when there is huge difference
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: cputime & elapsedtime where to see first when there is huge difference

  1. #1
    Join Date
    Apr 2003
    Posts
    353

    cputime & elapsedtime where to see first when there is huge difference

    1.What are the main places to look when
    there is a huge difference between
    elapsed_time and cpu_time of v$sql. (elapsed_time>cpu_time).

    2. Some cases we found cpu_time is greater than elapsed_time..What could be the reason for this.(elapsed_time

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    1. Disk I/O usually makes the difference.

    2. Multi-CPUs: 4 CPUS can give you 4 seconds CPU per second elapsed.

  3. #3
    Join Date
    Apr 2003
    Posts
    353
    Originally posted by DaPi
    1. Disk I/O usually makes the difference.

    2. Multi-CPUs: 4 CPUS can give you 4 seconds CPU per second elapsed.
    Part 2 is exact .. 4 cpus are there.

    But point 1 ..I am still searching the exact reasons.
    ..

  4. #4
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Wait time due to I/O that is not part of CPU.
    -nagarjuna

  5. #5
    Join Date
    Apr 2003
    Posts
    353
    The query is not much i/o intensive..

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    wat about LIO?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  7. #7
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    alter session set events '10046 trace name context forever, level 12'


    and check the tkprof output of the tracefile. You will see the events for which the session is/was waiting.
    -nagarjuna

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