CLUSTER_INTERCONNECTS

Property	Description
Parameter type	String
Syntax	CLUSTER_INTERCONNECTS = ifn [: ifn ] ...
Default value	There is no default value.
Modifiable	No
Range of values	One or more IP addresses, separated by colons
Basic	No

CLUSTER_INTERCONNECTS provides Oracle with information about additional cluster interconnects available for use in Real Application Clusters environments.

The CLUSTER_INTERCONNECTS parameter can be used to override the default interconnect with a preferred cluster traffic network. This parameter is useful in Data Warehouse systems that have reduced availability requirements and high interconnect bandwidth demands. You can also use CLUSTER_INTERCONNECTS to override the default interconnect chosen by Oracle.

For example, if you are running two instances of Oracle for two databases on the same machine, then you can load balance the interconnect traffic to different physical interconnects. This does not reduce Oracle availability.

Note:

1. This parameter was introduced in Oracle9i.

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

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
cluster_interconnects		TRUE	FALSE	FALSE	FALSE	FALSE	interconnects for RAC use

Oracle initializatoin parameters

CLUSTER_DATABASE_INSTANCES

Property	Description
Parameter type	Integer
Default value	1
Modifiable	No
Range of values	Any nonzero value
Basic	No
Real Application Clusters	Multiple instances must have the same value.

CLUSTER_DATABASE_INSTANCES is a Real Application Clusters parameter that specifies the number of instances that are configured as part of your cluster database. You must set this parameter for every instance. Normally you should set this parameter to the number of instances in your Real Application Clusters environment. A proper setting for this parameter can improve memory use.

Oracle uses the value of this parameter to compute the default value of the LARGE_POOL_SIZE parameter when the PARALLEL_AUTOMATIC_TUNING parameter is set to true. Note that the PARALLEL_AUTOMATIC_TUNING parameter has been deprecated.

Note:

1. This parameter was introduced in Oracle9i.

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) = ‘CLUSTER_DATABASE_INSTANCES’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
cluster_database_instances	1	TRUE	FALSE	FALSE	FALSE	FALSE	number of instances to use for sizing cluster db SGA structures

Oracle initializatoin parameters

CLUSTER_DATABASE

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

I have stopped updating the blog.

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


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

Property	Description
Parameter type	Boolean
Default value	false
Modifiable	No
Range of values	true | false
Basic	Yes
Real Application Clusters	For all instances, the value must be set to TRUE.

CLUSTER_DATABASE is a Real Application Clusters parameter that specifies whether or not Real Application Clusters is enabled.
Note:
1. This parameter was introduced in Oracle9i. It effectively replaces PARALLEL_SERVER in earlier releases.

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

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
cluster_database	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	if TRUE startup in cluster database mode

Oracle initializatoin parameters

CLIENT_RESULT_CACHE_SIZE

Property	Description
Parameter type	Big integer
Syntax	CLIENT_RESULT_CACHE_SIZE = integer [K | M | G]
Default value	0
Modifiable	No
Range of values	0 to operating system-dependent
Basic	No

CLIENT_RESULT_CACHE_SIZE specifies the maximum size of the client per-process result set cache (in bytes). All OCI client processes inherit this maximum size. Setting a nonzero value enables the client query cache feature. This can be overridden by the client configuration parameter OCI_RESULT_CACHE_MAX_SIZE.

Note:

1. This parameter was introduced in 11g.

Oracle initializatoin parameters

CLIENT_RESULT_CACHE_LAG

Property	Description
Parameter type	Big integer
Syntax	CLIENT_RESULT_CACHE_LAG = integer [K | M | G]
Default value	5000
Modifiable	No
Range of values	0 to operating system-dependent
Basic	No

CLIENT_RESULT_CACHE_LAG specifies the maximum time (in milliseconds) since the last round trip to the server, before which the OCI client query execute makes a round trip to get any database changes related to the queries cached on the client.

Note:

1. This parameter was introduced in 11g.

Oracle initializatoin parameters

CIRCUITS

Property	Description
Parameter type	Integer
Default value	There is no default value.
Modifiable	ALTER SYSTEM
Basic	No

CIRCUITS specifies the total number of virtual circuits that are available for inbound and outbound network sessions. It is one of several parameters that contribute to the total SGA requirements of an instance.

You should not specify a value for this parameter unless you want to limit the number of virtual circuits.

Note:

1. This parameter was introduced in Oracle9i.

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

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
circuits		TRUE	FALSE	IMMEDIATE	TRUE	FALSE	max number of circuits

Oracle initializatoin parameters