Database DataWarehousing (MOSC)

MOSC Banner

parallel_max_servers SGA memory

edited Jun 1, 2017 5:00AM in Database DataWarehousing (MOSC) 1 commentAnswered

ORACLE 12C -ODA

we want to use parallel  during impdp, bulk-collect insert, for faster loading

should we set this parameters as per following , how is this related to SGA memory (we have SGA=64G, pga_aggregate_target =32G )

PARALLEL_MIN_SERVERS

2*CPU_COUNT * PARALLEL_THREADS_
  PER_CPU

PARALLEL_MAX_SERVERS

5 *  (2 if
  pga_aggregate_target > 0; otherwise 1)  * CPU_COUNT *
  PARALLEL_THREADS_PER_CPU

PARALLEL_SERVERS_TARGET

4 *  (2 if
  pga_aggregate_target > 0; otherwise 1)  * CPU_COUNT *
  PARALLEL_THREADS_PER_CPU

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