RE: datapump export incredibly slow

From: Stephens, Chris <Chris.Stephens_at_adm.com>
Date: Mon, 17 Feb 2014 07:02:53 -0600
Message-ID: <D95BD5AFADBB0F4E9BB6C53F14D3A05006BF65FEAF_at_JRCEXC1V1.research.na.admworld.com>



It did! Can't believe it didn't occur to me that only specifying one file would be an issue with parallel > 1.

Previously even single process dp exports were slow. that was resolved by gathering missing dictionary and fixed stats.

thanks everyone! that's was a glaringly obvious mistake that i should have thought of.

chris



From: Martin Bach [development_at_the-playground.de] Sent: Saturday, February 15, 2014 3:33 PM To: Stephens, Chris; Stephens, Chris; David Fitzjarrell; 'oracle-l_at_freelists.org' Subject: RE: datapump export incredibly slow

Hi Chris,

Please let us know if that solved your problem. I am always intrigued as to what is going on. I vaguely remember a MOS note that explained tracing data pump exports, I can dig it up if needed. If nothing helps I would like to recommend use of session snapper to see what is going on on all participating processes, maybe correlated to file system/OS statistics.

Good luck,

Martin

--
Martin Bach
Enkitec
http://www.enkitec.com
http://martincarstenbach.WordPress.com

On 14 February 2014 23:24:57 CET, "Stephens, Chris" <Chris.Stephens_at_adm.com> wrote:

>Huh. live and learn.
>
>Iíve restarted the export with %U. Hopefully that was it.
>
>THANKS!
>
-- Martin Bach Enkitec martincarstenbach.wordpress.com CONFIDENTIALITY NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by email reply. -- http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 17 2014 - 14:02:53 CET

Original text of this message