Oracle9i initialization parameter Chinese description 11

xiaoxiao2021-03-06  68

Control_files:

Description: Specify one or more control file names. Oracle recommends using multiple files for different devices or OS files.

Value range: 1 - 8 file name (with path name).

Default: Depending on the operating system

DB_CREATE_ONLINE_LOG_DEST_5:

Description: Set the default location of the created online log and control file. If you do not specify a file name when you create an online log or control file, use the default file name.

Value range: File system directory name. This directory must already exist. This directory must have permission to allow Oracle to create files.

Large_pool_size:

Description: Specifies the size of the distribution stack of the large pool, which can be shared using the session memory, used as a mess-up execution message buffer and used as RMAN

The disk I / O buffer backup and recovery.

Value range: 600K (minimum);> = 20000m (maximum value is based on the operating system).

Default: 0, unless parallel execution or dbwr_io_slaves

Shared_pool_size:

Description: Specify the size of the shared pool in bytes. The shared pool contains the process of sharing the cursor, storage,

Objects such as control structure and parallel execution message buffer. Larger values ​​can improve the performance of multi-user systems.

Value range: 300 kB - Depending on the operating system.

Default: If it is a 64-bit operating system, the value is 64MB; in other cases, the value is 16MB.

Java_pool_size:

Description: Specifies the size of the Java storage pool in bytes, which is used to store Java methods and classes definitions in shared memory,

And ported to Java objects in Java session space at the end of the call. For more information, see Oracle8i Java

Developer's Guide.

Value range: Depending on the operating system.

Default: Depending on the operating system

Shared_pool_reserved_size:

Description: Specifies the space to be reserved for the larger continuous sharing pool memory,

To avoid decline in performance caused by debris. The size of the pool should comply with such conditions: all large processes and packages that can be stored to prevent objects from shared pool refresh and universally required.

Value range: shared_pool_reserved_min_alloc

Shared_pool_size half (bytes).

Default: Shared_pool_size 5% of the value

Cursor_SHARING:

Description: Control can terminate the SQL statement type of the share of the same shared cursor.

Value range:

Force: Mandatory expression is different, but the statement means the same statement sharing a cursor.

Exact: Share a cursor only exactly the same SQL statement.

Default: exact

Open_CURSORS:

Description: Specifies the maximum number of cursors (environmental areas) that can be opened at a session, and limit PL / SQL used in PL / SQL

The cursor cache size is to avoid grammar analysis when the user performs the statement again. Please set this value high enough.

This will prevent the application to exhaust the cursor.

Value range: 1 - Operating system limit value.

Default: 64

Serial_reuse:

Note: Specifies what type of SQL cursor should utilize serial reusable memory functions. If cursor_space_for_time = true,

Then the serial_reuse value will be ignored, and when it is set to

DISABLE or NULL is handled.

Value range: disable | SELECT | DML | PLSQL | All | Null

Default: null

Session_cached_cursors:

Note: Specifies the number of session cursors to cache. After multiple syntax analysis of the same SQL statement,

Its session cursor will be moved to the cursor cache of the session. This can shorten the time of grammatical analysis, because the cursor is cached by a cache without reopening.

Value range: 0 to the value determined according to the operating system.

Default: 0

Cursor_Space_for_time:

Note: When a cursor is a shared SQL area, it is determined that the SQL area remains in a shared pool or pressing the expiration process.

Value range: True | False

Default: false (expired) Rollback_SEGMENTS:

Description: Specifies one or more back to the segment to get during the routine startup, even if the quantity exceeds Transactions /

TRANSACTIONS_PER_ROLLBACK_SEGMENT value. The formula is rollback_segments =

(RBSEG_NAME [, RBSEG_NAME] ...)

Value range: Any return to the DBA_ROLLBACK_SEGS except SYSTEM.

Default: NULL (By default, use public return)

Undo_suppress_errors:

Description: Allows users to try to execute RBU operations in SMU mode (such as

ALTER ROLLBACK Segment Online is ignored. This allows users to convert all applications and scripts to SMU

The SMU function can be used before the mode.

Value range: True or False

Default: false.

MAX_ROLLBACK_SEGMENTS:

Note: Specifies the maximum size of the back section of the cache in the SGA. This value specifies that one routine can keep online status (ie, inuse)

The maximum number of refunds.

Value range: 2 -65535

Default: Maximum (30, Transactions / Transactions_Per_rollback_SEGMENT)

Undo_retention:

Description: undo_retention

The parameter is used to specify the total amount of submitted revoked information to be retained in the database. This parameter value can be set when the routine starts. You can calculate the amount of undo space required to meet the revocation reservation requirements:

UndoSpace = rd * UPS, where undoSpace is represented by the number of undo blocks, RD is used in seconds.

UNDO_RETENTION is indicated that the UPS is represented by the number of demands per second.

Value range: The maximum allowed is (2 ** 32) seconds.

Default: 30 seconds.

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

New Post(0)