Sunday, July 4, 2021

Oracle E-Business Suite Release 12 Release-Specific Database Initialization Parameters for 19c

 

Oracle E-Business Suite Release 12  Release-Specific Database Initialization Parameters for 19c

S.No

Release-Specific Database Initialization Parameters for Oracle 19c

Required Parameters

Information about the Parameter

1

compatible = 19.0.0 #MP

EBS

 

2

optimizer_adaptive_plans = TRUE #MP

EBS

 

3

optimizer_adaptive_statistics = FALSE #MP

EBS

 

4

pga_aggregate_limit = 0 #MP

EBS

 

5

temp_undo_enabled = FALSE

EBS

 

6

_pdb_name_case_sensitive = TRUE #MP

EBS

 

7

event='10946 trace name context forever, level 8454144' #MP

EBS

 

8

_optimizer_gather_stats_on_conventional_dml = FALSE #MP

EBS

 

9

_optimizer_use_stats_on_conventional_dml = FALSE #MP

EBS

 

10

optimizer_real_time_statistics = FALSE #MP

EBS

 

Additional Database Initialization Parameters For Oracle E-Business Suite Release 12.2

11

recyclebin = off #MP

EBS

 

12

service_names=%s_dbSid%, <s_patch_service_name or ebs_patch>  # Based on AD/TXK Code level

EBS

 

13

local_listener=%s_dbSid%_LOCAL

EBS

 

14

result_cache_max_size = 600M

EB                S

                         



egrep 'compatible|optimizer_adaptive_plans|optimizer_adaptive_statistics|pga_aggregate_limit|temp_undo_enabled|_pdb_name_case_sensitive|event|_optimizer_gather_stats_on_conventional_dml|_optimizer_use_stats_on_conventional_dml|optimizer_real_time_statistics|recyclebin|service_names|local_listener|result_cache_max_size' intiSID.ora

No comments:

Post a Comment