During the import you should see on event column in v$session. If you see
"Streams AQ: enqueue blocked on low memory" then the problem is with low
size for streams_pool_size.
My good experiences are with values 150-200m.
More in doc 1596645.1
Marian
From: Will Beldman <wbeldma@xxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>,
Date: 08. 12. 2016 23:29
Subject: Why is impdp slow to import empty tables
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
I am trying to run an impdp job from a database with thousands of tables.
I
have ~20000 tables that are empty. I still want to create the tables but
there's no actual data to import.
The output from the impdp job seems to be spending anywhere between 2-5
seconds per table. Times 20000 tables I'm looking at anywhere between 12
and
24 hours to import the entire database.
I could understand large tables, but I would expect fractions of a second
for
empty tables. Does this sound normal? Any strategies I could employ to
speed
this up?
[attachment "signature.asc" deleted by Marian Bednar/NBS/SK]