JAVA_JIT_ENABLED

Property	Description
Parameter type	Boolean
Default value	Operating system-dependent
Modifiable	ALTER SESSION, ALTER SYSTEM
Range of values	true | false
Basic	No

JAVA_JIT_ENABLED enables or disables the Just-in-Time (JIT) compiler for the Oracle Java Virtual Machine (OracleJVM) environment.

For platforms that support the JIT compiler, the default value of this parameter is true; otherwise the default value is false. Attempting to set this parameter to true on unsupported platforms will result in an error.

Note:

1. This parameter was introduced in 11g.

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

Oracle initializatoin parameters

INSTANCE_TYPE

Property	Description
Parameter type	String
Syntax	INSTANCE_TYPE = { RDBMS | ASM }
Default value	RDBMS
Modifiable	No
Basic	No
Real Application Clusters	Multiple instances must have the same value.

INSTANCE_TYPE specifies whether the instance is a database instance or an Automatic Storage Management instance.

Values:

· RDBMS

The instance is a database instance.

· ASM

The instance is an Automatic Storage Management instance.

Note:

1. This parameter was introduced in 10g.

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

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
instance_type	RDBMS	TRUE	FALSE	FALSE	FALSE	FALSE	type of instance to be executed

Oracle initializatoin parameters

INSTANCE_NUMBER

Property	Description
Parameter type	Integer
Default value	0 (zero)
Modifiable	No
Range of values	1 to maximum number of instances specified when the database was created
Basic	Yes
Real Application Clusters	You must set this parameter for every instance, and all instances must have different values.

INSTANCE_NUMBER is a Real Application Clusters parameter that can be specified in parallel mode or exclusive mode. It specifies a unique number that maps the instance to one free list group for each database object created with storage parameter FREELIST GROUPS.

The INSTANCE parameter of the ALTER TABLE ... ALLOCATE EXTENT statement assigns an extent to a particular free list group. If you set INSTANCE_NUMBER to the value specified for the INSTANCE parameter, the instance uses that extent for inserts and for updates that expand rows.

The practical maximum value of this parameter is the maximum number of instances specified in the CREATE DATABASE statement. The absolute maximum is operating system-dependent.

Note:

1. Related Parameter: PARALLEL_SERVER (Oracle8)    

   This is a Parallel Server parameter. 

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

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
instance_number	0	TRUE	FALSE	FALSE	FALSE	FALSE	instance number

Oracle initializatoin parameters

INSTANCE_NAME

Property	Description
Parameter type	String
Syntax	INSTANCE_NAME = instance_id
Default value	The instance's SID Note: The SID identifies the instance's shared memory on a host, but may not uniquely distinguish this instance from other instances.
Modifiable	No
Range of values	Any alphanumeric characters
Basic	No

In a Real Application Clusters environment, multiple instances can be associated with a single database service. Clients can override Oracle's connection load balancing by specifying a particular instance by which to connect to the database. INSTANCE_NAME specifies the unique name of this instance.

In a single-instance database system, the instance name is usually the same as the database name.

Note:

1. INSTANCE_NAME should not be confused with the SID, which actually uniquely identifies the instances shared memory on a host.

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

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
instance_name	MYDB	FALSE	FALSE	FALSE	FALSE	FALSE	instance name supported by the instance

Oracle initializatoin parameters

INSTANCE_GROUPS

Property	Description
Parameter type	String
Syntax	INSTANCE_GROUPS = group_name [, group_name ] ...
Default value	There is no default value.
Modifiable	No
Range of values	One or more instance group names, separated by commas
Basic	No
Real Application Clusters	Multiple instances can have different values.

Note:

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

INSTANCE_GROUPS is a Real Application Clusters parameter that you can specify only in parallel mode. Used in conjunction with the PARALLEL_INSTANCE_GROUP parameter, it lets you restrict parallel query operations to a limited number of instances.

This parameter specifies one or more instance groups and assigns the current instance to those groups. If one of the specified groups is also specified in the PARALLEL_INSTANCE_GROUP parameter, then Oracle allocates query processes for a parallel operation from this instance.

2. Related parameter: PARALLEL_INSTANCE_GROUP

   INSTANCE_GROUPS is a Parallel Server parameter. 

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

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
instance_groups		TRUE	FALSE	FALSE	FALSE	FALSE	list of instance group names

Oracle initializatoin parameters