OraFAQ Forum: Server Administration » Resource Manager: instance caging

Home » RDBMS Server » Server Administration » Resource Manager: instance caging (11.1, Solaris)

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

Resource Manager: instance caging [message #517432]

Tue, 26 July 2011 01:37

John Watson
Messages: 8960
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.

Report message to a moderator

Re: Resource Manager: instance caging [message #517435 is a reply to message #517432]

Tue, 26 July 2011 01:56

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

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

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

Senior Member

Thank you for replying. I guess that's about it.

Report message to a moderator

Re: Resource Manager: instance caging [message #517772 is a reply to message #517432]

Thu, 28 July 2011 02:13

halim
Messages: 100
Registered: September 2008

Senior 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

Report message to a moderator

Re: Resource Manager: instance caging [message #517777 is a reply to message #517772]

Thu, 28 July 2011 02:38

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 06:39:35 CST 2024