Oracle9i initialization parameter Chinese description 15

xiaoxiao2021-03-06  72

Thread:

Description: A cluster database parameter is used to specify a unique redirect line number for each routine. In the case where the redo thread of the routine is disabled,

This routine cannot be started. If this value is zero, it means there is an enabled public thread to be available.

Value range: 0 - The maximum number of threads enabled.

Default: 0

GC_FILES_TO_LOCKS:

Description: A cluster database parameter is used to control the parallel cache management (PCM) lock to the data file.

Syntax: GC_FILES_TO_LOCKS = 'file_list = lock_count [! Blocks] [r] [EACH] [: ...]'

Default: null

Instance_number:

Description: A cluster database parameter is used to specify a unique number to map routines to a use of FreeElist Groups.

Store the idle list of database objects created by the parameters. in

This value is used in the instance clause of the ALTER TABLE .... Allocate Extent

The statement can dynamically allocate the routine.

Value range: 1 to max_instances (specified when creating a database).

Default: Minimum available number (depending on the order of routine startup, the instance_number value specified for other routines)

Active_Instance_count:

Description: Allows one routine as a main routine in a cluster composed of two routines, and another routine is a secondary routine. If the routines included in the cluster are more than two,

This parameter does not work.

Value range: 1 or> = number of routines in the cluster.

Default: None

LOCK_NAME_SPACE:

Note: Specifies the distributed lock manager (DLM) to generate a namespace of the lock name. If there is an alternate database or cloned database in the same cluster,

Preferably, this value is set.

Value range: There are up to 8 characters and special characters are not allowed.

Default: null

MAX_COMMIT_PROPAGATION_DELAY:

Description: A cluster database parameter, which is used to specify the system change number (SCN) included in the SGA of one routine, before being refreshed by LGWR,

The longest time (in 1/100 seconds) allows for the reserved. This is a very little performance parameter that needs to be changed because SCN

It may not be refreshed based on time.

Value range: 0 - 90000

Default: 700

Instance_groups:

Description: A cluster database parameter, you can use a comma-separated list,

Specify the current routine to a particular group. Use the routine group to assign a query dependent process for parallel operation.

Value range: A series of group names, separated by commas.

Default: null

Buffer_pool_recycle:

Description: Circular pool size (assigned from DB_BLOCK_BUFFERS). The purpose is to remove it after using the object to reuse the memory.

Value range: a specific string value (for example: buffers: 50, lru_latches: 1).

Default: None

Use_indirect_data_buffers:

Description: Controls 32-bit platforms that support more than 4GB physical memory on extended buffer cache mechanisms. On other platforms, this parameter will be ignored.

Value range: True | False

Default: False

DISK_ASYNCH_IO:

Description: Control data files, control files and log files are asynchronous (ie, the process overlap I / O and CPU during the table scanning process

request). This parameter can only be changed if your platform supports disk asynchronous I / O.

Value range: True | False

Default: True

DBWR_IO_SLAVES:

Description: The number of I / O borders used in DBW0 processes. DBW0 processes and their dependent are always written to disk.

Value range: 0 - Depending on the operating system.

Default: 0

DB_8k_cache_size:

Note: Specifies the size of the cache to a 8k buffer. This parameter can only be set when the value of DB_BLOCK_SIZE is not 8K.

Value range: 0m or at least 16m. The value of the block is also to meet the specific requirements of a particular platform.

Default: 0m

DB_4K_CACHE_SIZE: Description: Specifies the size of the cache to a 4k buffer. This parameter can only be set when the value of DB_BLOCK_SIZE is not 4K.

Value range: 0m or at least 16m. The value of the block is also to meet the specific requirements of a particular platform.

Default: 0m

DB_BLOCK_BUFFERS:

Description: The number of Oracle blocks in the buffer cache. This parameter significantly affects the total SGA size of the routine.

Value range: 4 - depending on the operating system.

Default: 32768

DB_32K_Cache_Size:

Description: Specifies the size of the cache to a 32K buffer. This parameter can only be set when the value of DB_BLOCK_SIZE is not 32K.

Value range: 0m or at least 16m. The value of the block is also to meet the specific requirements of a particular platform.

Default: 0m

DB_BLOCK_SIZE:

Description: A size (byte) of an Oracle database block. This value is set when creating a database and cannot be changed thereafter.

Value range: 1024 - 65536 (depending on the operating system).

Default: 2048 (depending on the operating system)

DB_CACHE_ADVICE:

Description: Enables and disable statistics collection to expect a variety of cache behaviors. Collect information in the V $ db_cache_advice view.

Value range: OFF - Close consultation, and do not assign memory; ON - open consultation (ie: will bring CPU and memory overhead); Ready - Close consultation, but keep the memory assigned to consult.

Default: OFF

转载请注明原文地址:https://www.9cbs.com/read-119653.html

New Post(0)