If you work with large SQL files in Oracle SQL Developer you will get out of memory errors from the Java VM it runs within. To fix this problem, you need to increase the Xmx (maximum heap size) from the default 128MB. If you start SQL Developer by creating a desktop shortcut to SQL Developer.exe, you cannot pass the -Xms parameter and instead need to edit the sqldevelopersqldeveloperbinsqldeveloper.conf file, adding the following line:-
The file is not formatted with the correct line endings (I guess from Linux/Java build) so you will need to open it with a smart text editor like Visual Studio 2005 or later, which then correctly detects and terminates the lines, otherwise it appears as one big line in Notepad.
Remember quality software? A bit more time upfront saves a ton of trouble later! Agile is cool but not an excuse for slack development.