RE: impdp import schema very slow ????

From: Michael Rosenblum <mrosenblum_at_dulcian.com>
Date: Thu, 5 Apr 2007 15:48:41 -0400
Message-ID: <B79551237AFE0D42AF45696C712D744079861C@mail.DulcianWeb.local>

I always try to run EXCLUDE=STATISTICS and recollect it afterwards.  

As far as I understoon (last year I talked with a number of DBAs at Collaborate'06) - it's a known issue, especially if you use REMAP.  

Also, there is a suspended bug on metalink (5076838).  

Regards,
Michael Rosenblum

---

From: oracle-l-bounce_at_freelists.org on behalf of Kerber, Andrew W. Sent: Thu 4/5/2007 3:06 PM
To: mccdba1_at_yahoo.com; oracle-l_at_freelists.org Subject: RE: impdp import schema very slow ????

Try ...statistics=none

Then analyze after the import.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: Thursday, April 05, 2007 12:47 PM
To: oracle-l_at_freelists.org
Subject: impdp import schema very slow ????

We have ORACLE 10.2.0.2 on LINUX server. I saw ORACLE document say "expdp/IMPDP" performance a lot better than "exp/imp".

I have been tried expdp/impdp schema and found "impdp" performace very slow (at least two to three times long than "imp"). When we do "impdp" it will stay on "Processing object type
SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS" for 20 -30 minutes.

Does anyone know why?

Thanks.

---

---

The fish are biting.
Get more visitors on your site using Yahoo! Search Marketing. http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php
--

http://www.freelists.org/webpage/oracle-l

---

NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

---

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Apr 05 2007 - 14:48:41 CDT