OraFAQ Forum: Server Administration » 2 processors problem

Home » RDBMS Server » Server Administration » 2 processors problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

2 processors problem [message #271382]

Mon, 01 October 2007 08:37

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

Report message to a moderator

Re: 2 processors problem [message #271388 is a reply to message #271382]

Mon, 01 October 2007 08:56

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: 2 processors problem [message #271392 is a reply to message #271388]

Mon, 01 October 2007 09:00

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

Attachment: 20071001_statsCPU0.png
(Size: 11.89KB, Downloaded 932 times)

Report message to a moderator

Re: 2 processors problem [message #271393 is a reply to message #271382]

Mon, 01 October 2007 09:02

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
/forum/fa/3157/0/

Attachment: 20071001_statsCPU1.png
(Size: 6.29KB, Downloaded 1009 times)

[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

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: 2 processors problem [message #271407 is a reply to message #271406]

Mon, 01 October 2007 10:28

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

Report message to a moderator

Re: 2 processors problem [message #271409 is a reply to message #271407]

Mon, 01 October 2007 10:39

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: 2 processors problem [message #271410 is a reply to message #271409]

Mon, 01 October 2007 10:43

thorin666
Messages: 144
Registered: March 2007

Senior Member

Michel Cadot wrote on Mon, 01 October 2007 10:39

Quote:

1 cpu works hardly

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

Report message to a moderator

Re: 2 processors problem [message #271416 is a reply to message #271410]

Mon, 01 October 2007 11:14

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: 2 processors problem [message #271418 is a reply to message #271416]

Mon, 01 October 2007 11:18

thorin666
Messages: 144
Registered: March 2007

Senior Member

Michel Cadot wrote on Mon, 01 October 2007 11:14

what do you mean with "PARALLEL" ?
and yes, i have db file sequential read waits (a lot)

Report message to a moderator

Re: 2 processors problem [message #271421 is a reply to message #271418]

Mon, 01 October 2007 11:21

Michel Cadot
Messages: 68686
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 17:30:08 CDT 2024