Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Spool vs Export Performance

_Dylan_Oct 30 2019 — edited Dec 4 2019

I was generating a decent sized delimited file (table dump of ~21 mill rows, 13 columns of mostly IDs and dates). It took < 15 minutes exporting the query results as a delimited file last week. I tried spooling it today, and 30 minutes in the file was only at about 4 mill rows. Stopping it and trying the export ran in about the same time as the previous export.

Should I expect to see such noticeable differences between spooling and export speeds?

This post has been answered by Glen Conway on Oct 30 2019
Jump to Answer
Comments
Post Details
Added on Oct 30 2019
9 comments
2,406 views