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