Getting the value of CPU_COUNT
SYS @ PRODDB SQL> show parameter cpu_count
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cpu_count integer 36
SYS @ PRODDB SQL> select name, value from v$spparameter where name in ('cpu_count');
NAME VALUE
------------------------------ ------------------------------
cpu_count
1 row selected.
Thanks
Mukul