***********************************************************************************
* Description: Knowledge of CPU/CORE count information on Linux and Windows system
* Compatiablity: RDBMS 11g, 12c
* Date: 11:36 PM EST, 03/29/2017
***********************************************************************************


<1> CPU/CORE Analogy:
     |
     |__ If one CPU is an engine, then CORE would be a piston. The engine may have multiple pistons, same as dual/quad-COREs within one CPU chip.
	 

	 
<2> Linux - CPU Detail:
     |
     |__ $ grep 'model name' /proc/cpuinfo | wc -l ............... How many cores on this physical machine.
     |
     |__ $ cat /proc/cpuinfo ....................................... Example indicates 2 CPU with 1 CORE for each.

             processor       : 0
             vendor_id       : GenuineIntel
             cpu family      : 6
             model           : 45
             model name      : Intel(R) Xeon(R) CPU E5-2403 0 @ 1.80GHz
             stepping        : 7
             microcode       : 1808
             cpu MHz         : 1800.000
             cache size      : 10240 KB
             physical id     : 0
             siblings        : 1
             core id         : 0
             cpu cores       : 1
             apicid          : 0
             initial apicid  : 0
             fpu             : yes
             fpu_exception   : yes
             cpuid level     : 13
             wp              : yes
             flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss syscall nx rdtscp lm 
                               constant_tsc arch_perfmon pebs bts xtopology tsc_reliable nonstop_tsc aperfmperf unfair_spinlock pni pclmulqdq ssse3 cx16 sse4
                               sse4_2 popcnt aes xsave avx hypervisor lahf_lm arat xsaveopt pln pts dtherm
             bogomips        : 3600.00
             clflush size    : 64
             cache_alignment : 64
             address sizes   : 40 bits physical, 48 bits virtual
             power management:
             
             processor       : 1
             vendor_id       : GenuineIntel
             cpu family      : 6
             model           : 45
             model name      : Intel(R) Xeon(R) CPU E5-2403 0 @ 1.80GHz
             stepping        : 7
             microcode       : 1808
             cpu MHz         : 1800.000
             cache size      : 10240 KB
             physical id     : 2
             siblings        : 1
             core id         : 0
             cpu cores       : 1
             apicid          : 2
             initial apicid  : 2
             fpu             : yes
             fpu_exception   : yes
             cpuid level     : 13
             wp              : yes
             flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss syscall nx rdtscp lm 
                               constant_tsc arch_perfmon pebs bts xtopology tsc_reliable nonstop_tsc aperfmperf unfair_spinlock pni pclmulqdq ssse3 cx16 sse4_1 
                               sse4_2 popcnt aes xsave avx hypervisor lahf_lm arat xsaveopt pln pts dtherm
             bogomips        : 3600.00
             clflush size    : 64
             cache_alignment : 64
             address sizes   : 40 bits physical, 48 bits virtual
             power management:
			 
			 
			 
<3> Windows - CPU Detail:
     |
     |__ Method 1 - CMD> msinfo32.exe .............. The console will contains physical CPU information.
     |
     |__ Method 2 - Task Manager ==> Performance ==> View ==> CPU History ==> One graph per CPU ==> "Column count means logical processors totally."	 
			  
                    Logical processor ==> Since hyper thread Intel technology, one core can act 2 threads simultenously logically.
	
	
	
<4> How many CPU Oracle database can use:
     |
     |__ SQL> show parameter cpu;

             NAME                                 TYPE        VALUE
             ------------------------------------ ----------- ------------------------------
             cpu_count                            integer     2
             parallel_threads_per_cpu             integer     2
             resource_manager_cpu_allocation      integer     2