RESOURCE_MANAGER_CPU_ALLOCATION

Property	Description
Parameter type	Integer
Default value	0
Modifiable	ALTER SYSTEM
Range of values	0 to operating system-specific
Basic	No

Note:

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

2. RESOURCE_MANAGER_CPU_ALLOCATION specifies the number of CPUs that the Resource Manager should utilize. The Resource Manager controls how a system's CPUs are utilized by its database's sessions.

The Resource Manager schedules database sessions on the CPUs according to a Resource Plan that has been configured and enabled by the DBA. Normally, the Resource Manager schedules enough database sessions to keep all CPUs utilized. However, in some scenarios, a DBA may only want to schedule enough database sessions to keep a subset of the CPUs utilized.

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) = 'RESOURCE_MANAGER_CPU_ALLOCATION';

Oracle initializatoin parameters

RESOURCE_LIMIT

Property	Description
Parameter type	Boolean
Default value	false
Modifiable	ALTER SYSTEM
Range of values	true | false

RESOURCE_LIMIT determines whether resource limits are enforced in database profiles.

Values:

• TRUE

Enables the enforcement of resource limits

• FALSE

Disables the enforcement of resource limits

Note:

1. See Oracle Database Administrator's Guide and Oracle Database SQL Language Reference for more information on setting resource limits for profiles.

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) = 'RESOURCE_LIMIT';

Oracle initializatoin parameters

REPLICATION_DEPENDENCY_TRACKING

Property	Description
Parameter type	Boolean
Default value	true
Modifiable	No
Range of values	true | false

REPLICATION_DEPENDENCY_TRACKING enables or disables dependency tracking for read/write operations to the database. Dependency tracking is essential for propagating changes in a replicated environment in parallel.

Values:

• TRUE

Enables dependency tracking.

• FALSE

Allows read/write operations to the database to run faster, but does not produce dependency information for Oracle to perform parallel propagation. Do not specify this value unless you are sure that your application will not perform any read/write operations to the replicated tables.

Note:

1. See also Oracle Database Advanced Replication for more information on parallel propagation dependency tracking

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) = 'REPLICATION_DEPENDENCY_TRACKING';

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE		ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
replication_dependency_tracking	TRUE	TRUE	FALSE	FALSE	FALSE		FALSE	tracking dependency for Replication parallel propagation

Oracle initializatoin parameters