Re: export tuning

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"
<[EMAIL PROTECTED]> 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