Updated on 2023-10-23 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 a database is installed, only the initial user and monitoring administrator have permission to view views and functions in the DBE_PERF scheme by default. If the database is upgraded from an earlier version, permissions for the DBE_PERF schema are the same as those of the earlier version to ensure forward compatibility. Organization views are divided based on multiple dimensions, such as OS, instance, and memory. These views comply with the following naming rules:
  • A view starting with GLOBAL_ requests data from CNs and DNs and returns the data without processing the data.
  • A view starting with SUMMARY_ summarizes data in cluster. In most cases, data from CNs and DNs (sometimes only CNs) is processed, aggregated, and returned.
  • A view that does not start with GLOBAL_ or SUMMARY_ is a local view and does not request data from other CNs or DNs.