RE: Hyperthreading - Oracle license
- From: "Jorgensen, Finn" <Finn.Jorgensen@xxxxxxxxxxxxxxxxx>
- To: "Mark.Bobak@xxxxxxxxxxxx" <Mark.Bobak@xxxxxxxxxxxx>, "Christopher.Taylor2@xxxxxxxxxxxx" <Christopher.Taylor2@xxxxxxxxxxxx>, "rjoralist2@xxxxxxxxxxxxxxxxxxxxx" <rjoralist2@xxxxxxxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 10 Jan 2013 17:09:15 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Bobak, Mark
Sent: Thursday, January 10, 2013 4:34 PM
To: Christopher.Taylor2@xxxxxxxxxxxx; rjoralist2@xxxxxxxxxxxxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Christopher.Taylor2@xxxxxxxxxxxx
Sent: Thursday, January 10, 2013 4:24 PM
To: rjoralist2@xxxxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Rich Jesse
Sent: Thursday, January 10, 2013 3:09 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
