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

From: Andreas Wizemann <AWizemann_at_fvvag.de>
Date: Fri, 01 Jun 2001 08:44:34 +0200
Message-ID: <aldehtohn4os2tr36lq61g4obfl45su4qc@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 - 01:44:34 CDT