Forum Stats

  • 3,750,416 Users
  • 2,250,175 Discussions
  • 7,866,972 Comments

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(Arrays.java:3332)

at java.lang.AbstractStringBuilder.ensureCapacityInternal(AbstractString

at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:448

at java.lang.StringBuffer.append(StringBuffer.java:270)

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

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

at oracle.dbtools.raptor.newscriptrunner.ScriptParser.next(ScriptParser.

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

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

at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecut

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

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

at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:49

'


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?