The edb_dynatune_profile parameter is used to control tuning aspects based upon the expected workload profile on the database server. The possible settings for edb_dynatune_profile are:
● oltp
● reporting
● mixed
Use oltp if heavy online transaction processing workloads are expected on the database server. For database servers used primarily for heavy reporting, use the reporting setting. The medium between the two is the mixed setting.
This parameter takes effect upon startup of the database server.