Summary of common parameters for self-built database header

xiaoxiao2021-03-06  63

Database identity parameters

DB_NAME

INSTANCE_NAME

DB_DOMAIN

Service_name

Control file

Control_files

Log management parameters

LOG_ARCHIVE_START

LOG_ARCHIVE_FORMAT

Log_archive_dest

LOG_ARCHIVE_DUPLEX_DEST

LOG_ARCHIVE_DEST_N

LOG_ARCHIVE_DEST_STATE_N

LOG_ARCHIVE_MAX_PROCESSES

LOG_ARCHIVE_MIN_SUCCEED_DEST

Log_CheckPoint_Interval

LOG_CHECKPOINT_TIMEOUT

Retreat / withdrawal management parameters

undo_management

Rollback_Segments

MAX_ROLLBACK_SEGMENTS

undo_tablespace

undo_retion

Memory management parameters

DB_BLOCK_SIZE

DB_CACHE_SIZE

DB_NK_CACHE_SIZE

Buffer_pool_keey

Buffer_pool_recycle

Buffer_pool_default

Log_buffer

Shared_pool_size

Sort_area_size

Hash_area_size

CREATE_BITMAP_AREA_SIZE

Large_pool_size

Java_pool_size

Maximum license user data limit parameters

License_max_sessions

License_max_users

License_SESSIONS_WARNING

Parameters related to shared service processes

Dispatcher

Max_dispatcher

Shared_servers

Max_shared_servers

Shared_server_ssions

Description: Specifies the total number of shared server architectural user sessions. Set this parameter to keep some user sessions for the dedicated server.

Value range: 0 to sessions - 5

sessions

Circuits

System tracking information management parameters

User_dump_dest

Background_dump_dest

MAX_DUMP_FILE_SIZE

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

New Post(0)