ORA-4030 While Running a Query from a Remote Client
(Doc ID 266219.1)
Last updated on FEBRUARY 03, 2020
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
An ORA-4030 error occurred while running a SQL from a remote session.
After making changes to cat /etc/security/limits and setting the value to unlimited for data, stack and memory as below, the query failed from the remote session. The same query was successful from the server itself.
fsize = -1
data = -1
stack = -1
memory = -1
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!