Re: HELP ! Export takes more than 8 hours !!

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Fri, 1 Jun 2001 11:00:20 +0100
Message-ID: <991389692.22191.0.nnrp-13.c30bdde2@news.demon.co.uk>

add 'direct=y'. That should help a *lot*. Also, unless you are doing a 'hot export' (ie. users in and mucking around), do you need 'consistent=y'?

'direct=y' is the most important however. If you don't want to use 'direct=y', then add instead 'buffer=10485760' (to use 10mb data buffer). A quick look at the export parameters documentation wouldn't go amiss either...

"Andreas Wizemann" <AWizemann_at_fvvag.de> wrote in message news:aldehtohn4os2tr36lq61g4obfl45su4qc_at_4ax.com...
> On Thu, 31 May 2001 08:30:41 +0200, Andreas Wizemann
> <AWizemann_at_fvvag.de> wrote:
>
> >Hi,
> >we have a big timing problem with export.
> >Since a few days our nightly export of one of our Oracle 8.1.5
> >database takes now more than 8 hours ! Previously it takes about 40
> >min ! Don't know what has changed.
> >This runs on AIX 4.3.3-ML07
> >Any help ?
> >
>
> Sorry, there has been a bug in the checking routine.
>
> It compares
> EXP-1 with 45.453.312 Bytes within 102 min
> EXP-2 with 79.298.048 Bytes within 354 min
>
> but the real size is 279.298.048 Bytes !!
>
> So filesize has grown about 6 times and duration has grown about 3.5
> times. So, anyway, how can i speed up the EXP process ?
>
> Command is as follows:
>
> exp system/manager full=y consistent=y file=mydmpfile log=mylog
> Andreas Wizemann
Received on Fri Jun 01 2001 - 05:00:20 CDT