Home » RDBMS Server » Server Administration » CPU usage for Oracle DB (Oracle, 11g R2, solaris 5.10)
CPU usage for Oracle DB [message #624002] Wed, 17 September 2014 03:37 Go to next message
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 Go to previous messageGo to next message
John Watson
Messages: 7220
Registered: January 2010
Location: Global Village
Senior Member
What do you mean by "confirm/check" in this context?
Re: CPU usage for Oracel DB [message #624009 is a reply to message #624003] Wed, 17 September 2014 04:02 Go to previous messageGo to next message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
Hwo to know My Oracle database can using all of CPU cores?
Re: CPU usage for Oracel DB [message #624010 is a reply to message #624009] Wed, 17 September 2014 04:04 Go to previous messageGo to next message
John Watson
Messages: 7220
Registered: January 2010
Location: Global Village
Senior Member
Sorry. Perhaps someone else understands.
Re: CPU usage for Oracel DB [message #624016 is a reply to message #624002] Wed, 17 September 2014 04:22 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What could prevent from doing so?

Re: CPU usage for Oracel DB [message #624073 is a reply to message #624009] Wed, 17 September 2014 09:00 Go to previous messageGo to next message
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 Go to previous messageGo to next message
John Watson
Messages: 7220
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.
Re: CPU usage for Oracel DB [message #624116 is a reply to message #624009] Wed, 17 September 2014 21:30 Go to previous message
BlackSwan
Messages: 25797
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.
Previous Topic: user update password issues
Next Topic: Object Movement Between Datafiles
Goto Forum:
  


Current Time: Sat Jan 20 04:28:28 CST 2018

Total time taken to generate the page: 0.02426 seconds