Tuesday, January 8, 2019

GC overhead limit exceeded in Oracle SQL Developer while uploading XLSX file

I faced above error in SQL developer while I am uploading a large .xlsx file.

Cause: because of less memory it couldn't able to open. I just explicitly assigned more memory to sqldeveloper around 5000MB with following parameter.

Solution : 
  I just added following parameter in sqldeveloper.conf file and it start working fine .


AddVMOption -Xmx5000M


sqldeveloper.conf  file location-

C:\Users\username\Downloads\sqldeveloper-18.3.0.277\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf










Solution # 2 -  you can convert .xlsx to .csv file using save as option. then try because csv file required less memory than .xlsx file.

No comments: