Re: export tuning

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Wed, 03 Dec 2003 15:34:56 GMT
Message-ID: <3fce0253.3460644453@nyc.news.speakeasy.net>

besides things already suggested..

consider partitioning the table, and exporting monthly/weekly data (however you please to partition).

If IO is a bottleneck, you can try gzipping on the fly (through a pipe).

On Wed, 3 Dec 2003 09:04:49 -0000, "Tom" <tomNOSPAM_at_teameazyriders.com> wrote:

>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
>
>

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Wed Dec 03 2003 - 09:34:56 CST