Re: Slow Oracle Export???
From: Tony Damon <bfntd_at_aimnet.com>
Date: 1996/09/07
Message-ID: <50s6j6$6te_at_news.aimnet.com>#1/1
: >
: > I'm running Oracle 7.2 on an HP9000. An export on a 1.5 GB table is taking about 7 hours.
: > I've tried a bunch of different values for exp, but it doesn't seem to make a difference.
: > We are using a fast cybernetics CY-8505 tape drive. Anyone have any suggestions?
Date: 1996/09/07
Message-ID: <50s6j6$6te_at_news.aimnet.com>#1/1
: akm_at_wizvax.net wrote:
: >
: > I'm running Oracle 7.2 on an HP9000. An export on a 1.5 GB table is taking about 7 hours.
: > I've tried a bunch of different values for exp, but it doesn't seem to make a difference.
: > We are using a fast cybernetics CY-8505 tape drive. Anyone have any suggestions?
Try increasing the BUFFER (maybe buffersize? Do a "exp help=y" for all valid parms) and the RECORDLENGTH parameter to something around 64000 and see if that makes a difference.
Tony Damon Received on Sat Sep 07 1996 - 00:00:00 CEST