Skip to Main Content

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

User_ZD984Sep 13 2021

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.
Is SQLCL consumes more memory?
And also Is any performance difference between SQLPLUS and SQLCL?
Is SQL-19c is improve the performance of SQLCL? Is SQLCL package is available in SQL-19c?

Comments
Post Details
Added on Sep 13 2021
0 comments
42 views