I am trying to export 132K rows from a table to an .xlsx format.
The data is 6 columns wide, no large ones: 3 a max of 10 char, 2 dates and 1 single char field
Before i start SQL Dev memory usage is at about 256M when i kick off the export it peaks upto about 784M, once it hits 700M the export process slows right down the export count showing 2/3 records at a time being exported instead of the usual 100s/1000s then it white screens out and is non responsive.
Is this a SQL Dev issue i can fix in the conf file or is it a Laptop issue ?
I am running XP, with 3G of ram, CPU at around 50-70% with SQL Dev taking approx 50
Sorry should add i am using the latest version of SQL Dev 3.2.20.09
Tried updating the memory, but didn't make any difference, in fact kept going up and when got to 1024 SQL Dev wouldn't even start.
I did get the extract i mentioned to extract using export to CSV so thanks for that, however then the next extract which was 300K rows same no of colums then caused the same issue even using export -> csv.
So used the /*csv*/ hint with a spool and that seems to work for now.