Home » RDBMS Server » Server Administration » 2 processors problem
icon5.gif  2 processors problem [message #271382] Mon, 01 October 2007 08:37 Go to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

I am usin oracle 10g, on linux
and i have 2 processors but when i see only 1 is working under oracle
how can i set up the 2nd processor?
thnx very much
Re: 2 processors problem [message #271388 is a reply to message #271382] Mon, 01 October 2007 08:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.
How do you see that?
Check cpu_count with "show parameter"

Regards
Michel
Re: 2 processors problem [message #271392 is a reply to message #271388] Mon, 01 October 2007 09:00 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

Michel Cadot wrote on Mon, 01 October 2007 08:56
You can't.
How do you see that?
Check cpu_count with "show parameter"

Regards
Michel


SQL> show parameters cpu

NAME                                 TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
cpu_count                            integer
2


./fa/3156/0/
Re: 2 processors problem [message #271393 is a reply to message #271382] Mon, 01 October 2007 09:02 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

and the other cpu picture
(sorry by the size of the screen)

i don't know how did the sysadmin do it but in this server, only works oracle
./fa/3157/0/

[Updated on: Mon, 01 October 2007 09:03]

Report message to a moderator

Re: 2 processors problem [message #271406 is a reply to message #271393] Mon, 01 October 2007 10:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your server is about to do nothing.
What I can see is when the CPU is requested (6:30-7:00) then both work.

Regards
Michel
Re: 2 processors problem [message #271407 is a reply to message #271406] Mon, 01 October 2007 10:28 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

Michel Cadot wrote on Mon, 01 October 2007 10:22
Your server is about to do nothing.
What I can see is when the CPU is requested (6:30-7:00) then both work.

Regards
Michel


but you can se between 1am and 2 am, only 1 cpu works hardly and the other almost do nothing

and at 4 and 5 you can se that cpu0 works and cpu1 don't work

cpu1 works but less than cpu0, that i am thinking a way to "balance" both cpus

maybe it's an internal oracle parameter that we can't manage.


Thnx in advance Wink
Re: 2 processors problem [message #271409 is a reply to message #271407] Mon, 01 October 2007 10:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
1 cpu works hardly

Hardly? Less than 50% in average! It is not hard.
Maybe it is just a monoprocess work and maybe there is an affinity of process for the previous CPU it got (I don't know Linux but I know it is possible in other Unix).
Why do you care about this?

Regards
Michel
Re: 2 processors problem [message #271410 is a reply to message #271409] Mon, 01 October 2007 10:43 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

Michel Cadot wrote on Mon, 01 October 2007 10:39
Quote:
1 cpu works hardly

Hardly? Less than 50% in average! It is not hard.
Maybe it is just a monoprocess work and maybe there is an affinity of process for the previous CPU it got (I don't know Linux but I know it is possible in other Unix).
Why do you care about this?

Regards
Michel


I have speed problem and maybe balancing the cpus maybe i can get more speed.
i am searching for problems in my db and maybe the cpu work be a key, but after read what you say, i think that i am wrong
Sad

well i can say that thread is "fixed" Wink
thnx for your help Very Happy
Re: 2 processors problem [message #271416 is a reply to message #271410] Mon, 01 October 2007 11:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry, the CPU works 50% for user but there is also a nearly 50% for system so it is working hard.
But I still think there is only 1 process and so you can't do it more unless you can split the work in 2 threads.
If it is an Oracle query. Have a look at PARALLEL unless your disk is also working hard.

Regards
Michel
Re: 2 processors problem [message #271418 is a reply to message #271416] Mon, 01 October 2007 11:18 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

Michel Cadot wrote on Mon, 01 October 2007 11:14
Sorry, the CPU works 50% for user but there is also a nearly 50% for system so it is working hard.
But I still think there is only 1 process and so you can't do it more unless you can split the work in 2 threads.
If it is an Oracle query. Have a look at PARALLEL unless your disk is also working hard.

Regards
Michel


what do you mean with "PARALLEL" ?
and yes, i have db file sequential read waits (a lot)
Re: 2 processors problem [message #271421 is a reply to message #271418] Mon, 01 October 2007 11:21 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In this case, you surely can't do more with your hardware.
Have a look at OS statistics for IO waits.
If you have several disks, try to spread the working tablespaces among them.
Analyze the queries to be sure you don't make too much IO.

Regards
Michel
Previous Topic: How to Migrate Oracle 10g with Cluster service from NT to AD domain
Next Topic: DB Got Shutdown
Goto Forum:
  


Current Time: Sun Dec 04 18:39:20 CST 2016

Total time taken to generate the page: 0.10352 seconds