JAVA_HEAP_SIZE option

To limit the memory used by Java applications for a connection.

Integer

Can be set for an individual connection or the PUBLIC group. Takes effect immediately. DBA permissions are required to set this option for any connection.

1000000

This option sets the maximum size (in bytes) of that part of the memory that is allocated to Java applications on a per connection basis. Per connection memory allocations typically consist of the user's working set of allocated Java variables and Java application stack space.

While a Java application is executing on a connection, the per connection allocations come out of the fixed cache of the database server, so it is important that a run-away Java application is disallowed from using up too much memory.