Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Number of CPUs and Cores in AWR Report

JimboJul 23 2015 — edited Aug 25 2015

Hi,

I have an AWR Report of my system and a couple of entries confuse me -

Q1. It is showing 4 CPUs, 2 Sockets and 3 Cores. The CPU's and Sockets I can understand i.e. 2 chips with 2 processors per chip hence 4 CPU.

What confuses me is the fact that it shows 3 cores. Is this cores per CPU ? Othererwise 3 into 4 does not make sense ?

Q2. What is the difference between DB Time, CPU Time and DB CPU ?

My understanding is DB Time is the time used by processes including CPU Time and Wait Time. Because a system can have multiple processors, it is natural enough that DB Time may be greater than Elapse Time - since you will have multiple processors contributing to that time ( I guess DB Time cannot really be greater than Elapse Time * Nos of processors ? )

In fact you could argue if DB Time is not greater than elapse time, then you have a farly idle system ?

My understanding of CPU time is that it is the time that each process actually gets CPU processing ( therefore it does not include Wait time ). I believe that the AWR Report confusingly uses the term CPU Time and DB CPU to mean the same thing ?

any clarity greatly appreciated

Jim


This post has been answered by Pini Dibask on Aug 25 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2015
Added on Jul 23 2015
4 comments
5,146 views