Oracle tools - HxGN SDx - Update 63 - Administration & Configuration

Administration and Configuration of HxGN SDx

Language
English
Product
HxGN SDx
Search by Category
Administration & Configuration
SmartPlant Foundation / SDx Version
10

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 HxGN SDx 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.