Forum Stats

  • 3,824,876 Users
  • 2,260,435 Discussions


SQLCL : Exception in thread "main" java.lang.OutOfMemoryError: Java heap space

While running the bulk sql more than 60, 000 sql queries and getting below error, Is 4 GB of ram (memory) is sufficient?:


Exception in thread "main" java.lang.OutOfMemoryError: Java heap space

at java.util.Arrays.copyOf(

at java.lang.AbstractStringBuilder.ensureCapacityInternal(AbstractString

at java.lang.AbstractStringBuilder.append(

at java.lang.StringBuffer.append(

at oracle.dbtools.raptor.newscriptrunner.ScriptParser.findEndOfSQLAndPLS

at oracle.dbtools.raptor.newscriptrunner.ScriptParser.identifyEndOfState


at oracle.dbtools.raptor.newscriptrunner.FallbackParserProvider.getNextV

at oracle.dbtools.raptor.newscriptrunner.FallbackParserProvider.hasNext(


at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.runFile(

at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.handleAtFiles(SqlCl

at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(


We have installed SQLCL in Linux server and having 4 GB of memory and Oracle 12c.

  1. Is SQLCL consumes more memory?
  2. And also Is any performance difference between SQLPLUS and SQLCL?
  3. Is SQL-19c is improve the performance of SQLCL? Is SQLCL package is available in SQL-19c?