Following are Oracle 19c specific parameter which can be added in a pfile for a database running 19.x.x
########### Compatibility parameter.## Compatibility should be set to the current release.##########compatible = 19.0.0 #MP######### # # Optimizer parameters. # # In Oracle Database 12.2 or higher, the Parameter optimizer_adaptive_features has been obsoleted, # replaced and controlled by two new parameters, optimizer_adaptive_plans, which defaults to TRUE and # optimizer_adaptive_statistics, which defaults to FALSE. For more details Refer MOS DOC ID 2031605.1. # ########## optimizer_adaptive_plans = TRUE #MPoptimizer_adaptive_statistics = FALSE #MP######### # # PGA Aggregate Limit parameter. # # PGA_AGGREGATE_LIMIT feature in 19c limits PGA memory usage # # The default value of PGA_AGGREGATE_LIMIT is set to the greater of 2 GB, # 200% of PGA_AGGREGATE_TARGET, and 3 MB times the PROCESSES parameter. # It will not exceed 120% of the physical memory size minus the total SGA size. # # PGA_AGGREGATE_LIMIT cannot be set below its default value. If a value of 0 is specified, # it means there is no limit to the aggregate PGA memory consumed by the instance. # If total PGA memory usage is over PGA_AGGREGATE_LIMIT value. The sessions or processes # that are consuming the most untunable PGA memory will be terminated. # # Recommended value for PGA_AGGREGATE_LIMIT is 0. # ########## pga_aggregate_limit = 0 #MP ######### # # Temp Undo Enabled parameter. # # TEMP_UNDO_ENABLED helps to reduce the amount of redo caused by DML on global temporary tables. # Setting to TRUE may cause serious issues, such as ORA-55526, for distributed transactions (Ref. Bug 20712819). # The recommended value for systems using distributed transactions is currently FALSE (Pending ER 24286334). # If not using distributed transactions, TRUE will improve performance by eliminating REDO on permanent UNDO. # ########## temp_undo_enabled = FALSE ######### # # Multitenant Architecture parameter. # # This parameter is required if the non-cdb name in lower case or mixed case, then # plugin database will be created with the same case. Otherwise default is Upper case. # This parameter needs to be set at the CDB level before plugging in the PDB # ########## _pdb_name_case_sensitive = TRUE #MP ######### # # Event parameter. # # Ensure the following event is set for Oracle E-Business Suite to work with Database Release 19c. # This parameter needs to be set at the CDB level. When this event is set, # it will allow utl_file functions to accept a directory path as input and # enable backward compatibility of user/all/dba_arguments behavior on 19c. # ########## event=’10946 trace name context forever, level 8454144′ #MP ######### # # Real Time Statistics for On-Premise Exadata and Exadata Cloud Service environments. # # If you are using Oracle Database Release 19c (19.1.x-19.9.x) on Engineered Systems such as # Exadata or ExaCS, ensure the following parameters are set to FALSE. This will disable Real # Time Statistics, and stop gathering optimizer real-time statistics for conventional DMLs. _optimizer_gather_stats_on_conventional_dml = FALSE #MP _optimizer_use_stats_on_conventional_dml = FALSE #MP # The parameter optimizer_real_time_statistics is an Oracle Database 21c parameter that has # been backported to Oracle Database 19c RU 10 (19.10.x). If you are using Oracle Database # Release 19.10.x or higher on an Engineered System such as Exadata or ExaCS, ensure the # parameter is disabled (the default) by setting it to FALSE. optimizer_real_time_statistics = FALSE #MP ################################################################################# End of Release-Specific Database Initialization Parameters Section for 19c################################################################################ |
Leave a Reply