Exports slow in ver. 9 vs. ver. 8???

Ron E

Member²
We have somebody with a new Windows 7 PC running 9.0.2.1621 02.66282 (Oracle 11g enterprise ed. Rel. 11.2.0.3.0) who is complaining that his extract speed is much slower and practically hangs his PC while it's running, compared to his old PC (which was running ver.8.0.2.1505 02.58669). On that PC the same code runs normally and exports in about 13 minutes to the same network drive. He is running simple SQL by clicking on the 'immediate export' icon on the right side of the code window.

I realize that with a new PC and different network connections (he's in a different office now), there are a lot of variables. But I thought I'd find out whether anybody else had noticed any differences between the versions before we roll the new version out to too many others. Is the immediate export process handled the same on the PC by both versions?

Thanks,

Ron
 
There are no significant differences in export speeds between versions 8 and 9. Can you install 8.0 on the same PC and verify?
 
I can confirm this (in Tools-Export tables). I had to stop using "SQL inserts" type export because it was extremely slow. "PL/SQL Developer" type of export is OK.
 
Back
Top