Automic Workload Automation

  • Private Community

  • 1.  Recommended Server Options for Oracle database

    Posted Aug 15, 2016 01:00 AM
    Are there any recommended server options for UC_SYSTEM_SETTINGS that I should use to improve performance?
    Answer:

    Per the documentation, below are recommended server options for Oracle DB: 

    3rd digit - S 

    With this setting, the statistical records are not checked when a server cold start is performed. This improves the booting performance of large Automation Engine systems (especially in combination with Oracle databases) because in most cases, the statistical records remain unchanged. 

    11th digit - 3 

    With this setting, if your Production system were to experience an outage and was unable to enable the traces to capture the issue, this option will show the BIND VARIABLES for long running SQL statements within the LOG file without the need for a trace. 

    Please refer to the documentation for more details on these two server options.

    Additionally, here is a Community post on "Oracle White Paper - best practices" that provides recommendations for setup and maintenance of the Oracle database.


  • 2.  Re: Recommended Server Options for Oracle database

    Posted Apr 29, 2018 06:13 AM

    Oracle Database 12c offers a wide range of features to help customers meet specific requirements in the areas of performance and scalability, high availability, security and compliance, data warehousing and big data, and manageability, both on-premises and on Oracle Cloud. see: ShowBox Mobdro Vidmate