Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
Asset Reliability | AssetWise APM
  • Product Communities
  • AssetWise
  • Asset Reliability | AssetWise APM
  • Cancel
Asset Reliability | AssetWise APM
Asset Reliability | AssetWise APM Wiki Turning off Dynamic Sampling will Improve the Performance of APM
    • Sign In
    Asset Reliability | AssetWise APM requires membership for participation - click to join

     
     Questions about this article, topic, or product? Click here. 

    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;



    • AssetWise APM
    • Assetwise APM Foundation
    • 7.x
    • en
    • Share
    • History
    • More
    • Cancel
    • Diana Marin Created by Bentley Colleague Diana Marin
    • When: Mon, Apr 2 2018 2:03 PM
    • Revisions: 1
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies