Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Export 8.1.7 much slower than 7.3.2 on VMS
"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