Tuesday, September 30, 2008

GLOBAL_CONTEXT_POOL_SIZE

Property

Description

Parameter type

String

Default value

1 MB

Modifiable

No

Range of values

Any integer value in MB

Basic

No

Note:

1. The GLOBAL_CONTEXT_POOL_SIZE parameter is deprecated. It is retained for backward compatibility only.

GLOBAL_CONTEXT_POOL_SIZE specifies the amount of memory to allocate in the SGA for storing and managing global application context.

2. This parameter was introduced in Oracle9i.

3. 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) = ‘GLOBAL_CONTEXT_POOL_SIZE’;

NAME

VALUE

IS

DEFAULT

ISSES_

MODIFIABLE

ISSYS_

MODIFIABLE

ISINSTANCE_

MODIFIABLE

IS

DEPRECATED

DESCRIPTION

global_context_pool_size

TRUE

FALSE

FALSE

FALSE

TRUE

Global Application

Context Pool Size in Bytes

Oracle initializatoin parameters

No comments:

Post a Comment