Oracle9i initialization parameter Chinese description 14

xiaoxiao2021-03-06  66

Sessions:

Description: Specify the total amount of user sessions and system sessions. The default is greater than Processes to allow recursive sessions.

Value range: Any integer value.

Default: derived (1.1 * processes 5)

Java_soft_sessionspace_limit:

Description: Specify the 'soft restriction' of Java memory used in the Java session in bytes. If the user's session duration java

The state is used too much memory, and Oracle will generate a warning and write a message to the trace file.

Value range: 0 - 4GB

Default: 0

CPU_Count:

Description: The number of CPUs available for Oracle (used to calculate other parameter values). Do not change this value.

Value range: 0 - no limit.

Default: Automatic setting by Oracle

Java_max_sessionspace_size:

Description: In-byte, specifies the maximum amount of memory used by the Java program that can be run in the server. It is used to store Java each time the database calls

status. If the user's session duration Java state exceeds this value, the session will be terminated due to insufficient memory.

Value range: Depending on the operating system.

Default: 0

Processes:

Note: Specifies the maximum number of operating system user processes that can be connected to an Oracle Server simultaneously. This value should allow all background processes, such as:

Job queue (SNP) process and parallel execution (PNNN) process.

Value range: 6 to a value set according to the operating system.

Default: Determined by Parallel_Max_servers

Control_File_Record_keep_time:

Description: The shortest time (days) must be retained in the control file.

Value range: 0 -365

Default: 7

LOG_CHECKPOINT_TIMEOUT:

Note: Specifies the maximum time interval (second number of seconds) that appears from the next checkpoint. Specify this time value as 0,

The time-based checkpoint will be disabled. Lower values ​​can shorten the time of routine recovery, but may cause excess of disk operation.

Value range: 0 - no limit.

Default: Oracle8i: 900 seconds. Enterprise version: 1800 seconds

Recovery_ParalLism:

Description: Specifies the number of processes for participating routines or media recovery. If the value is 0 or 1, it indicates that the recovery will be executed in a serial manner by a process.

Value range: Depending on the operating system (cannot exceed Parallel_Max_serve).

Default: Depending on the operating system

FAST_START_MTTR_TARGET:

Description: Specifies the time required to recover from a single database routine (estimated second). FAST_START_MTTR_TARGET

The internal converted into a set of parameters, used to modify the operation of the database, thereby controlling its recovery time in the total "recovery average time (MTTR)"

There are within a certain range. This parameter is only supported by versions with the "Quick Start Fault Recovery" function.

Value range: [0, 3600]. It calculates the number of data buffer cache entries and is greater than the limit of the number of blocks in the maximum log.

Default: 0

LOG_CHECKPOINTS_TO_ALERT:

Description: Specifies that the checkpoint information is recorded in the warning file. This parameter is useful for determining whether the checkpoint is in the desired frequency.

Value range: True | False

Default: False

Fast_start_io_target:

Note: Specifies the number of I / O required during system crash or routine recovery. This value is higher than DB_BLOCK_MAX_DIRTY_TARGET

The control of the recovery process is more accurate.

Value range: 0 (disable I / O recovery limit) or 1000, to all buffers in the cache.

Default: All buffers in the cache

Log_CheckPoint_Interval:

Description: Specifies the number of OS blocks (rather than database blocks) in the redo log file before you have a checkpoint. No matter how this value,

Check points will appear when switching the log. Lower values ​​can shorten the time required for routine recovery, but may result in excess of disk operation.

Value range: None limit (this parameter can be disabled).

Default: Determined log_buffer based on the operating system:

Description: In-byte, specified before the LGWR will write the red log entry to the heavy log file,

The amount of memory used to cache these entries. Reduction entries Reserve a record of changes made to the database block. If the value is greater than 65536, reduce the redo log file I /

O, especially on systems with long-term transactions or a large amount of transaction.

Value range: Depending on the operating system.

Default: The maximum is 500K or 128K * CPU_COUNT, and the two are more

r_only_open_delayed:

Description: Used to accelerate some operations, such as: Start a large database and most of which are stored in read-only tablespaces. If set to True,

When reading data from the tablespace, you will first access the data files in the read-only table space. For side effects that may be generated, see Server Reference

MANUAL.

Value range: True | False

Default: False

Parallel_instance_group

Description: A cluster database parameter that identifies a large number of parallel routine groups that generate parallel execution. Parallel operation is only right in its instance_groups

The parameter specified in the parameter has a large number of routines that generate parallel executions.

Value range: A string representing the group name.

Default: Group consisting of all current active routines

Parallel_server:

Description: Set the Parallel_server to TRUE to enable the cluster database option.

Value range: True | False

Default: False

Parallel_server_instances:

Description: The number of currently configured routines. It is used to determine the size of the SGA structure, which is determined by the number of routines configured. Set this parameter correctly will improve SGA

Memory usage. There are several parameters to be calculated using this quantity.

Value range: any non-zero value.

Default: 1

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

New Post(0)