DBE_PERF Schema

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

View PDF

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. 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:

A view starting with GLOBAL_ requests data from a CN/DN and returns the data without processing the data.
A view starting with SUMMARY_ summarizes data in a cluster. In most cases, data from a CN/DN (sometimes only a CN) 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 any other CN/DN.