JAVA_HEAP_SIZE option

Limits the memory used by Java applications for a connection.

Integer

1000000

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

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 runaway Java application be disallowed from using up too much memory.