Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLcl Using a lot of memory

fbaf52ff-ecac-4ed4-a3d4-d4ea39c32078Sep 27 2018 — edited Sep 28 2018

Good day,

I have an issue that I just can't figure it out why. If you can help me or give me idea I will greatly appreciate it.

I have a script that uses SQLcl that constantly spooling data from the database, it works fine, but as times goes by, the java session start to consume more and more memory. Currently what I do is, I kill the session and start again so it will free the memory on my computer, but I will like to find a way of just continue using the same session without closing it for days.

Any suggestions??

the version I am using is:

SQLcl: Release 17.3.0.256.1818 Production

Eduardo Zamora

Comments

Processing

Post Details

Added on Sep 27 2018
2 comments
336 views