JAVA_POOL_SIZE

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

====================================================================

Property	Description
Parameter type	Big integer
Syntax	JAVA_POOL_SIZE = integer [K | M | G]
Default value	If SGA_TARGET is set: If the parameter is not specified, then the default is 0 (internally determined by the Oracle Database). If the parameter is specified, then the user-specified value indicates a minimum value for the memory pool. If SGA_TARGET is not set: 24 MB, rounded up to the nearest granule size
Modifiable	ALTER SYSTEM
Range of values	Minimum: 0 (values greater than zero are rounded up to the nearest granule size) Maximum: operating system-dependent
Basic	No

JAVA_POOL_SIZE specifies (in bytes) the size of the Java pool, from which the Java memory manager allocates most Java state during runtime execution. This memory includes the shared in-memory representation of Java method and class definitions, as well as the Java objects that are migrated to the Java session space at end-of-call.
Note:

1. This parameter was introduced in Oracle8i.

Information on current usage of the Java Pool can be found using the query:

Select pool, name, bytes

FROM v$sgastat

WHERE pool = 'java pool';

This query will return under the name column the values of 'free memory' and 'memory in use'.

POOL	NAME	BYTES
java pool	joxs heap	141120
java pool	free memory	312166720
java pool	joxlod exec hp	6459264

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘JAVA_POOL_SIZE’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
java_pool_size	318767104	FALSE	FALSE	IMMEDIATE	TRUE	FALSE	size in bytes of java pool

Oracle initializatoin parameters