OceanBase Database provides two types of system views: dictionary views and performance views. This topic describes the concepts and viewing methods of dictionary views and performance views. For more information, see System views.
Dictionary views
A virtual table that displays the metadata and system status of the database, including tables, columns, indexes, users, roles, and privileges. Dictionary views are stored in the system tablespace and are read-only. You cannot modify or delete them.
Performance views
Virtual tables that display the performance statistics and monitoring information of the database. They are read-only and cannot be modified or deleted. Performance views are stored in the system tablespace and are read-only. They are built based on the memory structure of the database and are known as dynamic performance views. Performance views can provide data about the internal disk and memory structures of the database, but this is not their main purpose.
Dictionary views and performance views are important sources of metadata and system status information in the database. They help you understand the structure, status, and performance of the database to optimize its performance.
