RE: impdp import schema very slow ????
- From: "Michael Rosenblum" <mrosenblum@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 5 Apr 2007 15:48:41 -0400
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@xxxxxxxxxxxxx on behalf of Kerber, Andrew W.
Sent: Thu 4/5/2007 3:06 PM
To: mccdba1@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: impdp import schema very slow ????
Try ...statistics=none
Then analyze after the import.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc
Sent: Thursday, April 05, 2007 12:47 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//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.
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
