Overview of views in the sys tenant
Dictionary views overview
Tables and columns
| View name | Description |
|---|---|
| oceanbase.CDB_IND_COLUMNS | This view displays the column information of all index tables in all tenants. |
| oceanbase.CDB_INDEXES | This view displays the INDEX information of all tenants. |
| oceanbase.CDB_TABLES | This view displays the TABLE information of all tenants. |
| oceanbase.CDB_OB_TABLEGROUP_TABLES | This view displays the TABLEGROUP and TABLE relationships of all tenants in the sys tenant. The tables not in a tablegroup are not displayed. |
| oceanbase.CDB_TAB_COLS | This view displays the column information of all tables and views in all tenants. |
| oceanbase.CDB_TAB_COLS_V$ | This view displays the column information of all tables and views in all tenants. |
| oceanbase.DBA_OB_TABLEGROUP_TABLES | This view displays the TABLEGROUP and TABLE relationships. The tables not in a tablegroup are not displayed. |
| oceanbase.DBA_PART_KEY_COLUMNS | This view displays the columns of the partitioning key in all partitioned objects in the database. |
| oceanbase.DBA_SUBPART_KEY_COLUMNS | This view displays the columns of the subpartitioning key in all partitioned objects in the database. |
| oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO | This view displays the column checksum error information between the index table (global index and local index) and the primary table. |
| oceanbase.CDB_OB_TABLE_LOCATIONS | This view displays the locations of tables and partitions, including system tables, user tables, and index tables. |
| oceanbase.DBA_OB_TABLE_LOCATIONS | This view displays the locations of tables and partitions, including system tables, user tables, and index tables. |
| information_schema.TABLESPACES | This view displays information about tablespaces.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can query only the table structure. |
Materialized view-related views
| View | Purpose |
|---|---|
| oceanbase.CDB_MVIEW_RUNNING_JOBS | This view displays the materialized view-related tasks that are being executed in all tenants, including refresh tasks and MLOG cleanup tasks. |
| oceanbase.DBA_MVIEW_DEPS | This view displays the dependencies of materialized views in the current tenant. |
| oceanbase.DBA_MVIEW_LOGS | This view displays the logs of materialized views. |
| oceanbase.DBA_MVIEW_RUNNING_JOBS | This view displays the materialized view-related tasks that are being executed in the current tenant, including refresh tasks and MLOG cleanup tasks. |
| oceanbase.DBA_MVIEWS | This view displays the information about all materialized views. |
| oceanbase.DBA_MVREF_CHANGE_STATS | This view displays the statistics about materialized view refreshes. |
| oceanbase.DBA_MVREF_RUN_STATS | This view displays the information about each refresh run of a materialized view. Each refresh run is identified by a REFRESH_ID. |
| oceanbase.DBA_MVREF_STATS | This view displays the basic timing statistics about materialized view refreshes. |
| oceanbase.DBA_MVREF_STATS_PARAMS | This view displays the refresh statistics attributes associated with each materialized view. |
| oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS | This view displays the system-wide default values of the statistics attributes of the materialized view refresh history. |
| oceanbase.DBA_MVREF_STMT_STATS | This view displays the information about the refresh statements. |
InnoDB storage engine
| View name | Description |
|---|---|
| information_schema.NDB_TRANSID_MYSQL_CONNECTION_MAP | This view displays the mapping relationship information between NDB transactions, NDB transaction coordinators, and MySQL servers attached as API nodes to an NDB cluster.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_TRX | This view displays the information about active transactions.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_LOCK_WAITS | This view displays the information about locks that are waiting for lock conflicts.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_LOCKS | This view displays the information about all locks (waiting and held).
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_BUFFER_PAGE | This view displays the information about all cached pages in the buffer pool.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_BUFFER_PAGE_LRU | This view displays the LRU-sorted information about pages in the InnoDB buffer pool.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_BUFFER_POOL_STATS | This view displays the statistics about the InnoDB buffer pool.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_CMP | This view displays the operation status information about compressing InnoDB tables.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_CMP_PER_INDEX | This view displays the information about operations on compressing InnoDB tables and indexes.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_CMP_PER_INDEX_RESET | This view displays the reset time information about operations on compressing InnoDB tables and indexes.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_CMP_RESET | This view displays the operation status about compressing InnoDB tables.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_CMPMEM | This view displays the status of compressed pages in the InnoDB buffer pool.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_CMPMEM_RESET | This view displays the reset time status of compressed pages in the InnoDB buffer pool.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_SYS_DATAFILES | This view displays the data file paths of InnoDB files for each table and general tablespace.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_SYS_INDEXES | This view displays the metadata about InnoDB indexes.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_SYS_TABLES | This view displays the metadata about InnoDB tables.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_SYS_TABLESPACES | This view displays the metadata about InnoDB table files and general tablespaces.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_SYS_TABLESTATS | This view displays the low-level status information about InnoDB tables.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_SYS_VIRTUAL | This view displays the metadata about InnoDB virtual generated columns.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_TEMP_TABLE_INFO | This view displays information about active InnoDB temporary tables created by users.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_METRICS | This view displays InnoDB performance information.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
Shared storage
| View name | Purpose |
|---|---|
| DBA_OB_ZONE_STORAGE | This view displays the information about the shared storage cluster configuration for object storage on each zone. |
Outline
| View name | Purpose |
|---|---|
| oceanbase.DBA_OB_OUTLINES | This view displays the execution plan outline information of the current tenant. |
| oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL | This view displays the outline information of the throttling rules of the current tenant. |
| oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY | This view displays the execution plan and throttling rule outline history information of the current tenant. |
| DBA_OB_FORMAT_OUTLINES | This view records the detailed information of the current tenant's format outline. |
Basic information about a database
| View name | Description |
|---|---|
| oceanbase.CDB_OB_DATABASES | This view displays the metadata of all databases in all tenants under the sys tenant. |
| oceanbase.CDB_OB_MAJOR_COMPACTION | This view displays the global major compaction information of all tenants under the sys tenant. |
| oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION | This view displays the major compaction information of all zones in all tenants under the sys tenant. |
| oceanbase.DBA_OB_DATABASES | This view displays the metadata of all databases in the current tenant. |
| oceanbase.DBA_OB_MAJOR_COMPACTION | This view displays the global major compaction information of the current tenant. |
| oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY | This view displays the history of events of the Root Service. |
| oceanbase.DBA_OB_SERVER_JOBS | This view displays the tasks of all OBServer nodes. |
| oceanbase.DBA_OB_SERVERS | This view displays the information of all OBServer nodes. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | This view displays the major compaction information of all zones in the current tenant. |
| oceanbase.DBA_OB_ZONES | This view displays the information of all zones. |
| oceanbase.CDB_OB_FREEZE_INFO | This view displays the version information generated by major compaction. |
| oceanbase.DBA_OB_FREEZE_INFO | This view displays the version information generated by major compaction. |
| information_schema.events | This view records all event information. |
Partition-related
| View | Purpose |
|---|---|
| oceanbase.CDB_IND_PARTITIONS | This view displays the partition information of all index tables of all tenants. |
| oceanbase.CDB_IND_SUBPARTITIONS | This view displays the subpartition information of all indexes in the database. |
| oceanbase.CDB_OB_DYNAMIC_PARTITION_TABLES | This view displays the dynamic partition table information of all tenants. |
| oceanbase.CDB_PART_INDEXES | This view displays the partition information of all index tables of all tenants. |
| oceanbase.CDB_PART_TABLES | This view displays the partition information of all partitioned tables of all tenants. |
| oceanbase.CDB_SUBPARTITION_TEMPLATES | This view displays the template secondary partition information of all partitioned tables of all tenants. |
| oceanbase.CDB_TAB_PARTITIONS | This view displays the primary partition information of all partitioned tables of all tenants. |
| oceanbase.CDB_TAB_SUBPARTITIONS | This view displays the secondary partition information of all partitioned tables of all tenants. |
| oceanbase.DBA_IND_PARTITIONS | This view displays the primary partition information of all indexes. |
| oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES | This view displays the dynamic partition table information of the current tenant. |
| oceanbase.DBA_PART_INDEXES | This view displays the partition information of all partitioned indexes. |
| oceanbase.DBA_PART_TABLES | This view displays the partition information of all user tables. |
| oceanbase.DBA_TAB_PARTITIONS | This view displays the multi-level partition information, partition storage parameters, and partition statistics information accessible to the current user. |
| oceanbase.DBA_TAB_SUBPARTITIONS | This view displays the subpartition name, table name, partition name, storage attributes, and statistics generated by the DBMS_STATS package. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | This view displays the subpartition template descriptions. |
Load balancing
| View name | Description |
|---|---|
| oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS | This view displays the current partition transfer tasks of all tenants. |
| oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY | This view displays the history of partition transfer tasks of all tenants. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS | This view displays the current partition transfer tasks of the current tenant. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | This view displays the history of partition transfer tasks of the current tenant. |
Full-text index
| View name | Description |
|---|---|
| information_schema.INNODB_FT_BEING_DELETED | This view displays the information about full-text indexes that are being deleted.
NoteThis view is available only for compatibility with MySQL 5.7. You can query only the table structure. |
| information_schema.INNODB_FT_CONFIG | This view displays the configuration information of the InnoDB full-text search engine.
NoteThis view is available only for compatibility with MySQL 5.7. You can query only the table structure. |
| information_schema.INNODB_FT_DELETED | This view displays the information about full-text indexes that are marked for deletion.
NoteThis view is available only for compatibility with MySQL 5.7. You can query only the table structure. |
| information_schema.INNODB_FT_INDEX_CACHE | This view displays the cache status information of InnoDB full-text indexes.
NoteThis view is available only for compatibility with MySQL 5.7. You can query only the table structure. |
| information_schema.INNODB_SYS_FIELDS | This view displays the metadata information of key columns (fields) of InnoDB indexes, which is equivalent to the information of the SYS_FIELDS table in the InnoDB data dictionary.
NoteThis view is available only for compatibility with MySQL 5.7. You can query only the table structure. |
Session
| View name | Description |
|---|---|
| oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY | This view displays the history of deadlock events. In the root tenant, this view displays the history of all tenants. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | This view displays the history of deadlock events. In a non-root tenant, this view displays the history of the current tenant. |
| oceanbase.DBA_OB_SERVER_EVENT_HISTORY | This view displays the event history of OBServer nodes. |
Backup and restore
| View | Description |
|---|---|
| oceanbase.CDB_OB_RESTORE_PROGRESS | This view displays the execution progress of a physical restore task. |
| oceanbase.CDB_OB_RESTORE_HISTORY | This view displays the status of a physical restore task upon completion. |
| oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES | This view displays the status of pieces in a backup set. |
| oceanbase.CDB_OB_BACKUP_SET_FILES | This view displays the file status of a backup set. |
| oceanbase.CDB_OB_BACKUP_JOBS | This view displays all backup jobs of all tenants in the cluster. A backup job record is generated when a backup task is initiated. |
| oceanbase.CDB_OB_BACKUP_JOB_HISTORY | This view displays the historical records of all backup jobs of all tenants in the cluster. |
| oceanbase.CDB_OB_BACKUP_TASKS | This view displays all task-level backup tasks of all tenants in the cluster. A task record corresponds to a backup set. Task records and job records are in a one-to-one correspondence. |
| oceanbase.CDB_OB_BACKUP_TASK_HISTORY | This view displays the historical records of all task-level backup tasks of all tenants in the cluster. |
| oceanbase.DBA_OB_BACKUP_JOBS | This view displays all backup jobs of the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOB_HISTORY | This view displays the historical records of all backup jobs of the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASKS | This view displays all task-level backup tasks of the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASK_HISTORY | This view displays the historical records of all task-level backup tasks of the current tenant. |
| oceanbase.DBA_OB_BACKUP_SET_FILES | This view displays the file status of a backup set. |
| oceanbase.DBA_OB_RESTORE_PROGRESS | This view displays the progress of a restore task. |
| oceanbase.DBA_OB_RESTORE_HISTORY | This view displays the status of a completed restore task. |
| oceanbase.DBA_OB_ARCHIVE_DEST | This view displays the archive path configuration. |
| oceanbase.CDB_OB_ARCHIVE_DEST | This view displays the archive path configuration. |
| oceanbase.CDB_OB_BACKUP_PARAMETER | This view displays the backup parameters. |
| oceanbase.CDB_OB_BACKUP_DELETE_JOBS | This view displays the progress of a tenant-level backup cleanup job. |
| oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY | This view displays the history of backup cleanup tasks executed in the tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASKS | This view displays the information about backup_set/backup_piece cleanup tasks being executed in the tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY | This view displays the history of backup_set/backup_piece cleanup tasks completed in the tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_POLICY | This view displays the cleanup policies set for expired/automatic cleanup in the tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO | This view displays the information about the backup destinations used for backup and restore in the tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY | This view displays the history of backup destinations used for backup and restore in the tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | This view displays the information about the backup destinations used for backup and restore in the tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY | This view displays the history of backup destinations used for backup and restore in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_POLICY | This view displays the cleanup policies set for expired/automatic cleanup in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOBS | This view displays the execution progress of tenant-level backup cleanup jobs. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY | This view displays the history of backup cleanup tasks executed in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | This view displays the information about backup_set/backup_piece cleanup tasks being executed in the tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY | This view displays the history of backup_set/backup_piece cleanup tasks completed in the tenant. |
| oceanbase.DBA_OB_ARCHIVELOG | This view displays the status of log backups on each path. |
| oceanbase.DBA_OB_ARCHIVELOG_SUMMARY | This view displays the status of all log backups in the history and current. |
| oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES | This view displays the status of pieces in a backup set. |
| oceanbase.CDB_OB_ARCHIVELOG | This view displays the status of log archiving on each path. |
| oceanbase.CDB_OB_ARCHIVELOG_SUMMARY | This view displays the status of all log archiving in the history and current. |
| oceanbase.CDB_OB_RECOVER_TABLE_JOBS | This view displays information about table-level restore tasks. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOBS | This view displays information about table-level restore tasks. |
| oceanbase.CDB_OB_IMPORT_TABLE_JOBS | This view displays information about import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOBS | This view displays information about import tasks. |
| oceanbase.CDB_OB_IMPORT_TABLE_TASKS | This view displays records of table-level cross-tenant import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASKS | This view displays records of table-level import tasks. |
| oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY | This view displays the results of table-level restore tasks. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY | This view displays the results of table-level restore tasks. |
| oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY | This view displays the results of import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY | This view displays the results of import tasks. |
| oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY | This view displays the history records of table-level cross-tenant import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY | This view displays the history records of table-level cross-tenant import tasks. |
Statistics and histograms
| View name | Description |
|---|---|
| oceanbase.DBA_TAB_STATISTICS | This view displays the optimizer statistics of all tables in the database. |
| oceanbase.DBA_TAB_COL_STATISTICS | This view displays the column statistics and histogram information of all tables in the database. |
| oceanbase.DBA_PART_COL_STATISTICS | This view displays the column statistics and histogram information of all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_COL_STATISTICS | This view displays the column statistics and histogram information of all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_HISTOGRAMS | This view displays the histograms of all columns in all tables in the database. |
| oceanbase.DBA_PART_HISTOGRAMS | This view displays the histogram data (endpoints) of all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_HISTOGRAMS | This view displays the histogram data (endpoints) of all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_STATS_HISTORY | This view displays the table statistics history of all tables in the database. |
| oceanbase.DBA_IND_STATISTICS | This view displays the optimizer statistics of all indexes in the database. |
| oceanbase.DBA_TAB_MODIFICATIONS | This view displays the cumulative modification information of tables in the database. |
| oceanbase.CDB_TAB_COL_STATISTICS | This view displays the column-level statistics in the system tenant. |
| oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY | This view displays the historical execution status of table statistics collection. |
Tenant-related
| View name | Description |
|---|---|
| oceanbase.DBA_OBJECTS | This view displays all database objects in the database. The view definition is consistent with that of ALL_OBJECTS. |
| oceanbase.CDB_OBJECTS | This view displays the object information of all tenants in the system tenant. |
| oceanbase.DBA_OB_TENANTS | This view displays the basic information of all tenants. The information includes the system tenant, user-created tenants (user tenants), and the Meta tenant. You can distinguish the tenant types based on the TENANT_TYPE column. |
| oceanbase.DBA_OB_TENANT_JOBS | This view displays the task information at the tenant level. |
| oceanbase.CDB_OB_SYS_VARIABLES | This view displays the system variable information of all tenants in the system tenant. |
Resource-related views
| View name | Description |
|---|---|
| oceanbase.DBA_OB_RESOURCE_POOLS | This view displays resource pool information for all tenants. |
| oceanbase.DBA_OB_UNIT_JOBS | This view displays all unit-related tasks. |
| oceanbase.DBA_OB_UNITS | This view displays unit information for all tenants. |
| oceanbase.DBA_OB_UNIT_CONFIGS | This view displays unit specifications for all tenants. |
| oceanbase.DBA_OB_SEQUENCE_OBJECTS | This view displays all SEQUENCE objects in the database. |
Resource Manager-related views
| View name | Description |
|---|---|
| CDB_OB_RSRC_DIRECTIVES | This view displays various resource configuration parameters for all tenants in Resource Manager. |
I/O-related statistics
| View name | Description |
|---|---|
| CDB_OB_STORAGE_IO_USAGE | This view displays various I/O operations for all tenant objects in object storage and cloud disks. |
Replica and log-related
| View name | Description |
|---|---|
| oceanbase.CDB_OB_CS_REPLICA_STATS | This view displays the progress of converting tablets into columnar format in the log stream of C replicas on all OBServer nodes for all tenants. |
| oceanbase.CDB_OB_LS_LOCATIONS | This view displays the distribution of log stream (LS) replicas for all tenants. |
| oceanbase.CDB_OB_TABLEGROUPS | This view displays the metadata of table groups for all tenants under the sys tenant, mainly focusing on partition information. |
| oceanbase.CDB_OB_TABLEGROUP_PARTITIONS | This view displays the primary partition information of partitioned table groups for all tenants under the sys tenant. |
| oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS | This view displays the secondary partition information of partitioned table groups for all tenants under the sys tenant. |
| oceanbase.CDB_OB_TABLET_TO_LS | This view displays the list of tablets and their corresponding log stream information for all tenants under the sys tenant. |
| oceanbase.CDB_OB_TABLET_REPLICAS | This view displays all tablet replicas for the current tenant. Each tablet replica is uniquely identified by the composite key: <TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.CDB_PART_KEY_COLUMNS | This view displays the primary partition key information of partitioned objects (partitioned tables and indexes) for all tenants. |
| oceanbase.CDB_SUBPART_KEY_COLUMNS | This view displays the secondary partition key information of partitioned objects (partitioned tables and indexes) for all tenants. |
| oceanbase.DBA_IND_SUBPARTITIONS | This view displays information about all index subpartitions in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | This view displays the primary partition information of partitioned table groups. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | This view displays the secondary partition information of partitioned table groups. |
| oceanbase.DBA_OB_TABLEGROUPS | This view displays the metadata of table groups, mainly focusing on partition information. |
| oceanbase.DBA_OB_TABLET_REPLICAS | This view displays all tablet replicas for the current tenant. Each tablet replica is uniquely identified by the composite key: <TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.DBA_OB_TABLET_TO_LS | This view displays the list of tablets and their corresponding log stream information for the current tenant. |
| oceanbase.DBA_OB_LS_LOCATIONS | This view displays the distribution of log stream (LS) replicas for the current tenant. |
| oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO | This view displays information about data inconsistencies between tablet replicas. |
| oceanbase.CDB_OB_LS | This view displays the status and recovery progress of log streams. |
| oceanbase.DBA_OB_LS | This view displays the status and recovery progress of log streams. |
WR related
| View name | Description |
|---|---|
| oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY | This view displays the ASH data of all tenants. |
| oceanbase.CDB_WR_CONTROL | This view displays the WR-related configuration information. |
| oceanbase.CDB_WR_EVENT_NAME | This view displays the tenant-level wait event names of all tenants. |
| oceanbase.CDB_WR_SNAPSHOT | This view displays the SNAPSHOT information of all tenants. |
| oceanbase.CDB_WR_SQLSTAT | This view displays the basic performance statistics of SQL statements executed by all tenants. Each SQL statement is represented as a row (i.e., each unique combination of SQL_ID and Plan_Hash is a row). |
| oceanbase.CDB_WR_SQLTEXT | This view displays the SQL text collected by WR for all tenants. |
| oceanbase.CDB_WR_STATNAME | This view displays the names of system statistics for all tenants. |
| oceanbase.CDB_WR_SYS_TIME_MODEL | This view displays the WR data of the Time Model statistics for all tenants. |
| oceanbase.CDB_WR_SYSSTAT | This view displays the details of system statistics for all tenants. |
| oceanbase.CDB_WR_SYSTEM_EVENT | This view displays the tenant-level wait event information of all tenants. |
| oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY | This view displays the ASH data of the current tenant. |
| oceanbase.DBA_WR_CONTROL | This view displays the WR-related configuration information. |
| oceanbase.DBA_WR_EVENT_NAME | This view displays the tenant-level wait event names of the current tenant. |
| oceanbase.DBA_WR_SNAPSHOT | This view displays the SNAPSHOT information of the current tenant. |
| oceanbase.DBA_WR_SQLSTAT | This view displays the basic performance statistics of SQL statements executed by the current tenant. Each SQL statement is represented as a row (i.e., each unique combination of SQL_ID and Plan_Hash is a row). |
| oceanbase.DBA_WR_SQLTEXT | This view displays the SQL text collected by WR for the current tenant. |
| oceanbase.DBA_WR_STATNAME | This view displays the names of system statistics for the current tenant. |
| oceanbase.DBA_WR_SYS_TIME_MODEL | This view displays the WR data of the Time Model statistics for the current tenant. |
| oceanbase.DBA_WR_SYSSTAT | This view displays the details of system statistics for the current tenant. |
| oceanbase.DBA_WR_SYSTEM_EVENT | This view displays the persistent tenant-level wait event information of the current tenant. |
Foreign keys
| View name | Description |
|---|---|
| information_schema.INNODB_SYS_FOREIGN | This view displays metadata information about InnoDB foreign keys. It is equivalent to the SYS_FOREIGN table in the InnoDB data dictionary.
NoteThis view is available only for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_SYS_FOREIGN_COLS | This view displays status information about InnoDB foreign key columns. It is equivalent to the SYS_FOREIGN_COLS table in the InnoDB data dictionary.
NoteThis view is available only for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
OBKV
| View name | Description |
|---|---|
| oceanbase.CDB_OB_KV_TTL_TASKS | This view displays all TTL tasks that are being executed by all tenants in the sys tenant. |
| oceanbase.CDB_OB_KV_TTL_TASK_HISTORY | This view displays all historical TTL tasks of all tenants in the sys tenant. |
| oceanbase.DBA_OB_KV_TTL_TASKS | This view displays all TTL tasks that are being executed by the current tenant. |
| oceanbase.DBA_OB_KV_TTL_TASK_HISTORY | This view displays all historical TTL tasks of the current tenant. |
| V$OB_KV_CLIENT_INFO | This view displays the configuration parameters of all OBKV tenant clients connected to the current node. |
| GV$OB_KV_CLIENT_INFO | This view displays the configuration parameters of all OBKV tenant clients. |
Overview of performance views
ASH-related views
| View Name | Description |
|---|---|
| GV$ACTIVE_SESSION_HISTORY | This view displays the active session history. |
| V$ACTIVE_SESSION_HISTORY | This view displays the active session history. |
| GV$OB_ACTIVE_SESSION_HISTORY | This view displays the active session history for all tenants and all OBServer nodes. |
| V$OB_ACTIVE_SESSION_HISTORY | This view displays the active session history for all tenants and the current OBServer node. |
Partition-related views
| View Name | Description |
|---|---|
| V$OB_DYNAMIC_PARTITION_TABLES | This view displays the dynamic partition table information for all tenants. |
Shared storage-related views
| View Name | Description |
|---|---|
| GV$OB_STORAGE_CACHE_TASKS | This view displays the cache task information for all tenants and all OBServer nodes. |
| V$OB_STORAGE_CACHE_TASKS | This view displays the cache task information for all tenants and the current OBServer node. |
| GV$OB_TABLET_LOCAL_CACHE | This view displays the overall cache information for all tenants and all OBServer nodes. |
| V$OB_TABLET_LOCAL_CACHE | This view displays the overall cache information for all tenants and the current OBServer node. |
| GV$OB_SERVER_STORAGE | This view displays the object storage information for the shared storage cluster on all OBServer nodes. |
| V$OB_SERVER_STORAGE | This view displays the object storage information for the shared storage cluster on the current OBServer node. |
Monitoring-related statistics
| View Name | Description |
|---|---|
| GV$OB_DTL_INTERM_RESULT_MONITOR | This view displays the monitoring information for the DTL intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | This view displays the monitoring information for the DTL intermediate result manager. |
I/O-related statistics
| View Name | Purpose |
|---|---|
| GV$OB_SHARED_STORAGE_QUOTA | This view displays IO access resource information on all OBServer nodes. |
| V$OB_SHARED_STORAGE_QUOTA | This view displays IO access resource information on the current OBServer node. |
| GV$OB_IO_CALIBRATION_STATUS | This view displays the execution status of I/O calibration tasks. |
| V$OB_IO_CALIBRATION_STATUS | This view displays the execution status of I/O calibration tasks. |
| GV$OB_IO_BENCHMARK | This view displays the disk calibration data used by the I/O module. |
| V$OB_IO_BENCHMARK | This view displays the disk calibration data used by the I/O module. |
Cache-related statistics
| View Name | Purpose |
|---|---|
| GV$OB_SS_LOCAL_CACHE | This view displays the relevant metrics of various cache data in the local cache of each OBServer node for all tenants in shared storage mode. |
| V$OB_SS_LOCAL_CACHE | This view displays the relevant metrics of various cache data in the local cache of the current OBServer node for all tenants in shared storage mode. |
| GV$OB_MEMORY | This view displays tenant-level memory statistics. |
| V$OB_MEMORY | This view displays tenant-level memory statistics. |
| GV$OB_MEMSTORE | This view displays the memory usage of MemTables for all tenants on all servers. |
| V$OB_MEMSTORE | This view displays tenant-level MemStore statistics. |
| GV$OB_MEMSTORE_INFO | This view displays detailed information about MemTables for all partitions of all tenants on all servers. |
| V$OB_MEMSTORE_INFO | This view displays detailed information about MemTables for all partitions of all tenants on all servers. |
| GV$OB_SSTABLES | This view displays the SSTable information for tenants. |
| V$OB_SSTABLES | This view displays the SSTable information for tenants. |
| GV$OB_TENANT_MEMORY | This view displays the memory usage of each tenant in the cluster. |
| V$OB_TENANT_MEMORY | This view displays the memory usage of each tenant in the current observer process. |
Resource Manager
| View Name | Purpose |
|---|---|
| GV$OB_GROUP_IO_STAT | This view displays the real-time status of each resource group on all OBServer nodes for all tenants. |
| GV$OB_FUNCTION_IO_STAT | This view displays the I/O statistics at the function level on all OBServer nodes for all tenants. |
| V$OB_GROUP_IO_STAT | This view displays the real-time status of each resource group on the current OBServer node for all tenants. |
| V$OB_FUNCTION_IO_STAT | This view displays the I/O statistics at the function level on the current OBServer node for all tenants. |
Event-related statistics
| View Name | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | This view displays the OBServer-level major compaction progress of the tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | This view displays the major compaction suggestions. |
| GV$OB_PROCESSLIST | This view displays the session information of all OBServer nodes in the tenant. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | This view displays the major compaction diagnostic information. |
| GV$OB_TABLET_COMPACTION_HISTORY | This view displays the historical information of tablet-level major compaction. |
| GV$OB_TABLET_COMPACTION_PROGRESS | This view displays the progress of tablet-level major compaction. |
| GV$OB_TRANSACTION_PARTICIPANTS | This view displays the transaction participant information of all OBServer nodes. |
| GV$SESSION_EVENT | This view displays the session-level waiting events of all OBServer nodes in the cluster. |
| GV$SESSION_WAIT | This view displays the current or last waiting events of all sessions on all servers, including the waiting event name and waiting time. |
| GV$SESSION_WAIT_HISTORY | This view displays the information of the last 10 waiting events of all sessions on all servers. |
| GV$SYSTEM_EVENT | This view displays the waiting events of all tenants in the cluster. |
| GV$SESSTAT | This view displays the session-level statistical events of all OBServer nodes. |
| GV$SYSSTAT | This view displays the tenant-level statistical events of all servers. |
| V$OB_COMPACTION_PROGRESS | This view displays the server-level major compaction progress of the tenant. |
| V$OB_COMPACTION_SUGGESTIONS | This view displays the major compaction suggestions. |
| V$OB_PROCESSLIST | This view displays the session information of the current OBServer node. |
| V$OB_COMPACTION_DIAGNOSE_INFO | This view displays the major compaction diagnostic information. |
| V$OB_TABLET_COMPACTION_HISTORY | This view displays the historical information of tablet-level major compaction. |
| V$OB_TABLET_COMPACTION_PROGRESS | This view displays the progress of tablet-level major compaction. |
| V$OB_TRANSACTION_PARTICIPANTS | This view displays transaction participant information on all OBServer nodes. |
| V$STATNAME | This view displays the definitions of all statistics events. |
| V$EVENT_NAME | This view displays the definitions of all statistics events on the current OBServer node. |
| V$SESSION_WAIT | This view displays the details of the current waiting events for each session. Each waiting event has three parameters, which record the corresponding values. |
| V$SESSION_WAIT_HISTORY | This view displays the details of the current waiting events for each session, including the last 10 waiting events. |
| V$SESSTAT | This view displays the statistics events at the session level. |
| V$SYSSTAT | This view displays the statistics events at the tenant level on the current server. |
| V$SYSTEM_EVENT | This view displays the statistics events at the tenant level. |
| GV$SESSION_LONGOPS | This view displays the execution status and progress of DDL operations in the cluster. |
| V$SESSION_LONGOPS | This view displays the execution status and progress of DDL operations on the current OBServer node. |
SQL-related statistics
| View name | Description |
|---|---|
| GV$OB_PLAN_CACHE_STAT | This view displays the overall status of each plan cache on all OBServer nodes for the current tenant. |
| V$OB_PLAN_CACHE_STAT | This view records the overall status of each plan cache on all servers for the current tenant. |
| GV$OB_PLAN_CACHE_PLAN_STAT | This view records the status of each cached object in the plan cache on all servers for the current tenant. |
| V$OB_PLAN_CACHE_PLAN_STAT | This view records the status of each cached object in the plan cache on the current server for the current tenant. |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | This view displays the physical execution plans cached in the plan cache on all servers. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | This view displays the physical execution plans cached in the plan cache on the current server. |
| GV$OB_PS_STAT | This view monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| V$OB_PS_STAT | This view monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| GV$OB_PS_ITEM_INFO | This view provides monitoring functionality for prepared statements, containing basic information about all prepared statements in the PS cache. |
| V$OB_PS_ITEM_INFO | This view provides monitoring functionality for prepared statements, containing basic information about all prepared statements in the PS cache. |
| GV$OB_PX_P2P_DATAHUB | This view displays information about data transfer operations during parallel execution. |
| GV$OB_PX_TARGET_MONITOR | This view displays the usage of PX threads on all OBServer nodes. |
| V$OB_PX_TARGET_MONITOR | This view displays the usage of PX threads on the OBServer node. |
| GV$OB_SQL_AUDIT | This view displays statistics such as the source and execution status of each SQL request on all servers. |
| V$OB_SQL_AUDIT | This view displays statistics such as the source and execution status of each SQL request on the current server. |
| GV$SQL_PLAN_MONITOR | This view displays statistics on the plan level for slow queries on all OBServer nodes. Each slow query has a corresponding statistics record, and the trace information of the plan is also recorded. |
| V$SQL_PLAN_MONITOR | This view displays statistics on the operation level for slow queries. Each operation has a corresponding statistics record. |
| V$SQL_MONITOR_STATNAME | This view displays the meaning of the numbers in the OTHERSTAT_X_ID column of GV$SQL_PLAN_MONITOR. |
| GV$OB_FLT_TRACE_CONFIG | This view displays the diagnostic information of full-link tracing. |
Statistics related to logs
| View name | Description |
|---|---|
| GV$OB_LOG_STAT | This view displays the status of Palf. |
| GV$OB_LS_SNAPSHOTS | This view displays the information about log stream snapshots stored in the persistent storage of all units. |
| V$OB_LOG_STAT | This view displays the status of Palf. |
Statistics related to network
| View name | Description |
|---|---|
| GV$OB_RPC_OUTGOING | This view displays the statistics about RPCs sent from all OBServer nodes. |
| GV$OB_RPC_INCOMING | This view displays the statistics about RPCs received by all OBServer nodes. |
| V$OB_RPC_OUTGOING | This view displays the statistics about the RPC data sent from all tenants on OBServer nodes. |
| V$OB_RPC_INCOMING | This view displays the statistics about the RPC data received by all tenants on OBServer nodes. |
Session-related views
| View name | Description |
|---|---|
| GV$OB_SESSION | This view records the session information created on all servers. |
Database-related statistics
| View | Description |
|---|---|
| GV$OB_KVCACHE | This view displays the KVCACHE information on all OBServer nodes. |
| GV$OB_PARAMETERS | This view displays the configuration information on all OBServer nodes where the tenant is located. |
| GV$OB_SERVER_SCHEMA_INFO | This view displays the schema information on all servers. |
| GV$OB_SERVERS | This view displays the information about all OBServer nodes. |
| GV$OB_UNITS | This view displays the unit information of the OBServer node where the tenant is located. The system tenant can view the unit information of all OBServer nodes in the cluster. |
| V$OB_KVCACHE | This view displays the KVCACHE information on all OBServer nodes. |
| V$OB_PARAMETERS | This view displays the configuration information on the OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | This view displays the schema information on all servers. |
| V$OB_SERVERS | This view displays the information about the OBServer node. |
| V$OB_UNITS | This view displays the unit information of the OBServer node. |
| GV$DML_STATS | This view displays the DML information in the current user table. |
| V$DML_STATS | This view displays the DML information in the current user table. |
| V$OB_COMPATIBILITY_CONTROL | This view displays the features that can be controlled for compatibility with the OceanBase Database release. |
Dump-related statistics
| View | Description |
|---|---|
| GV$OB_MERGE_INFO | This view displays the statistics about completed compactions in the OceanBase cluster. |
| V$OB_MERGE_INFO | This view displays the statistics about completed compactions in the OceanBase cluster. |
Thread-related statistics
| View | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | In parallel execution scenarios, this view displays the execution information of each thread. |
| V$OB_PX_WORKER_STAT | In parallel execution scenarios, this view displays the execution information of each thread. |
| GV$OB_TENANT_RUNTIME_INFO | This view displays the information about queues and thread limits in tenant threads. |
| V$OB_TENANT_RUNTIME_INFO | This view displays the information about queues and thread limits in tenant threads. |
Statistics related to workarea
| View name | Purpose |
|---|---|
| GV$SQL_WORKAREA | This view displays the workarea statistics of all operators that were previously managed by SQL automatic memory management. |
| GV$SQL_WORKAREA_ACTIVE | This view displays the workarea information of the active operator. |
| GV$SQL_WORKAREA_HISTOGRAM | This view displays the statistics of all previous workarea executions, such as the number of times full in-memory processing occurred between 1 M and 2 M, and the number of one-pass operations. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | This view queries some overall information about the SQL workarea, such as the maximum available memory, current used memory, and current held memory. |
| V$SQL_WORKAREA | This view displays the workarea statistics of all operators that were previously managed by SQL automatic memory management. |
| V$SQL_WORKAREA_ACTIVE | This view displays the workarea information of the active operator. |
| V$SQL_WORKAREA_HISTOGRAM | This view displays the statistics of all previous workarea executions, such as the number of times full in-memory processing occurred between 1 M and 2 M, and the number of one-pass operations. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | This view queries some overall information about the SQL workarea, including the maximum available memory, current used memory, and current held memory. |
WR related
| View name | Description |
|---|---|
| GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM | This view displays the histogram information of Query execution time on all nodes for all tenants. |
| GV$OB_RES_MGR_SYSSTAT | This view displays the statistics of resource groups on all OBServer nodes for all tenants. |
| GV$OB_SESS_TIME_MODEL | This view displays the session-level Time Model statistics in the cluster. |
| GV$OB_SQLSTAT | This view displays the basic performance statistics of SQL statements in the cluster. Each SQL statement is a row (i.e., each unique combination of SQL_ID and Plan_Hash is a row). |
| GV$OB_SYS_TIME_MODEL | This view displays the tenant-level Time Model statistics in the cluster. |
| V$OB_QUERY_RESPONSE_TIME_HISTOGRAM | This view displays the histogram information of Query execution time on the current node for all tenants. |
| V$OB_RES_MGR_SYSSTAT | This view displays the statistics of resource groups on the current OBServer node for all tenants. |
| V$OB_SESS_TIME_MODEL | This view displays the session-level Time Model statistics on the current node. |
| V$OB_SQLSTAT | This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is a row (i.e., each unique combination of SQL_ID and Plan_Hash is a row). |
| V$OB_SYS_TIME_MODEL | This view displays the tenant-level Time Model statistics on the current node. |
Statistics related to encrypted tables
| View name | Description |
|---|---|
| V$OB_ENCRYPTED_TABLES | This view displays the encryption status of tables with encryption enabled. |
| V$ENCRYPTED_TABLESPACES | This view displays the encryption status of tablespaces with encryption enabled. |
Statistics related to transactions
| View name | Description |
|---|---|
| GV$LATCH | This view displays the Latch information of all OBServer nodes in the cluster. |
| V$LATCH | This view displays the Latch information of all OBServer nodes in the cluster. |
Views in a MySQL tenant
Dictionary views overview
Help commands
| View name | Description |
|---|---|
| mysql.help_topic | This view, together with the mysql.help_category, mysql.help_relation, and mysql.help_keyword views, generates help commands. |
| mysql.help_category | This view, together with the mysql.help_relation, mysql.help_topic, and mysql.help_keyword views, generates help commands. |
| mysql.help_keyword | This view, together with the mysql.help_relation, mysql.help_topic, and mysql.help_category views, generates help commands. |
| mysql.help_relation | This view, together with the mysql.help_category, mysql.help_topic, and mysql.help_keyword views, generates help commands. |
SPM-related views
| View name | Description |
|---|---|
| oceanbase.DBA_SQL_PLAN_BASELINES | This view displays the plan baselines of SQL statements in SPM. |
| oceanbase.DBA_SQL_MANAGEMENT_CONFIG | This view displays the configuration parameters in SPM. |
Privilege-related views
| View name | Description |
|---|---|
| mysql.db | This view displays the database-level privileges (VIRTUAL_TABLE). |
| mysql.user | This view records the user-level privileges (VIRTUAL_TABLE). |
| information_schema.COLUMN_PRIVILEGES | This view displays the column privileges. |
| information_schema.SCHEMA_PRIVILEGES | This view describes the database privileges. |
| information_schema.TABLE_PRIVILEGES | This view records the table privileges. |
| information_schema.USER_PRIVILEGES | This view records the user privileges. |
OBKV-related views
| View name | Description |
|---|---|
| oceanbase.DBA_OB_KV_TTL_TASKS | This view displays the TTL tasks that are being executed by the current tenant. |
| oceanbase.DBA_OB_KV_TTL_TASK_HISTORY | This view displays the historical TTL tasks of the current tenant. |
| V$OB_KV_CLIENT_INFO | This view displays the configuration parameters of the client connections to the OBKV tenant on the current node. |
| GV$OB_KV_CLIENT_INFO | This view displays the configuration parameters of the client connections to the OBKV tenant. |
Scheduler
| View name | Description |
|---|---|
| oceanbase.DBA_SCHEDULER_JOBS | This view displays the information about all scheduler jobs in the database. |
Storage-related
| View Name | Description |
|---|---|
| mysql.proc | This view displays information about stored procedures. |
| information_schema.ENGINES | This view records information about storage engines. |
| information_schema.PARAMETERS | This view provides information about stored procedure parameters and return values. |
| information_schema.ROUTINES | This view provides information about stored procedures. |
Time zone-related
| View Name | Description |
|---|---|
| mysql.time_zone | This view displays information about time zones (SYSTEM_VIEW). |
| mysql.time_zone_name | This view records the names of time zones (SYSTEM_VIEW). |
| mysql.time_zone_transition | mysql.time_zone_transition is a system view that records information about time zone transitions. |
| mysql.time_zone_transition_type | This view records information about time zone transition types (SYSTEM_VIEW). |
Character set
| View Name | Description |
|---|---|
| information_schema.CHARACTER_SETS | This view records information about character sets in OceanBase Database. |
| information_schema.COLLATIONS | This view records information about collation methods for each character set. |
| information_schema.COLLATION_CHARACTER_SET_APPLICABILITY | This view records the correspondence between character sets and collations. |
Tables and columns
| View name | Description |
|---|---|
| information_schema.COLUMNS | Records column information. |
| information_schema.STATISTICS | Records table index information. |
| information_schema.TABLES | Records table information. |
| information_schema.VIEWS | Records view information. |
| information_schema.VIEW_TABLE_USAGE | Displays information about tables and views used in the view definition. |
| oceanbase.DBA_OB_TABLEGROUP_TABLES | Displays the association between a tablegroup and a table. Tables not in a tablegroup are not displayed. |
| oceanbase.DBA_PART_KEY_COLUMNS | Displays columns in the partitioning key of all partition objects in the database. |
| oceanbase.DBA_SUBPART_KEY_COLUMNS | Displays columns in the subpartitioning key of all partition objects in the database. |
| oceanbase.DBA_OB_TABLE_LOCATIONS | Displays the location of a table or partition, including system tables, user tables, and index tables. |
| information_schema.TABLESPACES | Information about tablespaces.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can query only the table structure. |
Materialized view-related views
| View | Purpose |
|---|---|
| oceanbase.DBA_MVIEW_DEPS | This view displays the dependencies of materialized views in the current tenant. |
| oceanbase.DBA_MVIEW_LOGS | This view displays the logs of materialized views. |
| oceanbase.DBA_MVIEW_RUNNING_JOBS | This view displays the running materialized view-related tasks, including refresh tasks and MLOG cleanup tasks, in the current tenant. |
| oceanbase.DBA_MVIEWS | This view displays the information of all materialized views. |
| oceanbase.DBA_MVREF_CHANGE_STATS | This view displays the statistics related to materialized view refreshes. |
| oceanbase.DBA_MVREF_RUN_STATS | This view displays the information about each refresh run of a materialized view. Each refresh run is identified by a REFRESH_ID. |
| oceanbase.DBA_MVREF_STATS | This view displays the basic timing statistics of materialized view refreshes. |
| oceanbase.DBA_MVREF_STATS_PARAMS | This view displays the refresh statistics attributes associated with each materialized view. |
| oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS | This view displays the system-level default values of the refresh statistics attributes. |
| oceanbase.DBA_MVREF_STMT_STATS | This view displays the information about the refresh statements. |
InnoDB storage engine
| View name | Description |
|---|---|
| information_schema.INNODB_LOCK_WAITS | This view displays information about lock transactions and lock objects that are waiting for lock conflicts.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_LOCKS | This view displays information about all current locks (waiting and held).
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.NDB_TRANSID_MYSQL_CONNECTION_MAP | This view displays the mapping relationship between NDB transactions, NDB transaction coordinators, and MySQL servers that are attached as API nodes to the NDB cluster.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_TRX | This view displays information about active transactions.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_BUFFER_PAGE | This view displays information about all cached pages in the buffer pool.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_BUFFER_PAGE_LRU | This view displays the LRU-sorted information about pages in the InnoDB buffer pool.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_BUFFER_POOL_STATS | This view displays statistics about the InnoDB buffer pool.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_CMP | This view displays the operation status of InnoDB tables that are compressed.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_CMP_PER_INDEX | This view displays information about operations on InnoDB tables and indexes that are compressed.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_CMP_PER_INDEX_RESET | This view displays the operation reset time of InnoDB tables and indexes that are compressed.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_CMP_RESET | This view displays the operation status of InnoDB tables that are compressed.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_CMPMEM | This view displays the status of compressed pages in the InnoDB buffer pool.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_CMPMEM_RESET | This view displays the reset time of compressed pages in the InnoDB buffer pool.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_SYS_DATAFILES | This view displays the data file paths of InnoDB files for each table and general tablespace.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_SYS_INDEXES | This view displays metadata about InnoDB indexes.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_SYS_TABLES | This view displays metadata about InnoDB tables.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_SYS_TABLESPACES | This view displays metadata about InnoDB table files and general tablespaces.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_SYS_TABLESTATS | This view displays low-level status information about InnoDB tables.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_SYS_VIRTUAL | This view displays metadata about InnoDB virtual generated columns.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_TEMP_TABLE_INFO | This view displays information about active InnoDB temporary tables created by users.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
| information_schema.INNODB_METRICS | This view displays InnoDB performance information.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported. You can only query the table structure. |
Outline
| View name | Description |
|---|---|
| oceanbase.DBA_OB_OUTLINES | This view displays the execution plan outline information of the current tenant. |
| oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL | This view displays the outline information related to the throttling rules of the current tenant. |
| oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY | This view displays the outline information of the execution plan and throttling rules of the current tenant. |
| DBA_OB_FORMAT_OUTLINES | This view records the details of the current tenant's format outline. |
Database basic information
| View name | Description |
|---|---|
| information_schema.GLOBAL_STATUS | This view records the global status information of OceanBase Database. |
| information_schema.GLOBAL_VARIABLES | This view records the global variable information. |
| information_schema.SCHEMATA | This view records the database metadata. |
| oceanbase.DBA_OB_DATABASES | This view displays the database metadata of the current tenant. |
| oceanbase.DBA_OB_MAJOR_COMPACTION | This view displays the global information of the current tenant. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | This view displays the information of major compactions in each zone of the current tenant. |
| oceanbase.DBA_OB_FREEZE_INFO | This view displays the version information generated by major freeze. |
| information_schema.events | This view records all event information. |
Partition-related views
| View name | Description |
|---|---|
| information_schema.PARTITIONS | Records partition information. |
| oceanbase.DBA_IND_PARTITIONS | Displays the information about the primary partitions of an index. |
| oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES | Displays the information about dynamic partition tables in the current tenant. |
| oceanbase.DBA_PART_INDEXES | Displays the information about all partition indexes. |
| oceanbase.DBA_PART_TABLES | Displays the information about user table partitions. |
| oceanbase.DBA_TAB_PARTITIONS | Displays the information about the multi-level partitions, storage parameters, and statistics of the partitions that the current user can access. |
| oceanbase.DBA_TAB_SUBPARTITIONS | Displays the information about subpartitions, including the subpartition name, table name, partition name, storage attributes, and statistics generated by the DBMS_STATS package. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | Displays the information about all subpartition templates. |
Load balancing-related views
| View name | Description |
|---|---|
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS | Displays the information about the transfer partition tasks that are being processed in the current tenant. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the information about the transfer partition tasks that have been executed in the current tenant. |
Thread-related views
| View name | Description |
|---|---|
| information_schema.PROCESSLIST | Displays the information about running threads. |
Constraints
| View name | Description |
|---|---|
| information_schema.CHECK_CONSTRAINTS | Displays the constraint information about tables and columns during the CREATE TABLE operation. |
| information_schema.KEY_COLUMN_USAGE | Records the constraint information about keys in a column. |
| information_schema.REFERENTIAL_CONSTRAINTS | Displays the metadata about foreign key constraints. |
| information_schema.TABLE_CONSTRAINTS | Describes the information about table constraints. |
Full-text index related
| View name | Description |
|---|---|
| information_schema.INNODB_FT_BEING_DELETED | This view displays information about full-text indexes that are being deleted.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_FT_CONFIG | This view displays the configuration information of the InnoDB full-text search engine.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_FT_DELETED | This view displays information about full-text indexes that have been marked for deletion.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_FT_INDEX_CACHE | This view displays the cache status information of InnoDB full-text indexes.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
| information_schema.INNODB_SYS_FIELDS | This view displays the metadata information of key columns (fields) of InnoDB indexes, which is equivalent to the information in the SYS_FIELDS table of the InnoDB data dictionary.
NoteThis view is only used for compatibility with MySQL 5.7. The related features are not supported, and you can only query the table structure. |
Session related
| View name | Description |
|---|---|
| information_schema.SESSION_STATUS | This view records the status information of a session, such as the number of active connections and the database uptime. |
| information_schema.SESSION_VARIABLES | This view records the variable information of a session. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | This view displays the history of deadlock events. In non-root tenants, this view displays the history of deadlock events for the tenant. |
User login related
| View name | Description |
|---|---|
| information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS | This view displays the number of failed login attempts for different users. |
Backup and restore
| View Name | Description |
|---|---|
| oceanbase.DBA_OB_BACKUP_JOBS | This view displays the backup jobs of the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOB_HISTORY | This view displays the history of the backup jobs of the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASKS | This view displays the history of the backup jobs of the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASK_HISTORY | This view displays the history of the task-level backup jobs of the current tenant. |
| oceanbase.DBA_OB_BACKUP_SET_FILES | This view displays the status of the files in the backup set. |
| oceanbase.DBA_OB_RESTORE_PROGRESS | This view displays the progress of the ongoing restore task. |
| oceanbase.DBA_OB_RESTORE_HISTORY | This view displays the history of the completed restore tasks. |
| oceanbase.DBA_OB_ARCHIVE_DEST | This view displays the archive path configuration. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | This view displays the information about the backup destination used for backup and restore in the current tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY | This view displays the history of the information about the backup destination used for backup and restore in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_POLICY | This view displays the deletion policy set for the tenant for expired or automatic deletion. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOBS | This view displays the execution progress of the tenant-level backup deletion jobs. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY | This view displays the history of the backup deletion jobs executed in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | This view displays the information about the backup_set/backup_piece deletion tasks being executed in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY | This view displays the history of the backup_set/backup_piece deletion tasks completed in the current tenant. |
| oceanbase.DBA_OB_ARCHIVELOG | This view displays the status of the log backups on each path. |
| oceanbase.DBA_OB_ARCHIVELOG_SUMMARY | This view displays the status of all log backups in the history and current. |
| oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES | This view displays the status of the pieces in the backup set. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOBS | This view displays information about table-level recovery tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOBS | This view displays information about import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASKS | This view displays records of table-level import tasks. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY | This view displays the results of table-level recovery tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY | This view displays the results of import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY | This view displays the history of cross-tenant table-level import tasks. |
Statistics and histograms
| View name | Description |
|---|---|
| oceanbase.DBA_TAB_STATISTICS | This view displays the optimizer statistics of all tables in the database. |
| oceanbase.DBA_TAB_COL_STATISTICS | This view displays the column statistics and histogram information of all tables in the database. |
| oceanbase.DBA_PART_COL_STATISTICS | This view displays the column statistics and histogram information of all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_COL_STATISTICS | This view displays the column statistics and histogram information of all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_HISTOGRAMS | This view displays the histograms of all columns in all tables in the database. |
| oceanbase.DBA_PART_HISTOGRAMS | This view displays the histogram data (endpoints) of all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_HISTOGRAMS | This view displays the histogram data (endpoints) of all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_STATS_HISTORY | This view displays the table statistics history of all tables in the database. |
| oceanbase.DBA_IND_STATISTICS | This view displays the optimizer statistics of all indexes in the database. |
| oceanbase.DBA_TAB_MODIFICATIONS | This view displays the cumulative modification information of tables in the database. |
| information_schema.QUERY_RESPONSE_TIME | This view displays the histogram data (such as response time) for Prometheus monitoring. |
| oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY | This view displays the historical execution information of statistics collection. |
Tenant-related
| View name | Description |
|---|---|
| oceanbase.DBA_OBJECTS | This view displays all database objects in the database. The view definition is consistent with that of ALL_OBJECTS. |
| oceanbase.DBA_OB_TENANTS | This view displays the basic information of all tenants. The tenants include the sys tenant, user-created tenants (user tenants), and the meta tenant. You can use the TENANT_TYPE column to distinguish the types of tenants. |
Resource-related
| View name | Description |
|---|---|
| oceanbase.DBA_OB_SEQUENCE_OBJECTS | This view displays all SEQUENCEs in the database. |
Resource Manager-related
| View name | Purpose |
|---|---|
| DBA_OB_RSRC_DIRECTIVES | This view displays the resource configuration parameters of the current tenant in Resource Manager. |
| DBA_OB_RSRC_IO_DIRECTIVES | This view displays the IO resource configuration of the current tenant in Resource Manager. |
| DBA_RSRC_GROUP_MAPPINGS | This view displays the binding relationship between users and resource groups. |
| DBA_RSRC_CONSUMER_GROUPS | This view displays the information of all resource groups in the database. |
| DBA_RSRC_PLANS | This view displays all resource management plans defined by the system. |
| DBA_RSRC_PLAN_DIRECTIVES | This view displays the detailed information of each resource plan directive in the database. |
I/O-related statistics
| View name | Purpose |
|---|---|
| DBA_OB_STORAGE_IO_USAGE | This view displays the I/O operations of the current tenant for object storage and cloud disks. |
Replica and log-related
| View name | Purpose |
|---|---|
| oceanbase.DBA_OB_CS_REPLICA_STATS | This view displays the progress of converting tablets to columnar storage in the log stream of C replicas on each OBServer node of the current tenant. |
| oceanbase.DBA_IND_SUBPARTITIONS | This view displays the information of all index subpartitions in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | This view displays the primary partitions of a partitioned table group. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | This view displays the secondary partitions of a partitioned table group. |
| oceanbase.DBA_OB_TABLEGROUPS | This view displays the metadata of a table group, mainly the partition information of the table group. |
| oceanbase.DBA_OB_TABLET_REPLICAS | This view displays all tablet replicas of the current tenant. Each tablet replica is uniquely identified by the joint key: <TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.DBA_OB_TABLET_TO_LS | This view displays the list of all tablets of the current tenant and the log stream information to which each tablet belongs. |
| oceanbase.DBA_OB_LS_LOCATIONS | This view displays the replica distribution information of log streams (LS) of the current tenant. |
WR-related
| View name | Purpose |
|---|---|
| oceanbase.DBA_WR_SNAPSHOT | This view displays the SNAPSHOT information of the current tenant. |
| oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY | This view displays the ASH data of the current tenant. |
| oceanbase.DBA_WR_STATNAME | This view displays the names of the system statistics of the current tenant. |
| oceanbase.DBA_WR_SYSSTAT | This view displays the details of the system statistics of the current tenant. |
| oceanbase.DBA_WR_CONTROL | This view displays the WR-related configuration information. |
| oceanbase.DBA_WR_SYSTEM_EVENT | This view displays the tenant-level wait event information of the current tenant. |
| oceanbase.DBA_WR_EVENT_NAME | This view displays the tenant-level wait event names of the current tenant. |
| oceanbase.DBA_WR_SQLTEXT | This view displays the SQL text collected by WR of the current tenant. |
| oceanbase.DBA_WR_SQLSTAT | This view displays the basic performance statistics of the SQL statements executed by the current tenant. Each SQL statement is displayed as a row (that is, each unique combination of SQL_ID and Plan_Hash is displayed as a row). |
| oceanbase.DBA_WR_SYS_TIME_MODEL | This view displays the WR data of the Time Model statistics of the current tenant. |
Foreign key-related
| View name | Purpose |
|---|---|
| information_schema.INNODB_SYS_FOREIGN | This view displays the metadata information about InnoDB foreign keys, which is equivalent to the information in the SYS_FOREIGN table of the InnoDB data dictionary.
NoteThis view is available only for compatibility with MySQL 5.7. You can query only the table structure. |
| information_schema.INNODB_SYS_FOREIGN_COLS | This view displays the status information about InnoDB foreign key columns, which is equivalent to the information in the SYS_FOREIGN_COLS table of the InnoDB data dictionary.
NoteThis view is available only for compatibility with MySQL 5.7. You can query only the table structure. |
Overview of performance views
ASH related
| View name | Purpose |
|---|---|
| GV$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$OB_ACTIVE_SESSION_HISTORY | Displays the active session history of the current OBServer node in the current tenant. |
| GV$OB_ACTIVE_SESSION_HISTORY | Displays the active session history of all OBServer nodes in the current tenant. |
Partitioning related
| View name | Purpose |
|---|---|
| V$OB_DYNAMIC_PARTITION_TABLES | Displays the dynamic partition tables of the current tenant. |
Shared storage related
| View name | Purpose |
|---|---|
| GV$OB_STORAGE_CACHE_TASKS | Displays the cache tasks of the current tenant on all OBServer nodes. |
| V$OB_STORAGE_CACHE_TASKS | Displays the cache tasks of the current tenant on the current OBServer node. |
| GV$OB_TABLET_LOCAL_CACHE | Displays the overall cache status of the current tenant on all OBServer nodes. |
| V$OB_TABLET_LOCAL_CACHE | Displays the overall cache status of the current tenant on the current OBServer node. |
Event-related statistics
| View name | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | This view displays the OBServer-level major compaction progress of a tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | This view displays the major compaction suggestions. |
| GV$OB_PROCESSLIST | This view displays the session information of all OBServer nodes where the tenant resides. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | This view displays the major compaction diagnostic information. |
| GV$OB_TABLET_COMPACTION_HISTORY | This view displays the historical information about tablet-level major compactions. |
| GV$OB_TABLET_COMPACTION_PROGRESS | This view displays the progress of tablet-level major compactions. |
| GV$OB_TRANSACTION_PARTICIPANTS | This view displays the transaction participant information on all OBServer nodes. |
| GV$SESSION_EVENT | This view displays the session-level waiting events on all OBServer nodes in the cluster. |
| GV$SESSION_WAIT | This view displays the information about the current or last waiting events of all sessions on all servers, including the waiting event name and waiting duration. |
| GV$SESSION_WAIT_HISTORY | This view displays the information about the last 10 waiting events of all sessions on all servers. |
| GV$SYSTEM_EVENT | This view displays the waiting events at the tenant level in the cluster. |
| GV$SESSTAT | This view displays the session-level statistical events on all OBServer nodes. |
| GV$SYSSTAT | This view displays the tenant-level statistical events on all servers. |
| V$OB_COMPACTION_PROGRESS | This view displays the server-level major compaction progress of a tenant. |
| V$OB_COMPACTION_SUGGESTIONS | This view displays the major compaction suggestions. |
| V$OB_PROCESSLIST | This view displays the session information of the current OBServer node. |
| V$OB_COMPACTION_DIAGNOSE_INFO | This view displays the major compaction diagnostic information. |
| V$OB_TABLET_COMPACTION_HISTORY | This view displays the historical information about tablet-level major compactions. |
| V$OB_TABLET_COMPACTION_PROGRESS | This view displays the progress of tablet-level major compactions. |
| V$OB_TRANSACTION_PARTICIPANTS | This view displays the transaction participants on all OBServer nodes. |
| V$STATNAME | This view displays the definitions of all statistical events. |
| V$EVENT_NAME | This view displays the definitions of all statistical events on the current OBServer node. |
| V$SESSION_WAIT | This view displays the details of the current waiting events for each session. Each waiting event has three parameters, which record the corresponding values. |
| V$SESSION_WAIT_HISTORY | This view displays the details of the current waiting events for each session, including the last 10 waiting events. |
| V$SESSTAT | This view displays the statistical events at the session level. |
| V$SYSSTAT | This view displays the statistical events at the tenant level on the current server. |
| V$SYSTEM_EVENT | This view displays the waiting events at the tenant level. |
| GV$SESSION_LONGOPS | This view displays the execution status and progress of DDL operations in the cluster. |
| V$SESSION_LONGOPS | This view displays the execution status and progress of DDL operations on the current OBServer node. |
Statistics related to monitoring
| View Name | Purpose |
|---|---|
| GV$OB_DTL_INTERM_RESULT_MONITOR | This view displays the monitoring information of the DTL intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | This view displays the monitoring information of the DTL intermediate result manager. |
Statistics related to I/O
| View Name | Purpose |
|---|---|
| GV$OB_SHARED_STORAGE_QUOTA | This view displays the I/O access resource information on all OBServer nodes. |
| V$OB_SHARED_STORAGE_QUOTA | This view displays the I/O access resource information on the current OBServer node. |
Statistics related to caching
| View Name | Purpose |
|---|---|
| GV$OB_SS_LOCAL_CACHE | This view displays the relevant metrics of various cache data in the local cache of each OBServer node for all tenants in shared storage mode. |
| V$OB_SS_LOCAL_CACHE | This view displays the relevant metrics of various cache data in the local cache of the current OBServer node for all tenants in shared storage mode. |
| GV$OB_MEMORY | This view displays the memory statistics at the tenant level. |
| V$OB_MEMORY | This view displays the memory statistics at the tenant level. |
| GV$OB_MEMSTORE | This view displays the memory usage of MemTables for all tenants on all servers. |
| V$OB_MEMSTORE | This view displays the MemStore statistics at the tenant level. |
| GV$OB_MEMSTORE_INFO | This view displays the detailed information of MemTables for all partitions of all tenants on all servers. |
| V$OB_MEMSTORE_INFO | This view displays the detailed information of MemTables for all partitions of all tenants on all servers. |
| GV$OB_SSTABLES | This view displays the SSTable information of a tenant. |
| V$OB_SSTABLES | This view displays the SSTable information of a tenant. |
| GV$OB_TENANT_MEMORY | This view displays the memory usage of each tenant in the cluster. |
| V$OB_TENANT_MEMORY | This view displays the memory usage of each tenant in the current observer process. |
Resource Manager
| View Name | Purpose |
|---|---|
| GV$OB_GROUP_IO_STAT | This view displays the real-time status of each resource group on all OBServer nodes in the current tenant. |
| GV$OB_FUNCTION_IO_STAT | This view displays the Function-level I/O statistics on all OBServer nodes in the current tenant. |
| V$OB_GROUP_IO_STAT | This view displays the real-time status of each resource group on the current OBServer node in the current tenant. |
| V$OB_FUNCTION_IO_STAT | This view displays the Function-level I/O statistics on the current OBServer node in the current tenant. |
SQL-related statistics
| View name | Description |
|---|---|
| GV$OB_PLAN_CACHE_STAT | This view displays the overall status of each plan cache on all OBServer nodes for the current tenant. |
| V$OB_PLAN_CACHE_STAT | This view records the overall status of each plan cache on all servers for the current tenant. |
| GV$OB_PLAN_CACHE_PLAN_STAT | This view records the status of each cached object in the plan cache on all servers for the current tenant. |
| V$OB_PLAN_CACHE_PLAN_STAT | This view records the status of each cached object in the plan cache on the current server for the current tenant. |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | This view displays the physical execution plans cached in the plan cache on all servers. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | This view displays the physical execution plans cached in the plan cache on the current server. |
| GV$OB_PS_STAT | This view monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| V$OB_PS_STAT | This view monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| GV$OB_PS_ITEM_INFO | This view provides monitoring functionality for prepared statements, containing basic information about all prepared statements in the PS cache. |
| V$OB_PS_ITEM_INFO | This view provides monitoring functionality for prepared statements, containing basic information about all prepared statements in the PS cache. |
| GV$OB_PX_TARGET_MONITOR | This view displays the usage of PX threads on all OBServer nodes. |
| V$OB_PX_TARGET_MONITOR | This view displays the usage of PX threads on the OBServer node. |
| GV$OB_SQL_AUDIT | This view displays the statistics of each SQL request on all servers, including the source and execution status. |
| V$OB_SQL_AUDIT | This view displays the statistics of each SQL request on the current server, including the source and execution status. |
| GV$SQL_PLAN_MONITOR | This view displays the plan-level statistics of slow queries on all OBServer nodes. Each slow query has a corresponding statistic, and the trace information of the plan is recorded. |
| V$SQL_PLAN_MONITOR | This view displays the operation-level statistics of slow queries. Each operation has a corresponding statistic. |
| V$SQL_MONITOR_STATNAME | This view displays the meaning of the numbers in the OTHERSTAT_X_ID field of GV$SQL_PLAN_MONITOR. |
| GV$OB_FLT_TRACE_CONFIG | This view displays the diagnostic information of end-to-end tracing. |
Log-related statistics
| View name | Purpose |
|---|---|
| GV$OB_LOG_STAT | This view displays the status of Palf. |
| V$OB_LOG_STAT | This view displays the status of Palf. |
Network-related statistics
| View name | Purpose |
|---|---|
| GV$OB_RPC_OUTGOING | This view displays the statistics of RPC sent by all OBServer nodes. |
| GV$OB_RPC_INCOMING | This view displays the statistics of RPC received by all OBServer nodes. |
| V$OB_RPC_OUTGOING | This view displays the statistics of RPC sent by different tenants on different OBServer nodes. |
| V$OB_RPC_INCOMING | This view displays the statistics of RPC received by different tenants on different OBServer nodes. |
Database-related statistics
| View name | Purpose |
|---|---|
| GV$OB_KVCACHE | This view displays the KVCACHE information on each OBServer node. |
| GV$OB_PARAMETERS | This view displays the configuration information on all OBServer nodes where the tenant resides. |
| GV$OB_SERVER_SCHEMA_INFO | This view displays the schema information on all servers. |
| GV$OB_UNITS | This view displays the unit information on the OBServer node where the tenant resides. The system tenant can view the unit information on all OBServer nodes in the cluster. |
| V$OB_KVCACHE | This view displays the KVCACHE information on each OBServer node. |
| V$OB_PARAMETERS | This view displays the configuration information on the OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | This view displays the schema information on all servers. |
| V$OB_UNITS | This view displays the unit information on the OBServer node. |
| GV$DML_STATS | This view displays the DML information in the current user table. |
| V$DML_STATS | This view displays the DML information in the current user table. |
| V$OB_COMPATIBILITY_CONTROL | This view displays the features that can be controlled for compatibility with the OceanBase Database release. |
Statistics related to dumps
| View name | Description |
|---|---|
| GV$OB_MERGE_INFO | This view displays statistics related to completed major compactions in the OceanBase cluster. |
| V$OB_MERGE_INFO | This view displays statistics related to completed major compactions in the OceanBase cluster. |
Statistics related to threads
| View name | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | In parallel execution scenarios, this view displays the execution information of each thread. |
| V$OB_PX_WORKER_STAT | In parallel execution scenarios, this view displays the execution information of each thread. |
Statistics related to workareas
| View name | Description |
|---|---|
| GV$SQL_WORKAREA | This view displays the workarea statistics of all operators executed under SQL automatic memory management. |
| GV$SQL_WORKAREA_ACTIVE | This view displays the workarea information of the currently active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | This view displays the statistics of all workarea executions, such as the number of times full in-memory processing occurred between 1 M and 2 M, and the number of one-pass operations. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | This view displays some overall information about the SQL workarea, such as the maximum available memory, current used memory, and current held memory. |
| V$SQL_WORKAREA | This view displays the workarea statistics of all operators executed under SQL automatic memory management. |
| V$SQL_WORKAREA_ACTIVE | This view displays the workarea information of the currently active operators. |
| V$SQL_WORKAREA_HISTOGRAM | This view displays the statistics of all workarea executions, such as the number of times full in-memory processing occurred between 1 M and 2 M, and the number of one-pass operations. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | This view displays some overall information about the SQL workarea, including the maximum available memory, current used memory, and current held memory. |
WR-related
| View Name | Description |
|---|---|
| GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM | This view is available starting with OceanBase Database V2.1. |
| GV$OB_RES_MGR_SYSSTAT | This view is available starting with OceanBase Database V2.1. |
| GV$OB_SQLSTAT | This view is available starting with OceanBase Database V2.1. |
| V$OB_SQLSTAT | This view is available starting with OceanBase Database V2.1. |
| GV$OB_SESS_TIME_MODEL | This view is available starting with OceanBase Database V2.1. |
| V$OB_SESS_TIME_MODEL | This view is available starting with OceanBase Database V2.1. |
| GV$OB_SYS_TIME_MODEL | This view is available starting with OceanBase Database V2.1. |
| V$OB_SYS_TIME_MODEL | This view is available starting with OceanBase Database V2.1. |
| V$OB_RES_MGR_SYSSTAT | This view is available starting with OceanBase Database V2.1. |
Statistics related to encrypted tables
| View Name | Description |
|---|---|
| V$OB_ENCRYPTED_TABLES | This view is available starting with OceanBase Database V2.1. |
| V$ENCRYPTED_TABLESPACES | This view is available starting with OceanBase Database V2.1. |
Statistics related to transactions
| View Name | Description |
|---|---|
| GV$LATCH | This view is available starting with OceanBase Database V2.1. |
| V$LATCH | This view is available starting with OceanBase Database V2.1. |
Views in an Oracle tenant
Dictionary views
Applicability
This topic applies only to OceanBase Database Enterprise Edition.
Views and tables
| View | Description |
|---|---|
| ALL_ALL_TABLES | This view displays the object tables and relational tables accessible to the user. |
| ALL_COL_COMMENTS | This view displays the column comments of the views and tables accessible to the user. |
| ALL_TABLES | This view displays all tables accessible to the user. |
| ALL_TAB_COLS | This view displays all columns of the tables, views, and clusters accessible to the current user. |
| ALL_TAB_COLUMNS | This view displays all columns of the tables, views, and clusters accessible to the current user. |
| ALL_TAB_COMMENTS | This view displays the comments of the tables and views accessible to the current user. |
| DBA_COL_COMMENTS | This view displays the column comments of all views and tables in the database. |
| DBA_TAB_COMMENTS | This view displays the comments of all tables and views in the database. |
| USER_COL_COMMENTS | This view displays the column comments of all views and tables owned by the current user. |
| USER_TAB_COMMENTS | This view displays the comments of the tables and views owned by the current user. |
| DBA_OB_TABLEGROUP_TABLES | This view displays the association between TABLEGROUP and TABLE. It does not display tables not in a TABLEGROUP. |
| DBA_TABLES | This view displays all tables in the database. |
| DBA_ALL_TABLES | This view displays the object tables and relational tables in the database. Its fields are the same as those in ALL_ALL_TABLES. |
| DBA_TABLESPACES | This view displays all tablespaces in the database. |
| DBA_TAB_COLS | This view displays all columns of the tables, views, and clusters in the database. |
| DBA_TAB_COLUMNS | This view displays all columns of the tables, views, and clusters in the database. |
| USER_ALL_TABLES | This view displays the object tables and relational tables accessible to the current user. Except for the OWNER column, its fields are the same as those in ALL_ALL_TABLES. |
| USER_TABLES | This view displays all tables owned by the current user. |
| USER_TABLESPACES | This view displays the tablespaces accessible to the current user. Its columns are the same as those in DBA_TABLESPACES, except for the PLUGGED_IN column. |
| USER_TAB_COLS | This view displays all columns of the tables, views, and clusters owned by the current user. |
| USER_TAB_COLUMNS | This view displays all columns of the tables, views, and clusters owned by the current user. |
| ALL_VIEWS | This view displays the views accessible to the current user. |
| DBA_VIEWS | This view displays all views in the database. The columns are the same as those in ALL_VIEWS. |
| USER_VIEWS | This view displays the views owned by the current user. |
| DICTIONARY | This view displays the descriptions of data dictionary tables and views. |
| DICT | This view displays the descriptions of data dictionary tables and views. |
| DBA_OB_TABLE_LOCATIONS | This view displays the locations of tables or partitions, including system tables, user tables, and index tables. |
| DBA_OB_SPATIAL_COLUMNS | This view displays the database name, table name, type, and SRS information corresponding to spatial index columns. |
Materialized views
| View name | Description |
|---|---|
| DBA_MVIEW_DEPS | This view displays the dependencies of materialized views in the current tenant. |
| DBA_MVIEW_LOGS | This view displays the logs of materialized views. |
| DBA_MVIEW_RUNNING_JOBS | This view displays the running materialized view-related tasks, including refresh tasks and MLOG cleanup tasks, in the current tenant. |
| USER_MVIEWS | This view displays the information about materialized views. |
| DBA_MVIEWS | This view displays the information about all materialized views. |
| DBA_MVREF_CHANGE_STATS | This view displays the statistics related to materialized view refreshes. |
| DBA_MVREF_RUN_STATS | This view displays the information about each materialized view refresh run, identified by a REFRESH_ID. |
| DBA_MVREF_STATS | This view displays the basic timing statistics of materialized view refreshes. |
| DBA_MVREF_STATS_PARAMS | This view displays the refresh statistics attributes associated with each materialized view. |
| DBA_MVREF_STATS_SYS_DEFAULTS | This view displays the system-wide default values for materialized view refresh history statistics attributes. |
| DBA_MVREF_STMT_STATS | This view describes the information associated with refresh statements. |
Outline
| View name | Description |
|---|---|
| DBA_OB_OUTLINES | This view displays the execution plan outline information of the current tenant. |
| DBA_OB_CONCURRENT_LIMIT_SQL | This view displays the outline-related information of the throttling rules of the current tenant. |
| DBA_OB_OUTLINE_CONCURRENT_HISTORY | This view displays the execution plan and throttling rule outline history information of the current tenant. |
| DBA_OB_FORMAT_OUTLINES | This view records the detailed information about the Format Outline of the current tenant. |
SPM
| View name | Description |
|---|---|
| DBA_SQL_PLAN_BASELINES | This view displays the plan baselines of SQL statements in SPM. |
| DBA_SQL_MANAGEMENT_CONFIG | This view displays the configuration parameters in SPM. |
Basic database information
| View | Purpose |
|---|---|
| DBA_CONTEXT | This view displays all context namespaces in the database. |
| DBA_OB_DATABASES | This view displays the database metadata of the tenant. |
| DBA_OB_MAJOR_COMPACTION | This view displays the global information of the major compactions in the current tenant. |
| DBA_OB_ZONE_MAJOR_COMPACTION | This view displays the information of major compactions in each zone of the current tenant. |
| ALL_OBJECTS | This view displays all database objects accessible to the user. |
| DBA_OBJECTS | This view displays all database objects. |
| USER_OBJECTS | This view displays all database objects owned by the user. |
| ALL_DEPENDENCIES | This view displays the dependencies between all database objects. |
| DBA_DEPENDENCIES | This view displays all dependencies between database objects. |
| USER_DEPENDENCIES | This view displays the dependencies between objects in the current user schema. |
| DBA_OB_FREEZE_INFO | This view displays the version information generated by major freeze. |
| DBA_OB_SOURCE | This view displays the source code information of all storage objects in the current tenant. |
| USER_OB_SOURCE | This view displays the source code information of storage objects owned by the current user. |
| ALL_OB_SOURCE | This view displays the source code information of storage objects accessible to the current user. |
Functions and procedures
| View name | Description |
|---|---|
| ALL_ARGUMENTS | This view displays the parameters of functions and procedures accessible to the current user. |
| ALL_PROCEDURES | This view displays all functions and procedures accessible to the current user, along with their related properties. |
| ALL_SOURCE | This view displays the text source of stored objects accessible to the current user. |
| DBA_ARGUMENTS | This view displays the parameters of functions and procedures available in the database. The columns are the same as those in ALL_ARGUMENTS. |
| DBA_PROCEDURES | This view displays all functions and procedures available in the database, along with their related properties. The columns are the same as those in ALL_PROCEDURES. |
| DBA_SOURCE | This view displays the text source of all stored objects in the database. The columns are the same as those in ALL_SOURCE. |
| USER_ARGUMENTS | This view displays the parameters of functions and procedures owned by the current user. The columns are the same as those in ALL_ARGUMENTS, excluding the OWNER column. |
| USER_PROCEDURES | This view displays all functions and procedures owned by the current user, along with their related properties. The columns are the same as those in ALL_PROCEDURES, excluding the OWNER column. |
| USER_SOURCE | This view displays the text source of stored objects owned by the current user. The columns are the same as those in ALL_SOURCE, excluding the OWNER column. |
| DBA_JOBS | This view displays an overview of submitted tasks. |
| USER_JOBS | This view displays an overview of submitted tasks. |
| DBA_JOBS_RUNNING | This view displays running tasks. |
Backup and restore
| View name | Description |
|---|---|
| DBA_OB_BACKUP_JOBS | This view displays the backup job tasks of the current tenant. |
| DBA_OB_BACKUP_JOB_HISTORY | This view displays the history of the backup job tasks of the current tenant. |
| DBA_OB_BACKUP_TASKS | This view displays the task-level backup tasks of the current tenant. |
| DBA_OB_BACKUP_TASK_HISTORY | This view displays the history of the task-level backup tasks of the current tenant. |
| DBA_OB_BACKUP_SET_FILES | This view displays the file status of the backup set. |
| DBA_OB_RESTORE_PROGRESS | This view displays the progress of the ongoing restore task. |
| DBA_OB_RESTORE_HISTORY | This view displays the history of the completed restore tasks. |
| DBA_OB_ARCHIVE_DEST | This view displays the archive path configuration. |
| DBA_OB_BACKUP_STORAGE_INFO | This view displays the backup destination information for backup and restore operations in the current tenant. |
| DBA_OB_BACKUP_STORAGE_INFO_HISTORY | This view displays the historical backup destination information for backup and restore operations in the current tenant. |
| DBA_OB_BACKUP_DELETE_POLICY | This view displays the deletion strategy set for expired or automatic cleanup in the current tenant. |
| DBA_OB_BACKUP_DELETE_JOBS | This view displays the progress of the tenant-level backup cleanup job tasks. |
| DBA_OB_BACKUP_DELETE_JOB_HISTORY | This view displays the history of the backup cleanup tasks executed in the current tenant. |
| DBA_OB_BACKUP_DELETE_TASKS | This view displays the information about the backup_set/backup_piece cleanup tasks being executed in the current tenant. |
| DBA_OB_BACKUP_DELETE_TASK_HISTORY | This view displays the history of the completed backup_set/backup_piece cleanup tasks in the current tenant. |
| DBA_OB_ARCHIVELOG | This view displays the log backup status on each path. |
| DBA_OB_ARCHIVELOG_SUMMARY | This view displays the status of all historical and current log backups. |
| DBA_OB_ARCHIVELOG_PIECE_FILES | This view displays the status of the pieces in the backup set. |
| DBA_OB_BACKUP_PARAMETER | This view displays the backup parameters. |
| DBA_OB_RECOVER_TABLE_JOBS | This view displays information about table-level restore tasks. |
| DBA_OB_IMPORT_TABLE_JOBS | This view displays information about import tasks. |
| DBA_OB_IMPORT_TABLE_TASKS | This view displays records of table-level import tasks. |
| DBA_OB_RECOVER_TABLE_JOB_HISTORY | This view displays results of table-level restore tasks. |
| DBA_OB_IMPORT_TABLE_JOB_HISTORY | This view displays results of import tasks. |
| DBA_OB_IMPORT_TABLE_TASK_HISTORY | This view displays the history records of cross-tenant table-level import tasks. |
Statistics and histograms
| View | Description |
|---|---|
| ALL_PART_COL_STATISTICS | This view displays the column statistics and histogram information of the partitions in the partitioned tables accessible to the current user. |
| ALL_PART_HISTOGRAMS | This view displays the histogram information of the partitions. |
| ALL_SUBPART_COL_STATISTICS | This view displays the column statistics and histogram information of the subpartitions in the partitioned tables accessible to the current user. |
| ALL_SUBPART_HISTOGRAMS | This view displays the histogram information of the subpartitions. |
| ALL_TAB_COL_STATISTICS | This view displays the column statistics and histogram information of the tables accessible to the current user. |
| ALL_TAB_HISTOGRAMS | This view displays the histogram information of the tables. |
| ALL_TAB_STATISTICS | This view displays the optimizer statistics of the tables accessible to the current user. |
| DBA_PART_COL_STATISTICS | This view displays the column statistics and histogram information of the partitions in the partitioned tables of the database. |
| DBA_PART_HISTOGRAMS | This view displays the histogram information of the partitions. |
| DBA_SUBPART_COL_STATISTICS | This view displays the column statistics and histogram information of the subpartitions in the partitioned tables of the database. |
| DBA_SUBPART_HISTOGRAMS | This view displays the histogram information of the subpartitions. |
| DBA_TAB_COL_STATISTICS | This view displays the column statistics and histogram information of all tables in the database. |
| DBA_TAB_HISTOGRAMS | This view displays the histogram information of the tables. |
| DBA_TAB_STATISTICS | This view displays the optimizer statistics of all tables in the database. |
| USER_PART_COL_STATISTICS | This view displays the column statistics and histogram information of the partitions in the partitioned tables of the current user. |
| USER_PART_HISTOGRAMS | This view displays the histogram information of the partitions. |
| USER_SUBPART_COL_STATISTICS | This view displays the column statistics and histogram information of the subpartitions in the partitioned tables of the current user. |
| USER_SUBPART_HISTOGRAMS | This view displays the histogram information of the subpartitions. |
| USER_TAB_COL_STATISTICS | This view displays the column statistics and histogram information of the tables of the current user. |
| USER_TAB_HISTOGRAMS | This view displays the histogram information of the tables. |
| USER_TAB_STATISTICS | This view displays the optimizer statistics for all tables of the current user. |
| ALL_TAB_STATS_HISTORY | This view displays the table statistics modification history for all tables accessible to the current user. |
| DBA_TAB_STATS_HISTORY | This view displays the table statistics modification history for all tables in the database. |
| USER_TAB_STATS_HISTORY | This view displays the table statistics modification history for all tables of the current user. |
| ALL_IND_STATISTICS | This view displays the optimizer statistics for indexes on tables accessible to the current user. |
| DBA_IND_STATISTICS | This view displays the optimizer statistics for all indexes in the database. |
| USER_IND_STATISTICS | This view displays the optimizer statistics for indexes on tables of the current user. |
| ALL_TAB_MODIFICATIONS | This view displays the cumulative modification information for tables accessible to the current user. |
| DBA_TAB_MODIFICATIONS | This view displays the cumulative modification information for tables in the database. |
| USER_TAB_MODIFICATIONS | This view displays the cumulative modification information for tables of the current user. |
| DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY | This view queries the historical execution of table statistics collection. |
Resource Manager
| View name | Description |
|---|---|
| DBA_OB_RSRC_DIRECTIVES | This view displays the resource configuration parameters of the current tenant in Resource Manager. |
| DBA_OB_RSRC_IO_DIRECTIVES | This view displays the I/O resource configuration of the current tenant in Resource Manager. |
| DBA_RSRC_GROUP_MAPPINGS | This view displays the binding relationships between users and resource groups. |
| DBA_RSRC_CONSUMER_GROUPS | This view displays the information of all resource groups in the database. |
| DBA_RSRC_PLANS | This view displays all resource management plans defined in the system. |
| DBA_RSRC_PLAN_DIRECTIVES | This view displays the detailed information of each resource plan directive in the database. |
I/O-related statistics
| View name | Description |
|---|---|
| DBA_OB_STORAGE_IO_USAGE | This view displays the I/O operations of the current tenant for object storage and cloud disks. |
Users and privileges
| View name | Description |
|---|---|
| ALL_USERS | This view displays all database users visible to the current user. |
| DBA_USERS | This view displays all database users. |
| USER_USERS | This view displays information about the current user. |
| ALL_COL_PRIVS | This view displays column object privileges granted to the current user as the owner, grantor, or grantee. Column object privileges granted by enabled roles or PUBLIC are also displayed. |
| ALL_TAB_PRIVS | *This view displays object privileges granted to the current user as the owner, grantor, or grantee. Object privileges granted by activated roles or the PUBLIC role are also displayed. * |
| DBA_COL_PRIVS | This view displays all column object grants in the database. |
| DBA_SYS_PRIVS | This view displays system privileges granted to users and roles. |
| DBA_TAB_PRIVS | This view displays all object grants in the database. |
| USER_TAB_PRIVS | This view displays object privileges owned by the current user. |
| USER_COL_PRIVS | This view displays column object privileges granted to the current user as the owner, grantor, or grantee. |
| USER_ROLE_PRIVS | This view displays roles granted to the current user. |
| USER_SYS_PRIVS | This view displays system privileges granted to the current user. |
| ROLE_TAB_PRIVS | This view displays table privileges granted to roles. It provides information about roles accessible to users. |
| ROLE_SYS_PRIVS | This view displays system privileges granted to roles. |
| ROLE_ROLE_PRIVS | This view displays roles granted to other roles. It provides information about roles accessible to users. |
| DBA_ROLE_PRIVS | This view displays roles granted to all users and roles in the database. |
| DBA_ROLES | This view displays all roles existing in the database. |
| ALL_DIRECTORIES | This view displays all directories accessible to the current user. |
| DBA_DIRECTORIES | This view displays all directories accessible to the current user. |
Constraints
| View Name | Description |
|---|---|
| ALL_CONSTRAINTS | This view displays constraint information for all tables accessible to the current user. |
| ALL_CONS_COLUMNS | This view displays column information for all constraints of all tables accessible to the current user. |
| DBA_CONSTRAINTS | This view displays constraint information for all tables in the database. |
| DBA_CONS_COLUMNS | This view displays column information for all constraints of all tables in the database. |
| USER_CONSTRAINTS | This view displays constraint information for all tables owned by the current user. |
| USER_CONS_COLUMNS | This view displays column information for all constraints of all tables owned by the current user. |
Audit
| View Name | Description |
|---|---|
| ALL_DEF_AUDIT_OPTS | This view displays the audit conditions for which any object is audited by default. |
| AUDIT_ACTIONS | This view displays the Action ID and corresponding name in audit records. |
| DBA_AUDIT_EXISTS | This view displays audit trail entries generated by the AUDIT EXISTS and AUDIT NOT EXISTS statements. |
| DBA_AUDIT_OBJECT | This view displays audit trail records for all objects in the database. |
| DBA_AUDIT_SESSION | This view displays audit trail records for CONNECT and DISCONNECT. |
| DBA_AUDIT_STATEMENT | This view displays audit trail records for GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements in the database. |
| DBA_AUDIT_TRAIL | This view displays all audit trail entries. |
| DBA_OBJ_AUDIT_OPTS | This view displays detailed object-level audit configurations. |
| DBA_STMT_AUDIT_OPTS | This view displays detailed statement-level audit configurations. |
| STMT_AUDIT_OPTION_MAP | This view displays the type, name, and priority of statement-level audit options. |
| USER_AUDIT_OBJECT | This view displays audit trail records for objects accessible to the current user. |
| USER_AUDIT_SESSION | This view displays audit trail records for the connection and disconnection of the current user. |
| USER_AUDIT_STATEMENT | This view displays audit trail entries for GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements issued by the current user. |
| USER_AUDIT_TRAIL | This view displays standard audit trail entries related to the current user. |
Indexes
| View Name | Purpose |
|---|---|
| ALL_INDEXES | This view displays the index column information of all indexes on tables accessible to the current user. |
| ALL_IND_COLUMNS | This view displays the index column information of all indexes on tables accessible to the current user. |
| ALL_IND_EXPRESSIONS | This view displays the information of function-based indexes accessible to the current user in the database. |
| ALL_IND_PARTITIONS | This view displays the information of index partitions accessible to the current user in the database. |
| ALL_IND_SUBPARTITIONS | This view displays the information of index subpartitions accessible to the current user in the database. |
| ALL_PART_INDEXES | This view displays the partition information of partition indexes accessible to the current user. |
| DBA_INDEXES | This view displays the index information of all tables in the database. |
| DBA_IND_COLUMNS | This view displays the index column information of all indexes on all tables in the database. |
| DBA_IND_EXPRESSIONS | This view displays the information of all function-based indexes in the database. |
| DBA_IND_PARTITIONS | This view displays the information of all index partitions in the database. |
| DBA_IND_SUBPARTITIONS | This view displays the information of all index subpartitions in the database. |
| USER_INDEXES | This view displays the index information of all tables owned by the current user. |
| USER_IND_COLUMNS | This view displays the index column information of all indexes on all tables owned by the current user. |
| USER_IND_EXPRESSIONS | This view displays the information of function-based indexes owned by the current user in the database. |
| USER_IND_PARTITIONS | This view displays the information of index partitions owned by the current user in the database. This view does not contain the INDEX_OWNER column, which is present in ALL_IND_PARTITIONS and DBA_IND_PARTITIONS. |
| USER_IND_SUBPARTITIONS | This view displays the information of index subpartitions owned by the current user in the database. This view does not contain the INDEX_OWNER column, which is present in DBA_IND_SUBPARTITIONS and ALL_IND_SUBPARTITIONS. |
| USER_PART_INDEXES | This view displays the partition information of partition indexes owned by the current user. |
Partitions
| View name | Description |
|---|---|
| ALL_PART_KEY_COLUMNS | This view displays the columns in the partition keys of all partitioned objects accessible to the current user. |
| ALL_PART_TABLES | This view displays the partition information of all partitioned tables accessible to the current user. |
| ALL_SUBPARTITION_TEMPLATES | This view displays the descriptions of all subpartition templates. |
| ALL_SUBPART_KEY_COLUMNS | This view displays the columns in the subpartition keys of all partitioned objects accessible to the current user. |
| ALL_TAB_PARTITIONS | This view displays the multi-level partition information, partition storage parameters, and partition statistics of all partitioned tables. |
| ALL_TAB_SUBPARTITIONS | This view displays the partition-level information, partition storage parameters, and partition statistics generated by the DBMS_STATS package for all partitions accessible to the current user. |
| DBA_OB_DYNAMIC_PARTITION_TABLES | This view displays the information of dynamic partition tables in the current tenant. |
| DBA_PART_INDEXES | This view displays the partition information of all partitioned indexes. |
| DBA_PART_KEY_COLUMNS | This view displays the columns in the partition keys of all partitioned objects in the database. |
| DBA_PART_TABLES | This view displays the partition information of all partitioned tables accessible to the current user. |
| DBA_SUBPARTITION_TEMPLATES | This view displays the descriptions of all subpartition templates. |
| DBA_SUBPART_KEY_COLUMNS | This view displays the columns in the subpartition keys of all partitioned objects in the database. |
| DBA_TAB_PARTITIONS | This view displays the multi-level partition information, partition storage parameters, and partition statistics of all partitions accessible to the current user. |
| DBA_TAB_SUBPARTITIONS | This view displays the subpartition name, table name, name of the partition to which it belongs, its storage attributes, and the statistics generated by the DBMS_STATS package. |
| USER_PART_KEY_COLUMNS | This view displays the columns in the partition keys of all partitioned objects owned by the current user. |
| USER_PART_TABLES | This view displays the partition information of all partitioned tables owned by the current user. |
| USER_SUBPARTITION_TEMPLATES | This view displays the descriptions of all subpartition templates. |
| USER_SUBPART_KEY_COLUMNS | This view displays the columns in the subpartition keys of all partitioned objects owned by the current user. |
| USER_TAB_SUBPARTITIONS | This view displays the subpartition name, table name, name of the partition to which it belongs, and its storage attributes for each subpartition of each table owned by the current user. |
| USER_TAB_PARTITIONS | This view displays the multi-level partition information, partition storage parameters, and partition statistics of all partitions owned by the current user. |
Session related
| View name | Description |
|---|---|
| DBA_OB_DEADLOCK_EVENT_HISTORY | This view displays the history of deadlock events. In a non-root tenant, it shows the history of the current tenant. |
Sequences
| View name | Description |
|---|---|
| ALL_SEQUENCES | This view displays all SEQUENCEs accessible to the user. |
| DBA_SEQUENCES | This view displays all SEQUENCEs in the database. |
| USER_SEQUENCES | This view displays all SEQUENCEs owned by the current user. |
| TENANT_VIRTUAL_GLOBAL_VARIABLE | This view displays global variable information. |
| TENANT_VIRTUAL_SESSION_VARIABLE | This view displays session variable information. |
Synonyms
| View name | Description |
|---|---|
| ALL_SYNONYMS | This view displays all synonyms accessible to the user. |
| DBA_SYNONYMS | This view displays all synonyms in the database. |
| USER_SYNONYMS | This view displays all synonyms owned by the current user. |
Triggers
| View name | Description |
|---|---|
| ALL_TRIGGERS | This view displays triggers and their descriptions on tables owned by the current user. If the user has the CREATE ANY TRIGGER privilege, this view displays all triggers in the database. |
| DBA_TRIGGERS | This view displays all triggers in the database. |
| USER_TRIGGERS | This view displays all triggers owned by the current user. |
Recyclebin
| View name | Description |
|---|---|
| DBA_RECYCLEBIN | This view displays information about all recyclebins in the database. |
| USER_RECYCLEBIN | This view displays information about the recyclebin owned by the current user. The columns are the same as those in DBA_RECYCLEBIN, except that the OWNER column is removed. |
NLS
| View name | Description |
|---|---|
| NLS_DATABASE_PARAMETERS | This view displays the NLS parameters at the database level (OceanBase Database tenant level). |
| NLS_INSTANCE_PARAMETERS | This view displays the NLS parameters at the instance level (tenant level). |
| NLS_SESSION_PARAMETERS | This view displays the NLS parameters at the session level. |
User-defined types
| View name | Description |
|---|---|
| ALL_COLL_TYPES | This view displays the user-defined collection types available in the database. Its columns are the same as those in DBA_COLL_TYPES. |
| ALL_TYPES | This view displays the user-defined types available in the database. |
| ALL_TYPE_ATTRS | This view displays the attribute information of the user-defined types available in the database. |
| DBA_COLL_TYPES | This view displays the user-defined collection types available in the database. Its columns are the same as those in ALL_COLL_TYPES. |
| DBA_TYPES | This view displays the user-defined types available in the database. |
| DBA_TYPE_ATTRS | This view displays the attribute information of the user-defined types available in the database. |
| USER_COLL_TYPES | This view displays the user-defined collection types available to the current user. |
| USER_TYPES | This view displays the user-defined types available to the current user. |
| USER_TYPE_ATTRS | This view displays the attribute information of the user-defined types available to the current user. |
Storage objects
| View name | Description |
|---|---|
| ALL_ERRORS | This view displays the errors of the storage objects accessible to the current user. |
| DBA_ERRORS | This view displays the errors of the storage objects in the database. |
| USER_ERRORS | This view displays the errors of the storage objects accessible to the current user. |
| DBA_SEGMENTS | This view displays the storage information of all segments in the database. |
| USER_SEGMENTS | This view displays the storage information of the segments owned by the objects under the current user. |
PROFILE
| View Name | Description |
|---|---|
| ALL_PROFILES | This view displays all profiles and their limits. |
| DBA_PROFILES | This view displays all profiles and their limits. |
| USER_PROFILES | This view displays all profiles and their limits. |
Replica and log-related views
| View Name | Description |
|---|---|
| DBA_OB_CS_REPLICA_STATS | This view displays the progress of converting tablets to columnar storage in the log streams of C replicas on all OBServer nodes in the current tenant. |
| DBA_OB_LS_LOCATIONS | This view displays the distribution information of log streams (LS) replicas in the current tenant. |
| DBA_OB_TABLEGROUPS | This view displays the metadata of table groups, mainly focusing on the partition information of table groups. |
| DBA_OB_TABLEGROUP_PARTITIONS | This view displays the primary partition information of partitioned table groups. |
| DBA_OB_TABLEGROUP_SUBPARTITIONS | This view displays the secondary partition information of partitioned table groups. |
| DBA_OB_TABLET_REPLICAS | This view displays all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the joint key: <TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| DBA_OB_TABLET_TO_LS | This view displays the list of all tablets in the current tenant and the log stream information to which each tablet belongs. |
| DBA_OB_LS | This view displays the status and recovery progress of log streams. |
WR-related
| View name | Description |
|---|---|
| DBA_WR_SNAPSHOT | This view displays the SNAPSHOT information of the current tenant. |
| DBA_WR_ACTIVE_SESSION_HISTORY | This view displays the ASH data of the current tenant. |
| DBA_WR_STATNAME | This view displays the names of the system statistics of the current tenant. |
| DBA_WR_SYSSTAT | This view displays the details of the system statistics of the current tenant. |
| DBA_WR_CONTROL | This view displays the WR-related configuration information. |
| DBA_WR_SYSTEM_EVENT | This view displays the tenant-level wait event information of the current tenant. |
| DBA_WR_EVENT_NAME | This view displays the tenant-level wait event names of the current tenant. |
| DBA_WR_SQLTEXT | This view displays the SQL texts collected by WR of the current tenant. |
| DBA_WR_SQLSTAT | This view displays the basic performance statistics of the SQL statements executed by the current tenant. |
| DBA_WR_SYS_TIME_MODEL | This view displays the WR data of the Time Model statistics of the current tenant. |
Load balancing-related
| View name | Description |
|---|---|
| DBA_OB_TRANSFER_PARTITION_TASKS | This view displays the Transfer Partition tasks being processed in the current tenant. |
| DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | This view displays the history of the Transfer Partition tasks executed in the current tenant. |
Scheduler
| View name | Description |
|---|---|
| DBA_SCHEDULER_JOBS | This view displays the information of the scheduler jobs accessible to the current user. |
| DBA_SCHEDULER_PROGRAM | This view displays all the scheduler information in the database. |
| DBA_SCHEDULER_JOB_RUN_DETAILS | This view displays the information of all the scheduler jobs in the tenant. |
DBLINK-related
| View name | Description |
|---|---|
| ALL_DB_LINKS | This view displays all the DBLINKs accessible to the current user. |
| DBA_DB_LINKS | This view displays all the DBLINKs created in the current tenant. |
| USER_DB_LINKS | This view displays the DBLINKs created by the current user. |
Unsupported views
| View name | Purpose |
|---|---|
| ALL_METHOD_PARAMS | This view displays method parameters of object types that the current user can access. |
| ALL_SCHEDULER_JOB_ARGS | This view displays scheduler job arguments that the current user can query. |
| ALL_SCHEDULER_PROGRAM_ARGS | This view displays scheduler program arguments that the current user can query. |
| ALL_TYPE_METHODS | This view displays methods of object types that the current user can access. |
| DBA_METHOD_PARAMS | This view displays method parameters of object types in the database. |
| DBA_SCHEDULER_JOB_ARGS | This view displays scheduler job arguments in the database. |
| USER_SCHEDULER_JOB_ARGS | This view displays scheduler job arguments of jobs owned by the current user. |
| DBA_SCHEDULER_PROGRAM_ARGS | This view displays scheduler program arguments in the database. |
| USER_SCHEDULER_PROGRAM_ARGS | This view displays scheduler program arguments of programs owned by the current user. |
| DBA_TYPE_METHODS | This view displays methods of object types in the database. |
| USER_TYPE_METHODS | This view displays methods of object types that the current user can access. The fields of this view are the same as those of the ALL_TYPE_METHODS view, except that the OWNER field is not included. |
Overview of performance views
ASH-related
| View | Description |
|---|---|
| GV$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| GV$OB_ACTIVE_SESSION_HISTORY | Displays the active session history of all OBServer nodes in the current tenant. |
| V$OB_ACTIVE_SESSION_HISTORY | Displays the active session history of the current OBServer node in the current tenant. |
Partition-related
| View | Description |
|---|---|
| V$OB_DYNAMIC_PARTITION_TABLES | Displays the dynamic partition table information of the current tenant. |
Statistics
| View | Description |
|---|---|
| GV$OB_KVCACHE | Displays the KVCACHE information on each OBServer node. |
| GV$OB_PARAMETERS | Displays the configuration information on all OBServer nodes in the tenant. |
| GV$OB_SERVER_SCHEMA_INFO | Displays the schema information on all servers. |
| V$OB_SERVER_SCHEMA_INFO | Displays the schema information on all servers. |
| GV$OB_UNITS | Displays the unit information of the OBServer node in the tenant. The system tenant can view the unit information of all OBServer nodes in the cluster. |
| GV$SYSSTAT | Displays the system-level statistical events on all servers. |
| GV$DML_STATS | Displays the DML information in the current user table. |
| V$DML_STATS | Displays the DML information in the current user table. |
| V$GLOBALCONTEXT | Displays the CLIENT_IDENTIFIER value of the global context attributes accessible to the current session. |
| V$OB_KVCACHE | Displays the KVCACHE information on each OBServer node. |
| V$OB_PARAMETERS | Displays the configuration information on the current OBServer node. |
| V$SYSSTAT | Displays the system-level statistical events on the current server. |
| V$OB_UNITS | Displays the unit information of the current OBServer node. |
| V$VERSION | Displays the name and version information of all components of the database product. |
| V$STATNAME | Displays the name of the statistical item. |
Instance-related
| View name | Purpose |
|---|---|
| GV$INSTANCE | This view displays the status of the current database instance. |
| V$INSTANCE | This view displays the status of the current database instance. |
Memory-related
| View name | Purpose |
|---|---|
| GV$OB_MEMORY | This view displays the memory usage of each tenant on all servers. |
| GV$OB_MEMSTORE | This view displays the memory usage of MemTables of all tenants on all servers. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | This view displays some overall information about the SQL Workarea, including the maximum available memory, current used memory, and current hold memory. |
| GV$OB_SSTABLES | This view displays the SSTable information of a tenant. |
| GV$OB_MEMSTORE_INFO | This view displays the detailed information about MemTables of all partitions of all tenants on all servers. |
| V$OB_MEMSTORE_INFO | This view displays the detailed information about MemTables of all partitions of all tenants on all servers. |
| V$OB_MEMORY | This view displays the memory statistics at the tenant level. |
| V$OB_MEMSTORE | This view displays the memory usage of MemTables of all tenants on the current server. |
| V$OB_SSTABLES | This view displays the SSTable information of a tenant. |
| GV$OB_TENANT_MEMORY | This view displays the memory usage of each tenant on the cluster. |
| V$OB_TENANT_MEMORY | This view displays the memory usage of each tenant in the current observer process. |
Cache-related
| View name | Description |
|---|---|
| GV$OB_SS_LOCAL_CACHE | This view displays the metrics of various cache data in the local cache of each OBServer node for all tenants in shared storage mode. |
| V$OB_SS_LOCAL_CACHE | This view displays the metrics of various cache data in the local cache of the current OBServer node for all tenants in shared storage mode. |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | This view displays the physical execution plans cached in the plan cache of all servers. |
| GV$OB_PLAN_CACHE_PLAN_STAT | This view records the status of each cached object in the plan cache of all servers for the current tenant. |
| GV$OB_PLAN_CACHE_STAT | This view records the overall status of each plan cache for the current tenant on all servers. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | This view displays the physical execution plans cached in the plan cache of the current server. |
| V$OB_PLAN_CACHE_PLAN_STAT | This view records the status of each cached object in the plan cache of the current server for the current tenant. |
| V$OB_PLAN_CACHE_STAT | This view records the overall status of each plan cache for the current tenant on all servers. |
| V$RSRC_PLAN | This view displays the resource management plan of the current active tenant. |
Resource Manager-related
| View name | Description |
|---|---|
| GV$OB_GROUP_IO_STAT | This view displays the real-time status of each resource group on all OBServer nodes for the current tenant. |
| GV$OB_FUNCTION_IO_STAT | This view displays the I/O statistics at the Function level on all OBServer nodes for the current tenant. |
| V$OB_GROUP_IO_STAT | This view displays the real-time status of each resource group on the current OBServer node for the current tenant. |
| V$OB_FUNCTION_IO_STAT | This view displays the I/O statistics at the Function level on the current OBServer node for the current tenant. |
I/O-related statistics
| View name | Description |
|---|---|
| GV$OB_SHARED_STORAGE_QUOTA | This view displays the I/O access resource information on all OBServer nodes. |
| V$OB_SHARED_STORAGE_QUOTA | This view displays the I/O access resource information on the current OBServer node. |
Log-related views
| View name | Description |
|---|---|
| GV$OB_LOG_STAT | This view displays the status of Palf. |
| V$OB_LOG_STAT | This view displays the status of Palf. |
Monitoring information
| View name | Description |
|---|---|
| GV$OB_PX_TARGET_MONITOR | This view displays the usage of PX threads on all OBServer nodes. |
| GV$OB_PS_ITEM_INFO | This view provides monitoring capabilities for Prepared Statements, including basic information about all prepared statements in the PS cache. |
| GV$OB_PS_STAT | This view monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| GV$OB_DTL_INTERM_RESULT_MONITOR | This view displays the monitoring information of the DTL intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | This view displays the monitoring information of the DTL intermediate result manager. |
| V$OB_PX_TARGET_MONITOR | This view displays the usage of PX threads on OBServer nodes. |
| V$OB_PS_ITEM_INFO | This view provides monitoring capabilities for Prepared Statements, including basic information about all prepared statements in the PS cache. |
| V$OB_PS_STAT | This view monitors the overall status of the PS cache, including hit rate, memory usage, and the number of cached items. |
| V$SQL_MONITOR_STATNAME | This view displays the meaning of the numbers in the OTHERSTAT_X_ID field of GV$SQL_PLAN_MONITOR. |
Session-related
| View Name | Description |
|---|---|
| GV$OB_PROCESSLIST | This view displays session information on all OBServer nodes of the tenant. |
| GV$SESSION_WAIT | This view displays information about the current or last wait event for all sessions on all servers, including the wait event name and wait time. |
| GV$SESSION_WAIT_HISTORY | This view displays information about the last 10 wait events for all sessions on all servers. |
| GV$SESSTAT | This view displays session-level statistics on all servers. |
| V$NLS_PARAMETERS | This view displays NLS parameters at the session level. |
| V$OB_PROCESSLIST | This view displays session information on the current OBServer node. |
| V$SESSION_WAIT | This view displays information about the current or last wait event for all sessions on the current server, including the wait event name and wait time. |
| V$SESSION_WAIT_HISTORY | This view displays information about the last 10 wait events for all sessions on the current server. |
| V$SESSTAT | This view displays session-level statistics. |
| V$EVENT_NAME | This view displays event definitions in the tenant. |
SQL-related statistics
| View Name | Description |
|---|---|
| GV$OB_SQL_AUDIT | This view displays statistics such as the source and execution status of each SQL request on all servers. |
| V$OB_SQL_AUDIT | This view displays statistics such as the source and execution status of each SQL request on the current server. |
| GV$SQL_PLAN_MONITOR | This view displays plan-level statistics for slow queries on all OBServer nodes. Each slow query has a corresponding statistic, and the trace information of the plan is recorded. |
| V$SQL_PLAN_MONITOR | This view displays plan-level statistics for slow queries on all OBServer nodes. Each slow query has a corresponding statistic, and the trace information of the plan is recorded. |
| GV$OB_FLT_TRACE_CONFIG | This view displays diagnostic information for full-link tracing. |
Threads
| View Name | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | This view displays the execution information of each thread in parallel execution scenarios. |
| V$OB_PX_WORKER_STAT | This view displays the execution information of each thread in parallel execution scenarios. |
Workarea
| View Name | Description |
|---|---|
| GV$SQL_WORKAREA | This view displays the workarea statistics of all operators executed by SQL automatic memory management. |
| GV$SQL_WORKAREA_ACTIVE | This view displays the workarea information of active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | This view displays the workarea statistics of all operators executed by SQL automatic memory management. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | This view queries some information about the SQL workarea, including the maximum available memory, current used memory, and current hold memory. |
| V$SQL_WORKAREA | This view displays the workarea statistics of all operators executed by SQL automatic memory management. |
| V$SQL_WORKAREA_ACTIVE | This view displays the workarea information of active operators. |
| V$SQL_WORKAREA_HISTOGRAM | This view displays the workarea statistics of all operators executed by SQL automatic memory management. |
WR related
| View Name | Description |
|---|---|
| GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM | This view displays the histogram information of the query execution time of all nodes in the current tenant. |
| GV$OB_RES_MGR_SYSSTAT | This view displays the statistics of resource groups in all OBServer nodes of the current tenant. |
| V$OB_RES_MGR_SYSSTAT | This view displays the statistics of resource groups in the current OBServer node of the current tenant. |
| GV$OB_SQLSTAT | This view displays the basic performance statistics of SQL statements in the cluster. Each SQL statement is represented as a row (i.e., each unique combination of SQL_ID and Plan_Hash is a row). |
| V$OB_SQLSTAT | This view displays the basic performance statistics of SQL statements on the current node. Each SQL statement is represented as a row (i.e., each unique combination of SQL_ID and Plan_Hash is a row). |
| GV$OB_SESS_TIME_MODEL | This view displays the session-level Time Model statistics in the cluster. |
| V$OB_SESS_TIME_MODEL | This view displays the session-level Time Model statistics on the current node. |
| GV$OB_SYS_TIME_MODEL | This view displays the tenant-level Time Model statistics in the cluster. |
| V$OB_SYS_TIME_MODEL | This view displays the tenant-level Time Model statistics on the current node. |
| V$OB_QUERY_RESPONSE_TIME_HISTOGRAM | This view displays the histogram information of the query execution time of the current node in the current tenant. |
Transaction-related views
| View name | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | This view displays the OBServer-level major compaction progress of the tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | This view displays the major compaction suggestions. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | This view displays the major compaction diagnostic information. |
| GV$OB_TABLET_COMPACTION_HISTORY | This view displays the major compaction history at the tablet level. |
| GV$OB_TABLET_COMPACTION_PROGRESS | This view displays the major compaction progress at the tablet level. |
| GV$OB_TRANSACTION_PARTICIPANTS | This view displays the transaction participants on all OBServer nodes. |
| GV$SYSTEM_EVENT | This view displays some wait events at the tenant system level on all servers, and counts the number of occurrences, wait time, and timeout count for each type of wait event. |
| GV$GLOBAL_TRANSACTION | This view displays the information about active global transactions. |
| V$OB_COMPACTION_PROGRESS | This view displays the major compaction progress at the server level for the tenant. |
| V$OB_COMPACTION_SUGGESTIONS | This view displays the major compaction suggestions. |
| V$OB_COMPACTION_DIAGNOSE_INFO | This view displays the major compaction diagnostic information. |
| V$OB_TABLET_COMPACTION_HISTORY | This view displays the major compaction history at the tablet level. |
| V$OB_TABLET_COMPACTION_PROGRESS | This view displays the major compaction progress at the tablet level. |
| V$OB_TRANSACTION_PARTICIPANTS | This view displays the transaction participants on all OBServer nodes. |
| V$SYSTEM_EVENT | This view displays some wait events at the tenant system level on the current server, and counts the number of occurrences, wait time, and timeout count for each type of wait event. |
| V$GLOBAL_TRANSACTION | This view displays the information about active global transactions. |
| GV$OB_GLOBAL_TRANSACTION | This view displays the information about all XA transactions in the cluster. |
| V$OB_GLOBAL_TRANSACTION | This view displays the information about all XA transactions with the current node as the original scheduler. |
Time zones
| View name | Description |
|---|---|
| V$TIMEZONE_NAMES | Displays the valid time zone names. |
Encrypted tables
| View name | Description |
|---|---|
| V$OB_ENCRYPTED_TABLES | Displays the encryption status of tables that have encryption enabled. |
| V$ENCRYPTED_TABLESPACES | Displays the encryption status of tablespaces that have encryption enabled. |
DBLINK
| View name | Description |
|---|---|
| GV$DBLINK | Displays all database links (IN_TRANSACTION=YES) opened after the query sessions initiated from this view. These database links must be committed or rolled back before they are closed. |
| V$DBLINK | Displays all database links (IN_TRANSACTION=YES) opened after the query sessions initiated from this view. These database links must be committed or rolled back before they are closed. |