JAVA_POOL_SIZE

[vijay8282]

Hi,

My SGA is

SQL> show SGA

Total System Global Area 1175786764 bytes
Fixed Size 70924 bytes
Variable Size 437379072 bytes
Database Buffers 737280000 bytes
Redo Buffers 1056768 bytes


My Java Pool Size is 20000K.
This is part of which Area.

And what effect I can get if I reduce this as v r not using Java Much.

Regards
Vijay

[soniaarora]

Java_pool_size is part of the variable size.
The variable component of the SGA the sum of the "named" pools -- large pool, java pool and shared pool.
The Java pool is a fixed amount of memory allocated for the JVM running in the database. So u can definitely reduce it if u r not using Java.

[Sonia]

if java pool is not set where does the space is allocated...