parallel_max_servers SGA memory
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_ |
PARALLEL_MAX_SERVERS | 5 * (2 if |
PARALLEL_SERVERS_TARGET | 4 * (2 if |