Export to Excel Hangs
OliverRuAug 18 2011 — edited Mar 21 2012It seems that under certain circumstances (presumably the number/size of the records set), the Export (of query results) to Excel hangs. In my case, the Export to xls slows down at about 9,000 records. If I open TaskManager, I see both sqldeveloper.exe and perl.exe (combined) consuming close to 100% CPU. Additionally, it doesn't seems that canceling the Export is possible (e.g. CPU remains pegged and you can't close the SQL Developer Window, becuase the Connection remains in use/locked). To "escape", I need to kill the sqldeveloper.exe and perl.exe processes via Task Manager. Is this a known issue? As a workaround, I found that I am able to export the same data set to a text file without any problems.