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!

Memory leak/inneficient use of memory when exporting to excel file

user13400440Nov 10 2016 — edited Nov 11 2016

Hi.

When exporting a large number of rows and columns to excel memory keeps getting assigned but never released until it's full and the task gets slower. If you are using POI the SXSSFWorkbook() method can receive the maximum number of rows to keep in memory when creating the excel file. Please look into it.

Cheers

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 9 2016
Added on Nov 10 2016
7 comments
1,522 views