Oracle tools - SmartPlant Foundation - IM Update 46 - Help - Hexagon

SmartPlant Foundation Help

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10
SmartPlant Markup Plus Version
10.0 (2019)
Smart Review Version
2020 (15.0)

These tools are available as part of your Oracle database product installation. Refer to Oracle documentation for information about these products.

  • Automatic Workload Repository (AWR) - Generates a report that consists of sizing recommendations and a summary of the state of the database. Includes information on how increasing or decreasing values can affect performance.

    SQL queries in this report should list only SmartPlant Foundation tables.

  • Automatic Database Diagnostic Monitor (ADDM) - Analyzes the data generated in the AWR to identify performance bottlenecks, locating the root cause for each issue and providing recommendations for resolution. It is crucial to run the report when the system is under its greatest stress (for example, when maximum users are connected to the system or when performance is typically at its worst).

    Span the worst 4-hour period every day for a week and provide a total of 4 reports for the week, one per day.

  • Statistics - Rebuilds database statistics, which should be a routine part of database maintenance.

    Out-of-date statistics get deleted, and new statics for all objects in the schema are generated.