Turning off Dynamic Sampling will Improve the Performance of APM


 Product(s):AssetWise APM Foundation
 Version(s):7.x
 Environment:Oracle
 Area:N/A
 Subarea:N\A

Problem

Performance is slow in Ivara APM when running against an Oracle database.



Solution

Turn off Dynamic Sampling. This can be done with the script below.

 

alter system set optimizer_dynamic_sampling=0 scope=both;