Pular para o conteúdo principal

Memory settings and usage of the Database Java VM


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