Database Administration (MOSC)

MOSC Banner

Getting the value of CPU_COUNT

edited Dec 24, 2013 5:02PM in Database Administration (MOSC) 4 commentsAnswered
How to get the value of CPU_COUNT using SQL? The SQL below doesn't give me that.

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center