Database DataWarehousing (MOSC)

MOSC Banner

11g (single instance) on AIX 6.1 : parallelism

edited Sep 9, 2013 12:27PM in Database DataWarehousing (MOSC) 14 commentsAnswered ✓
Hi

In 11g (single instance) on AIX 6.1   , in order to implement parallelism how to choose   :

- DOP (Degree Of Parallelism) : AUTO ? PARALLEL_DEGREE_POLICY=AUTO is enough ? recommended ?

According to http://docs.oracle.com/cd/E11882_01/server.112/e25523/parallel002.htm

DOP = PARALLEL_THREADS_PER_CPU x CPU_COUNT (single instance)

but what about cores per CPU ?

How to know PARALLEL_THREADS_PER_CPU ?

How to choose PARALLEL_MAX_SERVERS ?

Other important parameters to implement parallelism ?

Thanks.

GD.

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