Data pump import not using parallellism on RAC nodes as expected when running as sysdba
Last updated on FEBRUARY 18, 2016
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
Experiencing slower performance during import, and do not see import processes running on second RAC node as expected, even though data pump parameters are configured to allow for parallelism on cluster.
parfile contains parameters that would allow for parallelism to be used across RAC.
The import has previously run at faster throughput, but now the import is running at slower speed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms