Oracle 初始化参数生成器

# ============================
# Oracle 19c 初始化参数 — 自动生成
# 规格: 8 Core / 32GB RAM / SSD / OLTP
# 内存管理: AMM（自动内存管理）
# ============================

# --- 数据库标识 ---
db_name                         = ORCL
db_unique_name                  = ORCL
db_block_size                   = 8192

# --- AMM 自动内存管理 ---
memory_target                   = 22G
memory_max_target               = 22G

# --- 资源限制 ---
processes                       = 300
open_cursors                    = 500
db_files                        = 1000

# --- Undo 与恢复 ---
undo_tablespace                 = UNDOTBS1
undo_retention                  = 3600
db_recovery_file_dest_size      = 50G
db_recovery_file_dest           = /u01/app/oracle/fast_recovery_area

# --- 日志与归档 ---
log_buffer                      = 64M
log_archive_dest_1              = "LOCATION=USE_DB_RECOVERY_FILE_DEST"

# --- 优化器 ---
optimizer_mode                  = ALL_ROWS
cursor_sharing                  = EXACT
result_cache_mode               = MANUAL

# --- 并行 ---
parallel_max_servers            = 16
parallel_min_servers            = 0

# --- I/O 性能 ---
filesystemio_options            = SETALL
disk_asynch_io                  = TRUE

# --- 安全 ---
audit_trail                     = DB
sec_case_sensitive_logon        = TRUE
resource_limit                  = TRUE

# --- 诊断 ---
diagnostic_dest                 = /u01/app/oracle