OraFAQ Forum: Server Administration » CPU usage for Oracle DB

Home » RDBMS Server » Server Administration » CPU usage for Oracle DB (Oracle, 11g R2, solaris 5.10)

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

CPU usage for Oracle DB [message #624002]

Wed, 17 September 2014 03:37

Tlg13team
Messages: 100
Registered: June 2008
Location: MGL

Senior Member

Hello

How to confirm/check my Oracle instance using all of CPU cores?

[EDITED by LF: fixed topic title typo]

[Updated on: Wed, 17 September 2014 14:35] by Moderator

Report message to a moderator

Re: CPU usage for Oracel DB [message #624003 is a reply to message #624002]

Wed, 17 September 2014 03:44

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

What do you mean by "confirm/check" in this context?

Report message to a moderator

Re: CPU usage for Oracel DB [message #624009 is a reply to message #624003]

Wed, 17 September 2014 04:02

Tlg13team
Messages: 100
Registered: June 2008
Location: MGL

Senior Member

Hwo to know My Oracle database can using all of CPU cores?

Report message to a moderator

Re: CPU usage for Oracel DB [message #624010 is a reply to message #624009]

Wed, 17 September 2014 04:04

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Sorry. Perhaps someone else understands.

Report message to a moderator

Re: CPU usage for Oracel DB [message #624016 is a reply to message #624002]

Wed, 17 September 2014 04:22

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What could prevent from doing so?

Report message to a moderator

Re: CPU usage for Oracel DB [message #624073 is a reply to message #624009]

Wed, 17 September 2014 09:00

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

If you have Enterprise Edition, it will use all CPU's unless you set limit in the initialization parameters.
For other versions, it will be limited to that version.

[Updated on: Wed, 17 September 2014 09:03] by Moderator

Report message to a moderator

Re: CPU usage for Oracel DB [message #624075 is a reply to message #624073]

Wed, 17 September 2014 09:14

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

Remember that the limitation is legal, not technical. The OS will schedule the Oracle processes on all the CPUs/cores/threads that are available.

Report message to a moderator

Re: CPU usage for Oracel DB [message #624116 is a reply to message #624009]

Wed, 17 September 2014 21:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Hwo to know My Oracle database can using all of CPU cores?
Oracle has no control over what or how OS schedules processes.
Answer depends upon which Operating System runs on your system & since you ignored Posting Guidelines, I'll ignore you.

Report message to a moderator

Previous Topic:	user update password issues
Next Topic:	Object Movement Between Datafiles

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 20:30:34 CST 2025