Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Export 8.1.7 much slower than 7.3.2 on VMS

Re: Oracle Export 8.1.7 much slower than 7.3.2 on VMS

From: Fred A G <nospam_at_allowed.localhost>
Date: Tue, 29 May 2001 22:48:48 +0200
Message-ID: <DTTQ6.24700$TD2.278545@news1.bredband.com>

"Malcolm Dunnett" <nothome_at_spammers.are.scum> wrote in message news:ePfDmTnEmYFx_at_malvm5.mala.bc.ca...
>
> I've noticed a dramatic difference between the speed of Oracle
 Export
> on VMS in version 7.3.2 vs 8.1.7. The 8.1.7 export is a whole lot
> slower, exporting the same tables (from an 8.1.7 server) takes over
> twice as long using the 8.1.7 export as it does using the 7.3.2
 export.
>

when it takes that much longer, you are sure that no character set conversion is taking place?

> The difference seems to be in the way the two versions write the
 export
> file. With 7.3.2 the file is created as a fixed record of 4096 bytes,
 but
> under 8.1.7 it's created as Stream/LF. It appears that the 7.3.2
 export
> is buffering stuff internally to fill the fixed length records, but
 the
> 8.1.7 export is writing stuff much more often - incurring greater
> overhead.
>

Did you MONITOR the two sessions for io and other stats?

Submitted a TAR with the problem?

Regards
/Fad Received on Tue May 29 2001 - 15:48:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US