Database DataWarehousing (MOSC)

MOSC Banner

Parameter parallel_threads_per_cpu

edited Feb 3, 2016 1:59PM in Database DataWarehousing (MOSC) 9 commentsAnswered ✓

Hi all,

Would like verification on what the values should be for cpu_count and parallel_threads_per_cpu.

We have AIX LPAR as following:

lparstat:

System configuration: type=Shared mode=Capped smt=4 lcpu=36 ....psize=21 ent=9.00

As this is a virtual server (container, LPAR), would the cpu_count  be 9 and parallel_threads_per_cpu be 4?  Or do I leave cpu_count = 32 and parallel_threads_per_cpu as default value of 2?

The reason that I ask is that cpu_count is based on cores from my understanding which is 9 (http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams040.htm#REFRN10023).  And parallel_thread_per_cpu would be based on smt which would be 4.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center