Updated on 2024-06-03 GMT+08:00

DBE_PERF Schema

In the DBE_PERF schema, views are used to diagnose performance issues and are also the data source of WDR snapshots. After the database is installed, only the initial user and monitoring administrator have the permission for the DBE_PERF schema by default. To ensure forward compatibility, the permission on the DBE_PERF schema has no change before and after an upgrade. In the current version, all users are not allowed to create operators in this schema. Existing operators are not affected. Organization views are divided based on multiple dimensions, such as OS, instance, and memory. These views comply with the following naming rules:
  • Views starting with GLOBAL_: Request data from database nodes and return the data without processing them.
  • Views starting with SUMMARY_: Summarize data in the database. In most cases, data from database nodes (sometimes only the primary database node) is processed and collected.
  • Views that do not start with GLOBAL_ or SUMMARY_: Local views that do not request data from other database nodes.