OraFAQ Forum: Performance Tuning » Would it be useful to enable Hyper-Threading in Oracle 12.1.0.2 on Linux

Home » RDBMS Server » Performance Tuning » Would it be useful to enable Hyper-Threading in Oracle 12.1.0.2 on Linux (

) 1 Vote

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

Would it be useful to enable Hyper-Threading in Oracle 12.1.0.2 on Linux [message #642332]

Tue, 08 September 2015 05:01

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

Senior Member
Account Moderator

Not really a question but a topic in DBA-Village which is worth to follow (or participate).

http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=78362

Report message to a moderator

Re: Would it be useful to enable Hyper-Threading in Oracle 12.1.0.2 on Linux [message #642336 is a reply to message #642332]

Tue, 08 September 2015 05:24

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

Senior Member

I think that this is potentially very important for SE2. I've been looking at it for SPARC processors. This doc

http://docs.oracle.com/cd/E35434_01/html/E23807/highipc.html

suggests that if I have a T4 (8 cores, 8 threads per core, clock speed 3GHz) then with the default config threading=max-throughput any one of my 16 permitted running Oracle processes will run at only 3/8GHz, whereas if if I go for threading=max-ipc I will have only 8 running processes but they can run at the full 3GHz.

Report message to a moderator

Re: Would it be useful to enable Hyper-Threading in Oracle 12.1.0.2 on Linux [message #642341 is a reply to message #642336]

Tue, 08 September 2015 06:18

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

Senior Member
Account Moderator

This is indeed a good remark.

Report message to a moderator

Re: Would it be useful to enable Hyper-Threading in Oracle 12.1.0.2 on Linux [message #642402 is a reply to message #642341]

Wed, 09 September 2015 13:57

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

Senior Member

Not as good as I thought. My SA tells me that the doc I referenced is recently outdated and that in the current release of SPARC/Solaris the threaded attribute is deprecated, and instead one implements "Complete Power". The idea is that idle threads will not reduce the GHz avaialble to active threads, but I can find no detail on this.

Report message to a moderator

Previous Topic:	cost is more after releasing FTS on big table (partition table)
Next Topic:	Performance improvement required

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 13:34:23 CST 2025