Home » RDBMS Server » Performance Tuning » Would it be useful to enable Hyper-Threading in Oracle 12.1.0.2 on Linux  () 1 Vote
Would it be useful to enable Hyper-Threading in Oracle 12.1.0.2 on Linux [message #642332] Tue, 08 September 2015 05:01 Go to next message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
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

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 Go to previous messageGo to next message
John Watson
Messages: 7620
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.

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 Go to previous messageGo to next message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This is indeed a good remark.

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 Go to previous message
John Watson
Messages: 7620
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.
Previous Topic: cost is more after releasing FTS on big table (partition table)
Next Topic: Performance improvement required
Goto Forum:
  


Current Time: Sat Oct 20 18:44:09 CDT 2018