3.8.1.6 Set Parameter Values

1. Log in to Oracle Database 19c.
2. Set the following values:
   • CLOB Changes = ALTER SYSTEM SET EVENT='44951 TRACE NAME CONTEXT FOREVER, LEVEL 1024' scope=spfile;

     Note:

     Take a backup of earlier events and then append this event (if not already set) in the existing list of events, if any.
   • DB CACHE SIZE = 48 GB (at the CDB and PDB levels)
   • JAVA_POOL_SIZE = at least 2 GB

     Note:

     DMW 3.0 and later uses Java DB memory with job/install engine architecture.
   • SGA MAX SIZE = 100 GB
   • USE_LARGE_PAGES = ONLY
   • audit_trial: Check that this parameter uses the same value you used for Oracle Database 11g
   • Set container_data as CURRENT_DICTIONARY
   • db_16k_cache_size = 16 GB
   • db_keep_cache_size = 12 GB
   • open_cursors = 1000 (at the CDB and PDB levels)
   • open_links = 50
   • open_links_per_instance = 500
   • _optimizer_dsdir_usage_control = 0
   • _optimizer_gather_stats_on_conventional_dml = FALSE
   • _optimizer_use_stats_on_conventional_dml = FALSE
   • pga_aggregate_target = 30 GB (at the CDB and PDB levels)
   • parallel_max_servers = 64
   • pga_aggregate_limit = 60 GB
   • processes = 5000
   • _column_tracking_level = 1
   • _sql_plan_directive_mgmt_control = 0
   • shared_pool_size = 12 GB (at the CDB and PDB levels)
   • Add SQLNET.ALLOWED_LOGON_VERSION_SERVER=10: and SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10 in SQLNET.ORA of grid home in all RAC Nodes
   • Add SQLNET.INBOUND_CONNECTION_TIMEOUT=300 in SQLNET.ORA of grid home and PDB $TNS_ADMIN in all RAC Nodes (source the PDB environment file from ORACLE_HOME)
   • Remove the encryption parameter. For details, see Use of Oracle Database Native Network Encryption with DMW (Document ID 2783451.1) on My Oracle Support.