Sunday, 20 January 2013

Large pool and Java pool | Oracle DBA Tutorial pdf



Large pool and Java pool

Large pool in SGA is used for Recovery Manager (RMAN) operations and parallel query.
It is defined by LARGE_POOL_SIZE (usual values from 600K to 2GB) parameter in initialization file and cannot be changed dynamically.
Java pool is used to keep session specific Java application code and variables.
Its size is determined by JAVA_POOL_SIZE (default 20M) initialization parameter and cannot be changed dynamically.

Large pool in SGA is used for Recovery Manager (RMAN) operations and parallel query.
It is defined by LARGE_POOL_SIZE (usual values from 600K to 2GB) parameter in initialization file and cannot be changed dynamically.
Java pool is used to keep session specific Java application code and variables.
Its size is determined by JAVA_POOL_SIZE (default 20M) initialization parameter and cannot be changed dynamically.

No comments: