雙節點簡單複寫環境：
| 參數 | 建議值 | 備註 |
|---|---|---|
| processes | 100 | |
| shared_pool_size | 30000000 | 至少 30M，複寫物件多需更大 |
| large_pool_size | 500K | |
| db_block_buffers | 550 | |
| compatible | 8.0.5.0 | |
| db_file_multiblock_read_count | 16 | |
| dml_locks | 100 | |
| sequence_cache_entries | 30 | |
| sequence_cache_hash_buckets | 23 | |
| global_names | TRUE | |
| distributed_lock_timeout | 300 | |
| distributed_transactions | 10 | |
| open_links | 6 | 節點多需增加 |
| sort_area_size | 1000000 | |
| db_name | ORA_BJ / ORA_NB | |
| job_queue_processes | 6 | |
| job_queue_interval | 60 | |
| parallel_max_servers | 10 | 僅平行傳播適用 |
| parallel_min_servers | 2 | 僅平行傳播適用 |
| replication_dependency_tracking | true | 平行傳播必須 TRUE |
節點多、關係複雜、表多時需相應調大參數。
移除所有 SNAPSHOT_ 或 JOB_QUEUE_KEEP_CONNECTIONS 參數（8i 不再支援）。
automatic_ipc=off
names.default_domain = world
names.default_zone = world
sqlnet.expire_time = 0
DISABLE_OOB = ON
ORA_BJ.world = (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=80.24.16.201)(Port=1521))(CONNECT_DATA=(SID=ORA8)))
ORA_NB.world = (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=80.24.16.14)(Port=1521))(CONNECT_DATA=(SID=ORA8)))
多節點全部加入。
| 表空間 | 建議初始值 |
|---|---|
| SYSTEM | ≥ 20M |
| ROLLBACK SEGMENTS | ≥ 20M，下一區段 ≥ 100K |
| TEMPORARY | ≥ 10M |
| TOOLS | ≥ 20M |
大量複寫、高變更量、複雜拓撲需進一步擴充。
