RE: Hyperthreading - Oracle license
Date: Thu, 10 Jan 2013 17:09:15 -0500
Message-ID: <9CE162BC5ED2C643956B526A7EDE46FF035944A6E311_at_EXM-OMF-04.Ceg.Corp.Net>
At my company on a Sun T5240 host which reports 128 CPU's due to extreme hyperthreading, I had to restrict CPU_COUNT otherwise running utlrp.sql as part of new database creation spawned so many parallel threads it brought the server to its knees.
Thanks,
Finn
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark
Sent: Thursday, January 10, 2013 4:34 PM
To: Christopher.Taylor2_at_parallon.net; rjoralist2_at_society.servebeer.com; oracle-l_at_freelists.org
Subject: RE: Hyperthreading - Oracle license
Actually, a quick MOS search, and Oracle specifically recommends staying w/ the "doubled" count for cpu_count.
See Doc ID 289870.1
-Mark
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Christopher.Taylor2_at_parallon.net
Sent: Thursday, January 10, 2013 4:24 PM
To: rjoralist2_at_society.servebeer.com; oracle-l_at_freelists.org
Subject: RE: Hyperthreading - Oracle license
If you find something like that, shoot it out to me. I'd be interested in making sure if I need to set anything like that.
Regards,
Chris
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich Jesse
Sent: Thursday, January 10, 2013 3:09 PM
To: oracle-l_at_freelists.org
Subject: RE: Hyperthreading - Oracle license
Chris writes:
> I love irony - I just got asked about turning hyperthreading on for
> our db servers. Apparently it was cut off (I didn't even know we had
> it) because no one wanted to pay for the extra licensing.
Yeah, but thought I read somewhere that CPU_COUNT should be manually set to the number of "real" (non-hyperthread) cores to prevent the instance from over-allocating resources (e.g. parallel query).
Durned if I can locate that bit of mental flake at the moment...
Rich
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l >>> This e-mail and any attachments are confidential, may contain legal, professional or other privileged information, and are intended solely for the addressee. If you are not the intended recipient, do not use the information in this e-mail in any way, delete this e-mail and notify the sender. -IP2 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 10 2013 - 23:09:15 CET