JVM memory settings:
create or replace function getMaxMemorySize return number is language
java name 'oracle.aurora.vm.OracleRuntime.getMaxMemorySize() returns long';
/
create or replace function getMaxRunspaceSize return number is language
java
name 'oracle.aurora.vm.OracleRuntime.getMaxRunspaceSize() returns long';
/
create or replace function getMaxSessionSize return number is language
java
name 'oracle.aurora.vm.OracleRuntime.getMaxSessionSize() returns long';
/
SQL> select getMaxMemorySize from dual;
SQL> select getMaxSessionSize from dual;
SQL> select getMaxRunspaceSize from dual;
JVM usage:
create or replace function getJavaStackSize return number is language
java
name 'oracle.aurora.vm.OracleRuntime.getJavaStackSize() returns long';
/
create or replace function getJavaPoolSize return number is language
java
name 'oracle.aurora.vm.OracleRuntime.getJavaPoolSize() returns long';
/
SQL> select getJavaStackSize from dual;
SQL> select getJavaPoolSize from dual;
Comentários
Postar um comentário