CPU time reported on AWR
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: CPU time reported on AWR

  1. #1
    Join Date
    May 2007
    Posts
    2

    CPU time reported on AWR

    When I looked at the session of SQL stats in AWR report (Oracle 10g Release 2 Patch 1), the top SQL by Physical Reads lists the queries with large # of physical reads. I saw all the CPU time is only a small portion of elapsed time. I checked the waiting events and didnít see these queries show up with long wait time. It leads me to believe that the Physical Read time is not part of the CPU time. When the logical reads occurs, it will take the CPU cycle which contribute to the total CPU time for the query. I could not find a proper document to discuss the detail of CPU time calculation. Any thought or related document will help me to understand the concept.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    physical i/o is not cpu - it is i/o

  3. #3
    Join Date
    May 2007
    Posts
    2
    Logical IO is CPU. Right?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    correct, logical io comes from memory

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