Number of CPU's

[learn]

Hello,
I have been studying and practising Oracle at home so I am used to using just one CPU. Assuming, I go on the job as a junior DBA(hopefully very soon), how will I know the number of CPU's that the DB server uses without asking anybody.

thanks

[Slaine]

Learn

Basically you ask somebody
If you go your own way you will certainly make more mistakes in life than if you don't ask questions
There is only so much one can learn from text books
I find you learn a lot more by asking pertinent questions
Cheers

[learn]

thanks Slaine

[aracnid]

within the db this information is not avaible.
You may use os-command to find the number of cpu and the usage

[TerryD]

If you're on unix try:

mpstat 5 5

That will show the processor usage for each processor every 5 seconds for 5 times. It won't show the Oracle usage but will show the overall machine usage.

If you just want to know how many CPU's the server has, type this in SQL *PLUS as system:

select value from v$parameter where name = 'cpu_count';


Sometimes it's very difficult to get information about the hardware you run on.. Trust me, I've been in this post for about 2 months and I still don't know everything about the server since people don't always answer emails!.

Terry

[rschulze]

Another way to get an idea (if the former dba knew what he was doing), look in the init.ora file and look if there is an entry spin_count=2 (this means 2 cpu)

But the best is asking like said before. It is better to ask sth before screwing it up than after...

Good luck

[pao]

connect svrmgrl
pass the statement:
show parameter
it will give u all the parameters. among these, find for cpu_count.
this particular parameter shows the number of CPUs available to Oracle.

Regarding OS, for HP UX, you can use the top command in the prompt.....

[carp]

Within Oracle, you might try:

SQL> SELECT name, description, value
2 FROM v$parameter
3 WHERE name='cpu_count';

NAME
---------------------------------------
DESCRIPTION
---------------------------------------
VALUE
---------------------------------------
cpu_count
number of cpu's for this instance
1

While this won't necessarily tell you how many CPUs are on the box, it WILL tell you how many
Oracle thinks it has available to work with.