Home » RDBMS Server » Server Administration » Resource Manager: instance caging (11.1, Solaris)
Resource Manager: instance caging [message #517432] Tue, 26 July 2011 01:37 Go to next message
John Watson
Messages: 4102
Registered: January 2010
Location: Global Village
Senior Member
11.2 introduces instance caging, where setting cpu_count to less than the number on the box restricts the CPU usage of an instance to the number of CPUs specified:
http://download.oracle.com/docs/cd/E11882_01/server.112/e17120/dbrm007.htm#CFHJGBFC
It really does seem to work in my tests: you can guarantee that one very busy instance will not impact badly on another instance running on the same box. The parameter has been around for years, and the description is the same in both 11.1 and 11.2:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/initparams038.htm#CHDBDHHB
The production systems are still on 11.1, and the 11.1 docs do not explicitly mention instance caging. Does anyone know if instance caging works with 11.1? I find it very difficult to test anything to do with the resource manager and get consistent results, and I'm nervous about trying it. I've known it do some strange things. So I'll appreciate any advice.
Thanks.
John.
Re: Resource Manager: instance caging [message #517435 is a reply to message #517432] Tue, 26 July 2011 01:56 Go to previous messageGo to next message
Michel Cadot
Messages: 57650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Instance caging is only available in 11.2 EE and I should say 11.2.0.2 given the bugs that impact it in 11.2.0.1.

Regards
Michel

[Updated on: Tue, 26 July 2011 01:58]

Report message to a moderator

Re: Resource Manager: instance caging [message #517647 is a reply to message #517435] Wed, 27 July 2011 01:16 Go to previous messageGo to next message
John Watson
Messages: 4102
Registered: January 2010
Location: Global Village
Senior Member
Thank you for replying. I guess that's about it.
Re: Resource Manager: instance caging [message #517772 is a reply to message #517432] Thu, 28 July 2011 02:13 Go to previous messageGo to next message
halim
Messages: 99
Registered: September 2008
Location: Bangladesh
Member

Dears

suppose , I have a server cpu_count= 32 ,
i want to use cpu_count= 16 with this Instance caging method for my oracle database instance.

so, now how to calculate for oracle database licensing cost ?

Is it based on 32 or 16 ?

Thanks &regards
Halim
Re: Resource Manager: instance caging [message #517777 is a reply to message #517772] Thu, 28 July 2011 02:38 Go to previous message
Michel Cadot
Messages: 57650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think it is 16 but you have to ask your Oracle contact to have an official answer which is the only one that matters.

Regards
Michel
Previous Topic: Unable to calculate "Datafile Shrink possible" size
Next Topic: Precautions before drop user
Goto Forum:
  


Current Time: Thu Apr 24 20:29:17 CDT 2014

Total time taken to generate the page: 0.09917 seconds