Re: export tuning

Hi,
a couple of things to try.

direct=y

Or set the buffer = to a large value. (I use 10M)

If you have set consistent=y It can take a really slow it down. So set consistent=n if you can.

You might want to check technet or metalink for other ideas.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com
Author of: 'So You Want to be an Oracle DBA?'

"Tom" <tomNOSPAM_at_teameazyriders.com> wrote in message news:1070442444.46140.0_at_despina.uk.clara.net...
> Hi,
>
> I have a daily export running and although one of the tables has around 6
million rows in it the data is mainly just clickstream
> style data, so navigation path through site type data etc.
>
> As a result the export takes around 7 hours which seems way too long and
as this table will only grow what tuning parameters are
> available to me to try to speed up this export?
>
> This is on 8.1.7
>
> thanks
>
> Tom
>
>
Received on Wed Dec 03 2003 - 05:37:30 CST