Views in the sys tenant
Dictionary views
Views related to tables and columns
| View | Description |
|---|---|
| oceanbase.CDB_IND_COLUMNS | Displays the column information of the index tables of all tenants. |
| oceanbase.CDB_INDEXES | Displays the indexes of all tenants. |
| oceanbase.CDB_TABLES | Displays the information about tables in all tenants. |
| oceanbase.CDB_OB_TABLEGROUP_TABLES | Displays the associations between table groups and tables of all tenants in the sys tenant. Tables that do not belong to a table group are not displayed. |
| oceanbase.CDB_TAB_COLS | Displays the column information of the table and view objects in all tenants. |
| oceanbase.CDB_TAB_COLS_V$ | Displays the column information of the table and view objects in all tenants. |
| oceanbase.DBA_OB_TABLEGROUP_TABLES | Displays the associations between table groups and tables. Tables that do not belong to a table group are not displayed. |
| oceanbase.DBA_PART_KEY_COLUMNS | Displays the partitioning key columns of all partitioned objects in the database. |
| oceanbase.DBA_SUBPART_KEY_COLUMNS | Displays the subpartitioning key columns of all partitioned objects in the database. |
| oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO | Displays the information about column checksum inconsistencies between the index table (including global and local indexes) and the primary table. |
| oceanbase.CDB_OB_TABLE_LOCATIONS | Displays the locations of tables or partitions, including system tables, user tables, and index tables. |
| oceanbase.DBA_OB_TABLE_LOCATIONS | Displays the locations of tables or partitions, including system tables, user tables, and index tables. |
| information_schema.TABLESPACES | Displays the information about tablespaces.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
Views related to the InnoDB storage engine
| View | Description |
|---|---|
| information_schema.INNODB_BUFFER_PAGE | Displays the information about all buffer pages in the buffer pool.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_BUFFER_PAGE_LRU | Displays the least recently used (LRU) sorting information of pages in the InnoDB buffer pool.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_BUFFER_POOL_STATS | Displays the statistics of the InnoDB buffer pool.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_CMP | Displays the status of operations related to compressed InnoDB tables.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_CMP_PER_INDEX | Displays the information about operations related to compressed InnoDB tables and indexes.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_CMP_PER_INDEX_RESET | Displays the reset time of operations related to compressed InnoDB tables and indexes.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_CMP_RESET | Displays the operation status of compressed InnoDB tables.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_CMPMEM | Displays the status of compressed pages in the InnoDB buffer pool.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_CMPMEM_RESET | Displays the reset status of compressed pages in the InnoDB buffer pool.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_SYS_DATAFILES | Displays the data file paths of InnoDB files in each table and general tablespaces.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_SYS_INDEXES | Displays the metadata of InnoDB indexes.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_SYS_TABLES | Displays the metadata of InnoDB tables.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_SYS_TABLESPACES | Displays the metadata of InnoDB table files and general tablespaces.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_SYS_TABLES | Displays the low-level status of InnoDB tables.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_SYS_VIRTUAL | Displays the metadata of virtual columns generated in InnoDB.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_TEMP_TABLE_INFO | Displays the temporary InnoDB tables created by active users.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_METRICS | Displays the performance information of InnoDB.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
Views related to outlines
| View | Description |
|---|---|
| oceanbase.DBA_OB_OUTLINES | Displays the information about the execution plan outlines in the current tenant. |
| oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL | Displays the information about the throttling rule outlines in the current tenant. |
| oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY | Displays the history of execution plans and throttling rule outlines in the current tenant. |
Views related to general database information
| View | Description |
|---|---|
| oceanbase.CDB_OB_DATABASES | Displays the database metadata of all tenants in the sys tenant. |
| oceanbase.CDB_OB_MAJOR_COMPACTION | Displays the global major compaction information of all tenants in the sys tenant. |
| oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION | Displays the major compaction information of each zone of all tenants in the sys tenant. |
| oceanbase.DBA_OB_DATABASES | Displays the database metadata of tenants. |
| oceanbase.DBA_OB_MAJOR_COMPACTION | Displays the global major compaction information of the current tenant. |
| oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY | Displays the RootService event history. |
| oceanbase.DBA_OB_SERVER_JOBS | Displays all jobs related to OBServer nodes. |
| oceanbase.DBA_OB_SERVERS | Displays the information about all OBServer nodes. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | Displays the information about the major compactions of zones of the current tenant. |
| oceanbase.DBA_OB_ZONES | Displays the information about all zones. |
| oceanbase.CDB_OB_FREEZE_INFO | Displays the version information generated by major compactions. |
| oceanbase.DBA_OB_FREEZE_INFO | Displays the version information generated by major compactions. |
| information_schema.events | Displays the information about all events. |
Views related to partitions
| View | Description |
|---|---|
| oceanbase.CDB_IND_PARTITIONS | Displays the partitioning information of the index tables of all tenants. |
| oceanbase.CDB_PART_INDEXES | Displays the partitioning information of the index tables of all tenants. |
| oceanbase.CDB_PART_TABLES | Displays the partitioning information of the partitioned tables of all tenants. |
| oceanbase.CDB_SUBPARTITION_TEMPLATES | Displays the subpartitioning information of the partitioned tables of all tenants. |
| oceanbase.CDB_TAB_PARTITIONS | Displays the partitioning information of the partitioned tables of all tenants. |
| oceanbase.CDB_TAB_SUBPARTITIONS | Displays the subpartitioning information of the partitioned tables of all tenants. |
| oceanbase.DBA_IND_PARTITIONS | Displays the information about the partitions and subpartitions of indexes. |
| oceanbase.DBA_PART_INDEXES | Displays the information about partitions of all partitioned indexes. |
| oceanbase.DBA_PART_TABLES | Displays the information about partitioned tables. |
| oceanbase.DBA_TAB_PARTITIONS | Displays the multi-level partitioning information, partition storage parameters, and partition statistics accessible to the current user. |
| oceanbase.DBA_TAB_SUBPARTITIONS | Displays, for each subpartition, the subpartition name, the names of the table and partition to which it belongs, its storage attributes, and statistics generated by the DBMS_STATS package. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | Displays the information about all subpartition templates. |
Views related to load balancing
| View | Description |
|---|---|
| oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS | Displays the ongoing partition transfer tasks in all tenants. |
| oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the historical partition transfer tasks executed in all tenants. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS | Displays the ongoing partition transfer tasks in the current tenant. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the historical partition transfer tasks executed in the current tenant. |
Views related to full-text indexes
| View | Description |
|---|---|
| information_schema.INNODB_FT_BEING_DELETED | Displays the information about the full-text indexes that are being deleted.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_FT_CONFIG | Displays the configuration information of the InnoDB full-text search engine.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_FT_DELETED | Displays the information about the full-text indexes marked as deleted.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_FT_INDEX_CACHE | Displays the cache status of InnoDB full-text indexes.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_SYS_FIELDS | Displays the metadata of key columns related to InnoDB indexes. The information in this view is equivalent to that in the SYS_FIELDS table in the InnoDB data dictionary.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
Views related to sessions
| View | Description |
|---|---|
| oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY | Displays the history of deadlock events. After you log in as the root user to the sys tenant, you can view the deadlock event history of all tenants. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the history of deadlock events. You can query this view from a user tenant for the history of deadlock events of the current tenant. |
| oceanbase.DBA_OB_SERVER_EVENT_HISTORY | Displays the event history on an OBServer node. |
Views related to backup and restore
| View | Description |
|---|---|
| oceanbase.CDB_OB_RESTORE_PROGRESS | Displays the current execution progress of physical restore jobs. |
| oceanbase.CDB_OB_RESTORE_HISTORY | Displays the states of physical restore jobs upon completion. |
| oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES | Displays the status of backup pieces in each backup set. |
| oceanbase.CDB_OB_BACKUP_SET_FILES | Displays the file status of backup sets. |
| oceanbase.CDB_OB_BACKUP_JOBS | Displays the backup jobs in all tenants in the cluster. Each time a user initiates a backup job, a job record is generated. |
| oceanbase.CDB_OB_BACKUP_JOB_HISTORY | Displays the history of backup jobs of all tenants in the cluster. |
| oceanbase.CDB_OB_BACKUP_TASKS | Displays the backup tasks in all tenants in the cluster. A task record is generated for each backup set. The task records and job records are in one-to-one mapping. |
| oceanbase.CDB_OB_BACKUP_TASK_HISTORY | Displays the history of backup tasks in all tenants in the cluster. |
| oceanbase.DBA_OB_BACKUP_JOBS | Displays the backup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOB_HISTORY | Displays the history of backup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASKS | Displays the history of backup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASK_HISTORY | Displays the history of backup tasks in the current tenant. |
| oceanbase.DBA_OB_BACKUP_SET_FILES | Displays the file status of backup sets. |
| oceanbase.DBA_OB_RESTORE_PROGRESS | Displays ongoing restore jobs. |
| oceanbase.DBA_OB_RESTORE_HISTORY | Displays the restore jobs that have been completed. |
| oceanbase.DBA_OB_ARCHIVE_DEST | Displays the configuration of archive paths. |
| oceanbase.CDB_OB_ARCHIVE_DEST | Displays the configuration of archive paths. |
| oceanbase.CDB_OB_BACKUP_PARAMETER | Displays the backup parameters. |
| oceanbase.CDB_OB_BACKUP_DELETE_JOBS | Displays the execution progress of backup cleanup jobs in the current tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY | Displays the history of backup cleanup jobs that have been executed in the current tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASKS | Displays the information about the backup set/piece cleanup tasks that are being executed in the current tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY | Displays the history of the backup set/piece cleanup tasks that have been completed in the current tenant. |
| oceanbase.CDB_OB_BACKUP_DELETE_POLICY | Displays the cleanup strategies for retention period-based cleanup and automatic cleanup jobs in the current tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO | Displays the information about backup destinations of backup and restore in the current tenant. |
| oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the history of backup destinations of backup and restore in the current tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | Displays the information about backup destinations of backup and restore in the current tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the history of backup destinations of backup and restore in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_POLICY | Displays the cleanup strategies for retention period-based cleanup and automatic cleanup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOBS | Displays the execution progress of backup cleanup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY | Displays the history of backup cleanup jobs that have been executed in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | Displays the information about the backup set/piece cleanup tasks that are being executed in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY | Displays the history of the backup set/piece cleanup tasks that have been completed in the current tenant. |
| oceanbase.DBA_OB_ARCHIVELOG | Displays the log backup status for each path. |
| oceanbase.DBA_OB_ARCHIVELOG_SUMMARY | Displays the status of all historical and current log backups. |
| oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES | Displays the status of backup pieces in each backup set. |
| oceanbase.CDB_OB_ARCHIVELOG | Displays the log archiving status for each path. |
| oceanbase.CDB_OB_ARCHIVELOG_SUMMARY | Displays the status of all historical and current log archiving tasks. |
| oceanbase.CDB_OB_RECOVER_TABLE_JOBS | Displays the information about table-level restore jobs. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOBS | Displays the information about table-level restore jobs. |
| oceanbase.CDB_OB_IMPORT_TABLE_JOBS | Displays the information about import jobs. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOBS | Displays the information about import jobs. |
| oceanbase.CDB_OB_IMPORT_TABLE_TASKS | Displays the records of table-level cross-tenant import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASKS | Displays the records of table-level import tasks. |
| oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY | Displays the results of table-level restore jobs. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY | Displays the results of table-level restore jobs. |
| oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY | Displays the results of import jobs. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY | Displays the results of import jobs. |
| oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY | Displays the history of table-level cross-tenant import tasks. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY | Displays the history of table-level cross-tenant import tasks. |
Views related to statistics and histograms
| View | Description |
|---|---|
| oceanbase.DBA_TAB_STATISTICS | Displays the optimizer statistics of all tables in the database. |
| oceanbase.DBA_TAB_COL_STATISTICS | Displays the column statistics and histograms on all tables in the database. |
| oceanbase.DBA_PART_COL_STATISTICS | Displays the column statistics and histograms of all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_COL_STATISTICS | Displays the column statistics and histograms of all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_HISTOGRAMS | Displays the column histograms of all tables in the database. |
| oceanbase.DBA_PART_HISTOGRAMS | Displays the histograms of all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_HISTOGRAMS | Displays the histograms of all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_STATS_HISTORY | Displays the history of the table statistics of all tables in the database. |
| oceanbase.DBA_IND_STATISTICS | Displays the optimizer statistics of all indexes in the database. |
| oceanbase.DBA_TAB_MODIFICATIONS | Displays the modification history of all tables in the database since the table statistics were collected the last time. |
| oceanbase.CDB_TAB_COL_STATISTICS | Displays column statistics for the sys tenant. |
Views related to tenants
| View | Description |
|---|---|
| oceanbase.DBA_OBJECTS | Displays all database objects in the database. The definition of this view is the same as that of the ALL_OBJECTS view. |
| oceanbase.CDB_OBJECTS | Displays the information about objects of all tenants in the sys tenant. |
| oceanbase.DBA_OB_TENANTS | Displays the basic information of all tenants, including information about the sys tenant, user tenants, and meta tenants. You can determine the tenant type based on the TENANT_TYPE column. |
| oceanbase.DBA_OB_TENANT_JOBS | Displays the tenant-level job information. |
| oceanbase.CDB_OB_SYS_VARIABLES | Displays the information about system variables of all tenants in the sys tenant. |
Views related to resources
| View | Description |
|---|---|
| oceanbase.DBA_OB_RESOURCE_POOLS | Displays the information about the resource pools of all tenants. |
| oceanbase.DBA_OB_UNIT_JOBS | Displays all unit-related jobs. |
| oceanbase.DBA_OB_UNITS | Displays the information about the units of all tenants. |
| oceanbase.DBA_OB_UNIT_CONFIGS | Displays the information about the unit configs of all tenants. |
| oceanbase.DBA_OB_SEQUENCE_OBJECTS | Displays all sequences in the database. |
Views related to replicas and logs
| View | Description |
|---|---|
| oceanbase.CDB_IND_SUBPARTITIONS | Displays the information about all index subpartitions in the database. |
| oceanbase.CDB_OB_LS_LOCATIONS | Displays the distribution of the log stream replicas of all tenants. |
| oceanbase.CDB_OB_TABLEGROUPS | Displays the metadata of table groups of all tenants in the sys tenant, especially the partition information of the table groups. |
| oceanbase.CDB_OB_TABLEGROUP_PARTITIONS | Displays the partitioning information of the partitioned table groups of all tenants in the sys tenant. |
| oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS | Displays the subpartitioning information of the partitioned table groups of all tenants in the sys tenant. |
| oceanbase.CDB_OB_TABLET_TO_LS | Displays the list of tablets of all tenants in the sys tenant and the log streams to which these tablets belong. |
| oceanbase.CDB_OB_TABLET_REPLICAS | Displays the information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the joint key string of <TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.CDB_PART_KEY_COLUMNS | Displays the partitioning information of partitioned objects (tables and indexes) of all tenants. |
| oceanbase.CDB_SUBPART_KEY_COLUMNS | Displays the subpartitioning information of partitioned objects (tables and indexes) of all tenants. |
| oceanbase.DBA_IND_SUBPARTITIONS | Displays the information about all index subpartitions in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | Displays the information about the partitions of partitioned table groups. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays the information about the subpartitions of partitioned table groups. |
| oceanbase.DBA_OB_TABLEGROUPS | Displays the metadata of table groups, mainly the partition information of the table groups. |
| oceanbase.DBA_OB_TABLET_REPLICAS | Displays the information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the joint key string of <TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.DBA_OB_TABLET_TO_LS | Displays the list of tablets in the current tenant and information about the log streams to which these tablets belong. |
| oceanbase.DBA_OB_LS_LOCATIONS | Displays the distribution of the log stream replicas in the current tenant. |
| oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO | Displays the information about data inconsistencies between tablet replicas. |
| oceanbase.CDB_OB_LS | Displays the status and restore progress of log streams. |
| oceanbase.DBA_OB_LS | Displays the status and restore progress of log streams. |
Views related to WR
| View | Description |
|---|---|
| oceanbase.DBA_WR_SNAPSHOT | Displays the snapshots of the current tenant. |
| oceanbase.CDB_WR_SNAPSHOT | Displays the snapshots of all tenants. |
| oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY | Displays the persisted Active Session History (ASH) data of the current tenant. |
| oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY | Displays the persisted ASH data of all tenants. |
| oceanbase.DBA_WR_STATNAME | Displays the names of system statistical items of the current tenant. |
| oceanbase.CDB_WR_STATNAME | Displays the names of system statistical items of all tenants. |
| oceanbase.DBA_WR_SYSSTAT | Displays the details about system statistical items of the current tenant. |
| oceanbase.CDB_WR_SYSSTAT | Displays the details about system statistical items of all tenants. |
| oceanbase.DBA_WR_CONTROL | Displays Workload Repository (WR) configurations. |
| oceanbase.CDB_WR_CONTROL | Displays WR configurations. |
| oceanbase.CDB_WR_SYSTEM_EVENT | Displays the persisted tenant-level wait events of all tenants. |
| oceanbase.DBA_WR_SYSTEM_EVENT | Displays the persisted tenant-level wait events of the current tenant. |
| oceanbase.CDB_WR_EVENT_NAME | Displays the persisted tenant-level wait events of all tenants. |
| oceanbase.DBA_WR_EVENT_NAME | Displays the persisted tenant-level wait events of the current tenant. |
| oceanbase.CDB_WR_SQLSTAT | Displays the basic performance statistics of SQL statements executed in all tenants. Each row indicates one SQL statement. To be specific, each row is uniquely identified by SQL_ID and Plan_Hash. |
| oceanbase.DBA_WR_SQLSTAT | Displays the basic performance statistics of SQL statements executed in the current tenant. Each row indicates one SQL statement. To be specific, each row is uniquely identified by SQL_ID and Plan_Hash. |
| oceanbase.CDB_WR_SYS_TIME_MODEL | Displays the WR data for the time model statistical items of all tenants. |
| oceanbase.DBA_WR_SYS_TIME_MODEL | Displays the WR data for the time model statistical items of the current tenant. |
| oceanbase.CDB_WR_SQLTEXT | Displays the SQL statements of all tenants collected by WR. |
| oceanbase.DBA_WR_SQLTEXT | Displays the SQL statements of the current tenant collected by WR. |
Views related to foreign keys
| View | Description |
|---|---|
| information_schema.INNODB_SYS_FOREIGN | Displays the metadata of InnoDB foreign keys. The information in this view is equivalent to that in the SYS_FOREIGN table in the InnoDB data dictionary.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_SYS_FOREIGN_COLS | Displays the status of InnoDB foreign key columns. The information in this view is equivalent to that in the SYS_FOREIGN_COLS table in the InnoDB data dictionary.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
Views related to OBKV
| View | Description |
|---|---|
| oceanbase.CDB_OB_KV_TTL_TASKS | Displays the ongoing time-to-live (TTL) tasks in all tenants. You can query this view only from the sys tenant. |
| oceanbase.CDB_OB_KV_TTL_TASK_HISTORY | Displays the historical TTL tasks in all tenants. You can query this view only from the sys tenant. |
| oceanbase.DBA_OB_KV_TTL_TASKS | Displays the ongoing TTL tasks in the current tenant. |
| oceanbase.DBA_OB_KV_TTL_TASK_HISTORY | Displays the historical TTL tasks in the current tenant. |
Performance views
Views related to event statistics
| View | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | Displays the progress of OBServer node-level compactions in tenants. |
| GV$OB_COMPACTION_SUGGESTIONS | Displays the suggestions on compactions. |
| GV$OB_PROCESSLIST | Displays the information about sessions on all OBServer nodes of tenants. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | Displays the compaction diagnostic information. |
| GV$OB_TABLET_COMPACTION_HISTORY | Displays the tablet-level compaction history. |
| GV$OB_TABLET_COMPACTION_PROGRESS | Displays the progress of tablet-level compactions. |
| GV$OB_TRANSACTION_PARTICIPANTS | Displays the information about the transaction participants on all OBServer nodes. |
| GV$SESSION_EVENT | Displays the session-level wait events of all OBServer nodes in the cluster. |
| GV$SESSION_WAIT | Displays the information about the current or previous wait events of all sessions on all OBServer nodes, including the event names and the amount of time spent on waiting. |
| GV$SESSION_WAIT_HISTORY | Displays the latest 10 wait events of all sessions on all OBServer nodes. |
| GV$SYSTEM_EVENT | Displays all tenant-level wait events in the cluster. |
| GV$SESSTAT | Displays the session-level statistical events on all OBServer nodes. |
| GV$SYSSTAT | Displays the information about tenant-level statistical events on all OBServer nodes. |
| GV$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$OB_COMPACTION_PROGRESS | Displays the progress of OBServer node-level compactions in tenants. |
| V$OB_COMPACTION_SUGGESTIONS | Displays the suggestions on compactions. |
| V$OB_PROCESSLIST | Displays the information about sessions on the current OBServer node. |
| V$OB_COMPACTION_DIAGNOSE_INFO | Displays the compaction diagnostic information. |
| V$OB_TABLET_COMPACTION_HISTORY | Displays the tablet-level compaction history. |
| V$OB_TABLET_COMPACTION_PROGRESS | Displays the progress of tablet-level compactions. |
| V$OB_TRANSACTION_PARTICIPANTS | Displays the information about the transaction participants on all OBServer nodes. |
| V$STATNAME | Displays the definitions of all statistical events. |
| V$EVENT_NAME | Displays the definitions of all statistical events on the current OBServer node. |
| V$SESSION_WAIT | Displays the details about the current wait events in each session. Each wait event has three parameters. |
| V$SESSION_WAIT_HISTORY | Displays the latest 10 wait events of each session. |
| V$SESSTAT | Displays an overview of session-level statistical events. |
| V$SYSSTAT | Displays the information about tenant-level statistical events on the current OBServer node. |
| V$SYSTEM_EVENT | Displays the tenant-level wait events. |
| GV$SESSION_LONGOPS | Displays the progress of index creation in the cluster. |
| V$SESSION_LONGOPS | Displays the progress of index creation on the current OBServer node. |
Views related to monitoring statistics
| View | Description |
|---|---|
| GV$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the data transfer layer (DTL) intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
Views related to I/O statistics
| View | Description |
|---|---|
| GV$OB_IO_CALIBRATION_STATUS | Displays the execution status of the I/O calibration task. |
| V$OB_IO_CALIBRATION_STATUS | Displays the execution status of the I/O calibration task. |
| GV$OB_IO_BENCHMARK | Displays the disk calibration data used by the I/O module. |
| V$OB_IO_BENCHMARK | Displays the disk calibration data used by the I/O module. |
Views related to cache statistics
| View | Description |
|---|---|
| GV$OB_MEMORY | Displays the tenant-level memory statistics. |
| V$OB_MEMORY | Displays the tenant-level memory statistics. |
| GV$OB_MEMSTORE | Displays the memory usage of all MemTables of all tenants on all OBServer nodes. |
| V$OB_MEMSTORE | Displays session-level MemStore statistics. |
| GV$OB_MEMSTORE_INFO | Displays the details about MemTables of all partitions of all tenants on all OBServer nodes. |
| V$OB_MEMSTORE_INFO | Displays the details about MemTables of all partitions of all tenants on all OBServer nodes. |
| GV$OB_SSTABLES | Displays the SSTables of tenants. |
| V$OB_SSTABLES | Displays the SSTables of tenants. |
| GV$OB_TENANT_MEMORY | Displays the memory usage of each tenant in the cluster. |
| V$OB_TENANT_MEMORY | Displays the memory usage of each tenant in the current observer process. |
Views related to SQL statistics
| View | Description |
|---|---|
| GV$OB_PLAN_CACHE_STAT | Displays the outlines of the current tenant. It is used for outline migration. |
| V$OB_PLAN_CACHE_STAT | Displays the overall status of each plan cache of the current tenant on all OBServer nodes. |
| GV$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan caches on all OBServer nodes. |
| V$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan cache on the current OBServer node. |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan caches of all OBServer nodes. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans that are cached in the plan cache on the current OBServer node. |
| GV$OB_PS_STAT | Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items. |
| V$OB_PS_STAT | Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items. |
| GV$OB_PS_ITEM_INFO | Displays the monitoring information of prepared statements, including the basic information of all prepared statements in the PS cache. |
| V$OB_PS_ITEM_INFO | Displays the monitoring information of prepared statements, including the basic information of all prepared statements in the PS cache. |
| GV$OB_PX_P2P_DATAHUB | Displays the information about data transmission operations that are executed in parallel. |
| GV$OB_PX_TARGET_MONITOR | Displays the usage of PX worker threads on all OBServer nodes. |
| V$OB_PX_TARGET_MONITOR | Displays the usage of PX worker threads on the current OBServer node. |
| GV$OB_SQL_AUDIT | Displays the statistics of each SQL request on all OBServer nodes, such as the source and execution status. |
| V$OB_SQL_AUDIT | Displays the statistics of each SQL request on the current OBServer node, such as the source and execution status. |
| GV$SQL_PLAN_MONITOR | Displays plan-level statistics of slow queries on all OBServer nodes. Each slow query corresponds to one row in this view. It also records the trace information of the plan. |
| V$SQL_PLAN_MONITOR | Displays the operation-level statistics of slow queries. Each operation corresponds to one row in this view. |
| V$SQL_MONITOR_STATNAME | Displays the numbers in the OTHERSTAT_X_ID column of the GV$SQL_PLAN_MONITOR view. |
| GV$OB_FLT_TRACE_CONFIG | Displays the information about end-to-end diagnostics. |
| GV$OB_SQLSTAT | Displays the basic performance statistics of SQL statements in the cluster. Each row indicates one SQL statement. To be specific, each row is uniquely identified by SQL_ID and Plan_Hash. |
| V$OB_SQLSTAT | Displays the basic performance statistics of SQL statements on the current OBServer node. Each row indicates one SQL statement. To be specific, each row is uniquely identified by SQL_ID and Plan_Hash. |
Views related to log statistics
| View | Description |
|---|---|
| GV$OB_LOG_STAT | Displays the Palf status. |
| GV$OB_LS_SNAPSHOTS | Displays the information about persisted log stream snapshots in all units. |
| V$OB_LOG_STAT | Displays the Palf status. |
Views related to network statistics
| View | Description |
|---|---|
| GV$OB_RPC_OUTGOING | Displays the emote procedure call (RPC) sending statistics of all OBServer nodes. |
| GV$OB_RPC_INCOMING | Displays the RPC receiving statistics of all OBServer nodes. |
| V$OB_RPC_OUTGOING | Displays the data sending status of all RPC packet codes in each tenant on the current OBServer node. |
| V$OB_RPC_INCOMING | Displays the data receiving status of all RPC packet codes in each tenant on the current OBServer node. |
Views related to sessions
| View | Description |
|---|---|
| GV$OB_SESSION | Displays the information about sessions created on all OBServer nodes. |
Views related to database statistics
| View | Description |
|---|---|
| GV$OB_KVCACHE | Displays the information about the KV cache on each OBServer node. |
| GV$OB_PARAMETERS | Displays the parameters on all OBServer nodes of tenants. |
| GV$OB_SERVER_SCHEMA_INFO | Displays the information about schemas on all OBServer nodes. |
| GV$OB_SERVERS | Displays the information about all OBServer nodes. |
| GV$OB_UNITS | Displays the information about the units on the OBServer nodes where tenants reside. You can view the units of all OBServer nodes in the current cluster from the sys tenant. |
| V$OB_KVCACHE | Displays the information about the KV cache on each OBServer node. |
| V$OB_PARAMETERS | Displays the parameters on the current OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | Displays the information about schemas on all OBServer nodes. |
| V$OB_SERVERS | Displays the information about the current OBServer node. |
| V$OB_UNITS | Displays the information about the units on the current OBServer node. |
| GV$DML_STATS | Displays the information about the DML operations performed in the current user table. |
| V$DML_STATS | Displays the information about the DML operations performed in the current user table. |
| V$OB_COMPATIBILITY_CONTROL | Displays all features that support product behavior compatibility control based on the released OceanBase Database versions. |
Views related to time model statistics
| View | Description |
|---|---|
| GV$OB_SESS_TIME_MODEL | Displays the session-level time model statistical items of the cluster. |
| V$OB_SESS_TIME_MODEL | Displays the session-level time model statistical items of the current OBServer node. |
| GV$OB_SYS_TIME_MODEL | Displays the tenant-level time model statistical items of the cluster. |
| V$OB_SYS_TIME_MODEL | Displays the tenant-level time model statistical items of the current OBServer node. |
Views related to minor compactions
| View | Description |
|---|---|
| GV$OB_MERGE_INFO | Displays the statistics of compactions that are completed in the cluster. |
| V$OB_MERGE_INFO | Displays the statistics of compactions that are completed in the cluster. |
Views related to threads
| View | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | Displays the execution information of each PX worker thread in parallel execution. |
| V$OB_PX_WORKER_STAT | Displays the execution information of each PX worker thread in parallel execution. |
| GV$OB_TENANT_RUNTIME_INFO | Displays the information about quotas of queues and threads in tenant threads. |
| V$OB_TENANT_RUNTIME_INFO | Displays the information about quotas of queues and threads in tenant threads. |
Views related to workareas
| View | Description |
|---|---|
| GV$SQL_WORKAREA | Displays the workarea statistics of all operators previously subject to automatic SQL memory management. |
| GV$SQL_WORKAREA_ACTIVE | Displays the workarea information of active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | Displays the cumulative execution statistics of all workareas, such as the total number of fully in-memory executions that consumed 1 MB to 2 MB of memory and the number of executions in one-pass mode. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | Displays the overall information about the SQL workarea, such as the maximum available memory, current memory usage, and currently held memory. |
| V$SQL_WORKAREA | Displays the workarea statistics of all operators previously subject to automatic SQL memory management. |
| V$SQL_WORKAREA_ACTIVE | Displays the workarea information of active operators. |
| V$SQL_WORKAREA_HISTOGRAM | Displays the cumulative execution statistics of all workareas, such as the total number of fully in-memory executions that consumed 1 MB to 2 MB of memory and the number of executions in one-pass mode. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | Displays the overall information about the SQL workarea, including the maximum available memory, current memory usage, and currently held memory. |
Views related to encrypted tables
| View | Description |
|---|---|
| V$OB_ENCRYPTED_TABLES | Displays the encryption status of tables with encryption enabled. |
| V$ENCRYPTED_TABLESPACES | Displays the encryption status of tablespaces with encryption enabled. |
Views related to transactions
| View | Description |
|---|---|
| GV$LATCH | Displays the information about the latches on all OBServer nodes in the cluster. |
| V$LATCH | Displays the information about the latches on all OBServer nodes in the cluster. |
Views in a MySQL tenant
Dictionary views
Views related to the HELP command
| View | Description |
|---|---|
| mysql.help_topic | mysql.help_topic is used to generate the HELP command in coordination with the following three tables: mysql.help_category, mysql.help_relation, and mysql.help_keyword tables. |
| mysql.help_category | mysql.help_category is used to generate the HELP command in coordination with the following three tables: mysql.help_relation, mysql.help_topic, and mysql.help_keyword. |
| mysql.help_keyword | mysql.help_keyword is used to generate the HELP command in coordination with the following three tables: mysql.help_relation, mysql.help_topic, and mysql.help_category. |
| mysql.help_relation | mysql.help_relation is used to generate the HELP command in coordination with the following three tables: mysql.help_category, mysql.help_topic, and mysql.help_keyword. |
Views related to SPM
| View | Description |
|---|---|
| oceanbase.DBA_SQL_PLAN_BASELINES | Displays the SQL plan baseline in SQL Plan Management (SPM). |
| oceanbase.DBA_SQL_MANAGEMENT_CONFIG | Displays the configuration parameters in SPM. |
Views related to privileges
| View | Description |
|---|---|
| mysql.db | Displays the information about system-level privileges. |
| mysql.user | Displays the information about user-level privileges. |
| information_schema.COLUMN_PRIVILEGES | Displays the information about column privileges. |
| information_schema.SCHEMA_PRIVILEGES | Displays the information about database privileges. |
| information_schema.TABLE_PRIVILEGES | Displays the information about table privileges. |
| information_schema.USER_PRIVILEGES | Displays the information about user privileges. |
Views related to OBKV
| View | Description |
|---|---|
| oceanbase.DBA_OB_KV_TTL_TASKS | Displays the ongoing TTL tasks in the current tenant. |
| oceanbase.DBA_OB_KV_TTL_TASK_HISTORY | Displays the historical TTL tasks in the current tenant. |
Views related to schedulers
| View | Description |
|---|---|
| oceanbase.DBA_SCHEDULER_JOBS | Displays all scheduler jobs in the database. |
Views related to storage
| View | Description |
|---|---|
| mysql.proc | Displays the information about stored procedures. |
| information_schema.ENGINES | Displays the information about storage engines. |
| information_schema.PARAMETERS | Displays the information about parameters and return values for stored procedures. |
| information_schema.ROUTINES | Displays the information about routines. |
Views related to time zones
| View | Description |
|---|---|
| mysql.time_zone | Displays the information about time zones. It is a system view. |
| mysql.time_zone_name | Displays the names of time zones. It is a system view. |
| mysql.time_zone_transition | Displays the information about time zone conversions. It is a system view. |
| mysql.time_zone_transition_type | Displays the information about time zone conversion types. It is a system view. |
Views related to character sets
| View | Description |
|---|---|
| information_schema.CHARACTER_SETS | Displays the information about character sets in OceanBase Database. |
| information_schema.COLLATIONS | Displays the information about collations for each character set. |
| information_schema.COLLATION_CHARACTER_SET_APPLICABILITY | Displays the correspondence between character sets and collations. |
Views related to tables and columns
| View | Description |
|---|---|
| information_schema.COLUMNS | Displays the information about columns in tables. |
| information_schema.STATISTICS | Displays the information about table indexes. |
| information_schema.TABLES | Displays the information about tables. |
| information_schema.VIEWS | Displays the information about views. |
| information_schema.VIEW_TABLE_USAGE | Displays the information about tables and views used in the view definition. |
| oceanbase.DBA_OB_TABLEGROUP_TABLES | Displays the associations between table groups and tables. Tables that do not belong to a table group are not displayed. |
| oceanbase.DBA_PART_KEY_COLUMNS | Displays the partitioning key columns of all partitioned objects in the database. |
| oceanbase.DBA_SUBPART_KEY_COLUMNS | Displays the subpartitioning key columns of all partitioned objects in the database. |
| oceanbase.DBA_OB_TABLE_LOCATIONS | Displays the locations of tables or partitions, including system tables, user tables, and index tables. |
| information_schema.TABLESPACES | Displays the information about tablespaces.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
Views related to the InnoDB storage engine
| View | Description |
|---|---|
| information_schema.INNODB_BUFFER_PAGE | Displays the information about all buffer pages in the buffer pool.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_BUFFER_PAGE_LRU | Displays the LRU sorting information of pages in the InnoDB buffer pool.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_BUFFER_POOL_STATS | Displays the statistics of the InnoDB buffer pool.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_CMP | Displays the status of operations related to compressed InnoDB tables.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_CMP_PER_INDEX | Displays the information about operations related to compressed InnoDB tables and indexes.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_CMP_PER_INDEX_RESET | Displays the reset time of operations related to compressed InnoDB tables and indexes.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_CMP_RESET | Displays the operation status of compressed InnoDB tables.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_CMPMEM | Displays the status of compressed pages in the InnoDB buffer pool.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_CMPMEM_RESET | Displays the reset status of compressed pages in the InnoDB buffer pool.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_SYS_DATAFILES | Displays the data file paths of InnoDB files in each table and general tablespaces.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_SYS_INDEXES | Displays the metadata of InnoDB indexes.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_SYS_TABLES | Displays the metadata of InnoDB tables.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_SYS_TABLESPACES | Displays the metadata of InnoDB table files and general tablespaces.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_SYS_TABLES | Displays the low-level status of InnoDB tables.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_SYS_VIRTUAL | Displays the metadata of virtual columns generated in InnoDB.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_TEMP_TABLE_INFO | Displays the temporary InnoDB tables created by active users.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_METRICS | Displays the performance information of InnoDB.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
Views related to outlines
| View | Description |
|---|---|
| oceanbase.DBA_OB_OUTLINES | Displays the information about the execution plan outlines in the current tenant. |
| oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL | Displays the information about the throttling rule outlines in the current tenant. |
| oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY | Displays the history of execution plans and throttling rule outlines in the current tenant. |
Views related to general database information
| View | Description |
|---|---|
| information_schema.GLOBAL_STATUS | Displays the global status information of OceanBase Database. |
| information_schema.GLOBAL_VARIABLES | Displays the information about global variables. |
| information_schema.SCHEMATA | Displays the database metadata. |
| oceanbase.DBA_OB_DATABASES | Displays the database metadata of the current tenant. |
| oceanbase.DBA_OB_MAJOR_COMPACTION | Displays the global major compaction information of the current tenant. |
| oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION | Displays the information about the major compactions of zones. |
| oceanbase.DBA_OB_FREEZE_INFO | Displays the version information generated by major compactions. |
| information_schema.events | Displays the information about all events. |
Views related to partitions
| View | Description |
|---|---|
| information_schema.PARTITIONS | Displays the information about table partitions. |
| oceanbase.DBA_IND_PARTITIONS | Displays the information about the partitions and subpartitions of indexes. |
| oceanbase.DBA_PART_INDEXES | Displays the information about partitions of all partitioned indexes. |
| oceanbase.DBA_PART_TABLES | Displays the information about partitioned tables. |
| oceanbase.DBA_TAB_PARTITIONS | Displays the multi-level partitioning information, partition storage parameters, and partition statistics accessible to the current user. |
| oceanbase.DBA_TAB_SUBPARTITIONS | Displays, for each subpartition, the subpartition name, the names of the table and partition to which it belongs, its storage attributes, and statistics generated by the DBMS_STATS package. |
| oceanbase.DBA_SUBPARTITION_TEMPLATES | Displays the information about all subpartition templates. |
Views related to load balancing
| View | Description |
|---|---|
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS | Displays the ongoing partition transfer tasks in the current tenant. |
| oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the historical partition transfer tasks executed in the current tenant. |
Views related to threads
| View | Description |
|---|---|
| information_schema.PROCESSLIST | Displays the information about threads that are being executed. |
Views related to constraints
| View | Description |
|---|---|
| information_schema.CHECK_CONSTRAINTS | Displays the constraints on tables and columns when the CREATE TABLE operation is performed. |
| information_schema.KEY_COLUMN_USAGE | Displays the information about key columns that have constraints. |
| information_schema.REFERENTIAL_CONSTRAINTS | Displays the metadata of FOREIGN KEY constraints. |
| information_schema.TABLE_CONSTRAINTS | Displays the information about table constraints. |
Views related to full-text indexes
| View | Description |
|---|---|
| information_schema.INNODB_FT_BEING_DELETED | Displays the information about the full-text indexes that are being deleted.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_FT_CONFIG | Displays the configuration information of the InnoDB full-text search engine.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_FT_DELETED | Displays the information about the full-text indexes marked as deleted.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_FT_INDEX_CACHE | Displays the cache status of InnoDB full-text indexes.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_SYS_FIELDS | Displays the metadata of key columns related to InnoDB indexes. The information in this view is equivalent to that in the SYS_FIELDS table in the InnoDB data dictionary.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
Views related to sessions
| View | Description |
|---|---|
| information_schema.SESSION_STATUS | Displays the session status, such as the number of active connections and the database active duration (uptime). |
| information_schema.SESSION_VARIABLES | Displays the information about session variables. |
| oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the history of deadlock events. You can query this view from a user tenant for the history of deadlock events of the current tenant. |
Views related to user login
| View | Description |
|---|---|
| information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS | Displays the number of failed login attempts of different users. |
Views related to backup and restore
| View | Description |
|---|---|
| oceanbase.DBA_OB_BACKUP_JOBS | Displays the backup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_JOB_HISTORY | Displays the history of backup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASKS | Displays the history of backup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_TASK_HISTORY | Displays the history of backup tasks in the current tenant. |
| oceanbase.DBA_OB_BACKUP_SET_FILES | Displays the file status of backup sets. |
| oceanbase.DBA_OB_RESTORE_PROGRESS | Displays ongoing restore jobs. |
| oceanbase.DBA_OB_RESTORE_HISTORY | Displays the restore jobs that have been completed. |
| oceanbase.DBA_OB_ARCHIVE_DEST | Displays the configuration of archive paths. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO | Displays the information about backup destinations of backup and restore in the current tenant. |
| oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the history of backup destinations of backup and restore in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_POLICY | Displays the cleanup strategies for retention period-based cleanup and automatic cleanup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOBS | Displays the execution progress of backup cleanup jobs in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY | Displays the history of backup cleanup jobs that have been executed in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASKS | Displays the information about the backup set/piece cleanup tasks that are being executed in the current tenant. |
| oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY | Displays the history of the backup set/piece cleanup tasks that have been completed in the current tenant. |
| oceanbase.DBA_OB_ARCHIVELOG | Displays the log backup status for each path. |
| oceanbase.DBA_OB_ARCHIVELOG_SUMMARY | Displays the status of all historical and current log backups. |
| oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES | Displays the status of backup pieces in each backup set. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOBS | Displays the information about table-level restore jobs. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOBS | Displays the information about import jobs. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASKS | Displays the records of table-level import tasks. |
| oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY | Displays the results of table-level restore jobs. |
| oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY | Displays the results of import jobs. |
| oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY | Displays the history of table-level cross-tenant import tasks. |
Views related to statistics and histograms
| View | Description |
|---|---|
| oceanbase.DBA_TAB_STATISTICS | Displays the optimizer statistics of all tables in the database. |
| oceanbase.DBA_TAB_COL_STATISTICS | Displays the column statistics and histograms on all tables in the database. |
| oceanbase.DBA_PART_COL_STATISTICS | Displays the column statistics and histograms of all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_COL_STATISTICS | Displays the column statistics and histograms of all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_HISTOGRAMS | Displays the column histograms of all tables in the database. |
| oceanbase.DBA_PART_HISTOGRAMS | Displays the histograms of all partitioned tables in the database. |
| oceanbase.DBA_SUBPART_HISTOGRAMS | Displays the histograms of all subpartitioned tables in the database. |
| oceanbase.DBA_TAB_STATS_HISTORY | Displays the history of the table statistics of all tables in the database. |
| oceanbase.DBA_IND_STATISTICS | Displays the optimizer statistics of all indexes in the database. |
| oceanbase.DBA_TAB_MODIFICATIONS | Displays the modification history of all tables in the database since the table statistics were collected the last time. |
| information_schema.QUERY_RESPONSE_TIME | Displays the data types of RESPONSE TIME histograms for Prometheus to monitor. |
Views related to tenants
| View | Description |
|---|---|
| oceanbase.DBA_OBJECTS | Displays all database objects in the database. The definition of this view is the same as that of the ALL_OBJECTS view. |
| oceanbase.DBA_OB_TENANTS | Displays the basic information of all tenants, including information about the sys tenant, user tenants, and meta tenants. You can determine the tenant type based on the TENANT_TYPE column. |
Views related to resources
| View | Description |
|---|---|
| oceanbase.DBA_OB_SEQUENCE_OBJECTS | Displays all sequences in the database. |
Views related to replicas and logs
| View | Description |
|---|---|
| oceanbase.DBA_IND_SUBPARTITIONS | Displays the information about all index subpartitions in the database. |
| oceanbase.DBA_OB_TABLEGROUP_PARTITIONS | Displays the information about the partitions of partitioned table groups. |
| oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays the information about the subpartitions of partitioned table groups. |
| oceanbase.DBA_OB_TABLEGROUPS | Displays the metadata of table groups, mainly the partition information of the table groups. |
| oceanbase.DBA_OB_TABLET_REPLICAS | Displays the information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the joint key string of <TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| oceanbase.DBA_OB_TABLET_TO_LS | Displays the list of tablets in the current tenant and information about the log streams to which these tablets belong. |
| oceanbase.DBA_OB_LS_LOCATIONS | Displays the distribution of the log stream replicas in the current tenant. |
Views related to WR
| View | Description |
|---|---|
| oceanbase.DBA_WR_SNAPSHOT | Displays the snapshots of the current tenant. |
| oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY | Displays the persisted ASH data of the current tenant. |
| oceanbase.DBA_WR_STATNAME | Displays the names of system statistical items of the current tenant. |
| oceanbase.DBA_WR_SYSSTAT | Displays the details about system statistical items of the current tenant. |
| oceanbase.DBA_WR_CONTROL | Displays WR configurations. |
| oceanbase.DBA_WR_SYSTEM_EVENT | Displays the persisted tenant-level wait events of the current tenant. |
| oceanbase.DBA_WR_EVENT_NAME | Displays the persisted tenant-level wait events of the current tenant. |
| oceanbase.DBA_WR_SQLTEXT | Displays the SQL statements of the current tenant collected by WR. |
Views related to foreign keys
| View | Description |
|---|---|
| information_schema.INNODB_SYS_FOREIGN | Displays the metadata of InnoDB foreign keys. The information in this view is equivalent to that in the SYS_FOREIGN table in the InnoDB data dictionary.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
| information_schema.INNODB_SYS_FOREIGN_COLS | Displays the status of InnoDB foreign key columns. The information in this view is equivalent to that in the SYS_FOREIGN_COLS table in the InnoDB data dictionary.
NoteThis view is used only for compatibility with MySQL 5.7 and does not support related features. You can only query schemas from this view. |
Views related to SQL statistics
| View | Description |
|---|---|
| oceanbase.DBA_WR_SQLSTAT | Displays the basic performance statistics of SQL statements executed in the current tenant. Each row indicates one SQL statement. To be specific, each row is uniquely identified by SQL_ID and Plan_Hash. |
Views related to time models
| View | Description |
|---|---|
| oceanbase.DBA_WR_SYS_TIME_MODEL | Displays the WR data for the time model statistical items of the current tenant. |
Performance views
Views related to event statistics
| View | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | Displays the progress of OBServer node-level compactions in the current tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | Displays the suggestions on compactions. |
| GV$OB_PROCESSLIST | Displays the information about sessions on all OBServer nodes of the current tenant. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | Displays the compaction diagnostic information. |
| GV$OB_TABLET_COMPACTION_HISTORY | Displays the tablet-level compaction history. |
| GV$OB_TABLET_COMPACTION_PROGRESS | Displays the progress of tablet-level compactions. |
| GV$OB_TRANSACTION_PARTICIPANTS | Displays the information about the transaction participants on all OBServer nodes. |
| GV$SESSION_EVENT | Displays the session-level wait events of all OBServer nodes in the cluster. |
| GV$SESSION_WAIT | Displays the information about the current or previous wait events of all sessions on all OBServer nodes, including the event names and the amount of time spent on waiting. |
| GV$SESSION_WAIT_HISTORY | Displays the latest 10 wait events of all sessions on all OBServer nodes. |
| GV$SYSTEM_EVENT | Displays all tenant-level wait events in the cluster. |
| GV$SESSTAT | Displays the session-level statistical events on all OBServer nodes. |
| GV$SYSSTAT | Displays the information about tenant-level statistical events on all OBServer nodes. |
| GV$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$OB_COMPACTION_PROGRESS | Displays the progress of OBServer node-level compactions in the current tenant. |
| V$OB_COMPACTION_SUGGESTIONS | Displays the suggestions on compactions. |
| V$OB_PROCESSLIST | Displays the information about sessions on the current OBServer node. |
| V$OB_COMPACTION_DIAGNOSE_INFO | Displays the compaction diagnostic information. |
| V$OB_TABLET_COMPACTION_HISTORY | Displays the tablet-level compaction history. |
| V$OB_TABLET_COMPACTION_PROGRESS | Displays the progress of tablet-level compactions. |
| V$OB_TRANSACTION_PARTICIPANTS | Displays the information about the transaction participants on all OBServer nodes. |
| V$STATNAME | Displays the definitions of all statistical events. |
| V$EVENT_NAME | Displays the definitions of all statistical events on the current OBServer node. |
| V$SESSION_WAIT | Displays the details about the current wait events in each session. Each wait event has three parameters. |
| V$SESSION_WAIT_HISTORY | Displays the latest 10 wait events of each session. |
| V$SESSTAT | Displays an overview of session-level statistical events. |
| V$SYSSTAT | Displays the information about tenant-level statistical events on the current OBServer node. |
| V$SYSTEM_EVENT | Displays the tenant-level wait events. |
| GV$SESSION_LONGOPS | Displays the progress of index creation in the cluster. |
| V$SESSION_LONGOPS | Displays the progress of index creation on the current OBServer node. |
Views related to monitoring statistics
| View | Description |
|---|---|
| GV$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
Views related to I/O statistics
| View | Description |
|---|---|
| GV$OB_IO_CALIBRATION_STATUS | Displays the execution status of the I/O calibration task. |
| V$OB_IO_CALIBRATION_STATUS | Displays the execution status of the I/O calibration task. |
| GV$OB_IO_BENCHMARK | Displays the disk calibration data used by the I/O module. |
| V$OB_IO_BENCHMARK | Displays the disk calibration data used by the I/O module. |
Views related to cache statistics
| View | Description |
|---|---|
| GV$OB_MEMORY | Displays the tenant-level memory statistics. |
| V$OB_MEMORY | Displays the tenant-level memory statistics. |
| GV$OB_MEMSTORE | Displays the memory usage of all MemTables of all tenants on all OBServer nodes. |
| V$OB_MEMSTORE | Displays session-level MemStore statistics. |
| GV$OB_MEMSTORE_INFO | Displays the details about MemTables of all partitions of all tenants on all OBServer nodes. |
| V$OB_MEMSTORE_INFO | Displays the details about MemTables of all partitions of all tenants on all OBServer nodes. |
| GV$OB_SSTABLES | Displays the SSTables of the current tenant. |
| V$OB_SSTABLES | Displays the SSTables of the current tenant. |
| GV$OB_TENANT_MEMORY | Displays the memory usage of each tenant in the cluster. |
| V$OB_TENANT_MEMORY | Displays the memory usage of each tenant in the current observer process. |
Views related to SQL statistics
| View | Description |
|---|---|
| GV$OB_PLAN_CACHE_STAT | Displays the outlines of the current tenant. It is used for outline migration. |
| V$OB_PLAN_CACHE_STAT | Displays the overall status of each plan cache of the current tenant on all OBServer nodes. |
| GV$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan caches on all OBServer nodes. |
| V$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan cache on the current OBServer node. |
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan caches of all OBServer nodes. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans that are cached in the plan cache on the current OBServer node. |
| GV$OB_PS_STAT | Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items. |
| V$OB_PS_STAT | Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items. |
| GV$OB_PS_ITEM_INFO | Displays the monitoring information of prepared statements, including the basic information of all prepared statements in the PS cache. |
| V$OB_PS_ITEM_INFO | Displays the monitoring information of prepared statements, including the basic information of all prepared statements in the PS cache. |
| GV$OB_PX_TARGET_MONITOR | Displays the usage of PX worker threads on all OBServer nodes. |
| V$OB_PX_TARGET_MONITOR | Displays the usage of PX worker threads on the current OBServer node. |
| GV$OB_SQL_AUDIT | Displays the statistics of each SQL request on all OBServer nodes, such as the source and execution status. |
| V$OB_SQL_AUDIT | Displays the statistics of each SQL request on the current OBServer node, such as the source and execution status. |
| GV$SQL_PLAN_MONITOR | Displays plan-level statistics of slow queries on all OBServer nodes. Each slow query corresponds to one row in this view. It also records the trace information of the plan. |
| V$SQL_PLAN_MONITOR | Displays the operation-level statistics of slow queries. Each operation corresponds to one row in this view. |
| V$SQL_MONITOR_STATNAME | Displays the numbers in the OTHERSTAT_X_ID column of the GV$SQL_PLAN_MONITOR view. |
| GV$OB_FLT_TRACE_CONFIG | Displays the information about end-to-end diagnostics. |
Views related to log statistics
| View | Description |
|---|---|
| GV$OB_LOG_STAT | Displays the Palf status. |
| V$OB_LOG_STAT | Displays the Palf status. |
Views related to network statistics
| View | Description |
|---|---|
| GV$OB_RPC_OUTGOING | Displays the RPC sending statistics of all OBServer nodes. |
| GV$OB_RPC_INCOMING | Displays the RPC receiving statistics of all OBServer nodes. |
| V$OB_RPC_OUTGOING | Displays the data sending status of all RPC packet codes in the current tenant on the current OBServer node. |
| V$OB_RPC_INCOMING | Displays the data receiving status of all RPC packet codes in the current tenant on the current OBServer node. |
Views related to database statistics
| View | Description |
|---|---|
| GV$OB_KVCACHE | Displays the information about the KV cache on each OBServer node. |
| GV$OB_PARAMETERS | Displays the parameters on all OBServer nodes of the current tenant. |
| GV$OB_SERVER_SCHEMA_INFO | Displays the information about schemas on all OBServer nodes. |
| GV$OB_SERVERS | Displays the information about all OBServer nodes. |
| GV$OB_UNITS | Displays the information about the units on the OBServer nodes where the current tenant resides. You can view the units of all OBServer nodes in the current cluster from the sys tenant. |
| V$OB_KVCACHE | Displays the information about the KV cache on each OBServer node. |
| V$OB_PARAMETERS | Displays the parameters on the current OBServer node. |
| V$OB_SERVER_SCHEMA_INFO | Displays the information about schemas on all OBServer nodes. |
| V$OB_SERVERS | Displays the information about the current OBServer node. |
| V$OB_UNITS | Displays the information about the units on the current OBServer node. |
| GV$DML_STATS | Displays the information about the DML operations performed in the current user table. |
| V$DML_STATS | Displays the information about the DML operations performed in the current user table. |
| V$OB_COMPATIBILITY_CONTROL | Displays all features that support product behavior compatibility control based on the released OceanBase Database versions. |
Views related to SQL statistics
| View | Description |
|---|---|
| GV$OB_SQLSTAT | Displays the basic performance statistics of SQL statements in the cluster. Each row indicates one SQL statement. To be specific, each row is uniquely identified by SQL_ID and Plan_Hash. |
| V$OB_SQLSTAT | Displays the basic performance statistics of SQL statements on the current OBServer node. Each row indicates one SQL statement. To be specific, each row is uniquely identified by SQL_ID and Plan_Hash. |
Views related to time model statistics
| View | Description |
|---|---|
| GV$OB_SESS_TIME_MODEL | Displays the session-level time model statistical items of the cluster. |
| V$OB_SESS_TIME_MODEL | Displays the session-level time model statistical items of the current OBServer node. |
| GV$OB_SYS_TIME_MODEL | Displays the tenant-level time model statistical items of the cluster. |
| V$OB_SYS_TIME_MODEL | Displays the tenant-level time model statistical items of the current OBServer node. |
Views related to minor compactions
| View | Description |
|---|---|
| GV$OB_MERGE_INFO | Displays the statistics of compactions that are completed in the cluster. |
| V$OB_MERGE_INFO | Displays the statistics of compactions that are completed in the cluster. |
Views related to threads
| View | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | Displays the execution information of each PX worker thread in parallel execution. |
| V$OB_PX_WORKER_STAT | Displays the execution information of each PX worker thread in parallel execution. |
Views related to workareas
| View | Description |
|---|---|
| GV$SQL_WORKAREA | Displays the workarea statistics of all operators previously subject to automatic SQL memory management. |
| GV$SQL_WORKAREA_ACTIVE | Displays the workarea information of active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | Displays the cumulative execution statistics of all workareas, such as the total number of fully in-memory executions that consumed 1 MB to 2 MB of memory and the number of executions in one-pass mode. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | Displays the overall information about the SQL workarea, such as the maximum available memory, current memory usage, and currently held memory. |
| V$SQL_WORKAREA | Displays the workarea statistics of all operators previously subject to automatic SQL memory management. |
| V$SQL_WORKAREA_ACTIVE | Displays the workarea information of active operators. |
| V$SQL_WORKAREA_HISTOGRAM | Displays the cumulative execution statistics of all workareas, such as the total number of fully in-memory executions that consumed 1 MB to 2 MB of memory and the number of executions in one-pass mode. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | Displays the overall information about the SQL workarea, including the maximum available memory, current memory usage, and currently held memory. |
Views related to encrypted tables
| View | Description |
|---|---|
| V$OB_ENCRYPTED_TABLES | Displays the encryption status of tables with encryption enabled. |
| V$ENCRYPTED_TABLESPACES | Displays the encryption status of tablespaces with encryption enabled. |
Views related to transactions
| View | Description |
|---|---|
| GV$LATCH | Displays the information about the latches on all OBServer nodes in the cluster. |
| V$LATCH | Displays the information about the latches on all OBServer nodes in the cluster. |
Views in an Oracle tenant
Dictionary views
Applicability
This section applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Views related to tables and views
| View | Description |
|---|---|
| ALL_ALL_TABLES | Displays the object tables and relational tables accessible to the current user. |
| ALL_COL_COMMENTS | Displays the comments on all columns of the tables and views accessible to the current user. |
| ALL_TABLES | Displays all tables accessible to the current user. |
| ALL_TAB_COLS | Displays all columns of the tables, views, and clusters accessible to the current user. |
| ALL_TAB_COLUMNS | Displays all columns of the tables, views, and clusters accessible to the current user. |
| ALL_TAB_COMMENTS | Displays the comments on tables and views accessible to the current user. |
| DBA_COL_COMMENTS | Displays the comments on all columns of all tables and views in the database. |
| DBA_TAB_COMMENTS | Displays the comments on all tables and views in the database. |
| USER_COL_COMMENTS | Displays the comments on all columns of the tables and views owned by the current user. |
| USER_TAB_COMMENTS | Displays the comments on tables and views owned by the current user. |
| DBA_OB_TABLEGROUP_TABLES | Displays the associations between table groups and tables. Tables that do not belong to a table group are not displayed. |
| DBA_TABLES | Displays all tables in the database. |
| DBA_ALL_TABLES | Displays all object tables and relational tables in the database. Its columns are the same as those of the ALL_ALL_TABLES view. |
| DBA_TABLESPACES | Displays all tablespaces in the database. |
| DBA_TAB_COLS | Displays all columns of all tables, views, and clusters in the database. |
| DBA_TAB_COLUMNS | Displays all columns of all tables, views, and clusters in the database. |
| USER_ALL_TABLES | Displays object tables and relational tables accessible to the current user. Its columns are the same as those of the ALL_ALL_TABLES view except that it does not have the OWNER column. |
| USER_TABLES | Displays all tables owned by the current user. |
| USER_TABLESPACES | Displays the tablespaces accessible to the current user. Its columns are the same as those of the DBA_TABLESPACES view, except that it does not have the PLUGGED_IN column. |
| USER_TAB_COLS | Displays all columns of the tables, views, and clusters owned by the current user. |
| USER_TAB_COLUMNS | Displays all columns of the tables, views, and clusters owned by the current user. |
| ALL_VIEWS | Displays all views accessible to the current user. |
| DBA_VIEWS | Displays all views in the database. Its columns are the same as those of the ALL_VIEWS view. |
| USER_VIEWS | Displays the views owned by the current user. |
| DICTIONARY | Displays the data dictionary tables and views. |
| DICT | Displays the data dictionary tables and views. |
| DBA_OB_TABLE_LOCATIONS | Displays the locations of tables or partitions, including system tables, user tables, and index tables. |
| DBA_OB_SPATIAL_COLUMNS | Displays the database names, table names, data types, and spatial reference system (SRS) information corresponding to spatial index columns. |
Views related to outlines
| View | Description |
|---|---|
| DBA_OB_OUTLINES | Displays the information about the execution plan outlines in the current tenant. |
| DBA_OB_CONCURRENT_LIMIT_SQL | Displays the information about the throttling rule outlines in the current tenant. |
| DBA_OB_OUTLINE_CONCURRENT_HISTORY | Displays the history of execution plans and throttling rule outlines in the current tenant. |
Views related to SPM
| View | Description |
|---|---|
| DBA_SQL_PLAN_BASELINES | Displays the SQL plan baseline in SPM. |
| DBA_SQL_MANAGEMENT_CONFIG | Displays the configuration parameters in SPM. |
Views related to general database information
| View | Description |
|---|---|
| DBA_CONTEXT | Displays the information about all context namespaces in the database. |
| DBA_OB_DATABASES | Displays the database metadata of the current tenant. |
| DBA_OB_MAJOR_COMPACTION | Displays the global major compaction information of the current tenant. |
| DBA_OB_ZONE_MAJOR_COMPACTION | Displays the information about the major compactions of zones. |
| ALL_OBJECTS | Displays all database objects accessible to the current user. |
| DBA_OBJECTS | Displays all database objects in the database. |
| USER_OBJECTS | Displays all database objects owned by the current user. |
| ALL_DEPENDENCIES | Displays the dependencies among all the objects accessible to the current user. |
| DBA_DEPENDENCIES | Displays the dependencies among all objects in the database. |
| USER_DEPENDENCIES | Displays the dependencies among objects in the schema of the current user. |
| DBA_OB_FREEZE_INFO | Displays the version information generated by major compactions. |
Views related to functions and procedures
| View | Description |
|---|---|
| ALL_ARGUMENTS | Displays the arguments of the functions and procedures accessible to the current user. |
| ALL_PROCEDURES | Displays all functions and procedures accessible to the current user as well as their properties. |
| ALL_SOURCE | Displays the text sources of the stored objects accessible to the current user. |
| DBA_ARGUMENTS | Displays the arguments of the available functions and procedures in the database. Its columns are the same as those of the ALL_ARGUMENTS view. |
| DBA_PROCEDURES | Displays all available functions and procedures in the database as well as their properties. Its columns are the same as those of the ALL_PROCEDURES view. |
| DBA_SOURCE | Displays the text sources of all stored objects in the database. Its columns are the same as those of the ALL_SOURCE view. |
| USER_ARGUMENTS | Displays the arguments of the functions and procedures owned by the current user. Its columns are the same as those of the ALL_ARGUMENTS view, except that it does not have the OWNER column. |
| USER_PROCEDURES | Displays all functions and procedures owned by the current user, as well as their associated properties. Its columns are the same as those of the ALL_PROCEDURES view, except that it does not have the OWNER column. |
| USER_SOURCE | Displays the text sources of the stored objects owned by the current user. Its columns are the same as those of the ALL_SOURCE view, except that it does not have the OWNER column. |
| DBA_JOBS | Displays an overview of committed jobs. |
| USER_JOBS | Displays an overview of committed jobs. |
| DBA_JOBS_RUNNING | Displays ongoing jobs. |
Views related to backup and restore
| View | Description |
|---|---|
| DBA_OB_BACKUP_JOBS | Displays the backup jobs in the current tenant. |
| DBA_OB_BACKUP_JOB_HISTORY | Displays the history of backup jobs in the current tenant. |
| DBA_OB_BACKUP_TASKS | Displays the backup tasks in the current tenant. |
| DBA_OB_BACKUP_TASK_HISTORY | Displays the history of backup tasks in the current tenant. |
| DBA_OB_BACKUP_SET_FILES | Displays the file status of backup sets. |
| DBA_OB_RESTORE_PROGRESS | Displays ongoing restore jobs. |
| DBA_OB_RESTORE_HISTORY | Displays the restore jobs that have been completed. |
| DBA_OB_ARCHIVE_DEST | Displays the configuration of archive paths. |
| DBA_OB_BACKUP_STORAGE_INFO | Displays the information about backup destinations of backup and restore in the current tenant. |
| DBA_OB_BACKUP_STORAGE_INFO_HISTORY | Displays the history of backup destinations of backup and restore in the current tenant. |
| DBA_OB_BACKUP_DELETE_POLICY | Displays the cleanup strategies for retention period-based cleanup and automatic cleanup jobs in the current tenant. |
| DBA_OB_BACKUP_DELETE_JOBS | Displays the execution progress of backup cleanup jobs in the current tenant. |
| DBA_OB_BACKUP_DELETE_JOB_HISTORY | Displays the history of backup cleanup jobs that have been executed in the current tenant. |
| DBA_OB_BACKUP_DELETE_TASKS | Displays the information about the backup set/piece cleanup tasks that are being executed in the current tenant. |
| DBA_OB_BACKUP_DELETE_TASK_HISTORY | Displays the history of the backup set/piece cleanup tasks that have been completed in the current tenant. |
| DBA_OB_ARCHIVELOG | Displays the log backup status for each path. |
| DBA_OB_ARCHIVELOG_SUMMARY | Displays the status of all historical and current log backups. |
| DBA_OB_ARCHIVELOG_PIECE_FILES | Displays the status of backup pieces in each backup set. |
| DBA_OB_BACKUP_PARAMETER | Displays the backup parameters. |
| DBA_OB_RECOVER_TABLE_JOBS | Displays the information about table-level restore jobs. |
| DBA_OB_IMPORT_TABLE_JOBS | Displays the information about import jobs. |
| DBA_OB_IMPORT_TABLE_TASKS | Displays the records of table-level import tasks. |
| DBA_OB_RECOVER_TABLE_JOB_HISTORY | Displays the results of table-level restore jobs. |
| DBA_OB_IMPORT_TABLE_JOB_HISTORY | Displays the results of import jobs. |
| DBA_OB_IMPORT_TABLE_TASK_HISTORY | Displays the history of table-level cross-tenant import tasks. |
Views related to statistics and histograms
| View | Description |
|---|---|
| ALL_PART_COL_STATISTICS | Displays the column statistics and histograms on partitions in the partitioned tables accessible to the current user. |
| ALL_PART_HISTOGRAMS | Displays the histograms on all partitions. |
| ALL_SUBPART_COL_STATISTICS | Displays the column statistics and histograms on subpartitions in the partitioned tables accessible to the current user. |
| ALL_SUBPART_HISTOGRAMS | Displays the histograms on all subpartitions. |
| ALL_TAB_COL_STATISTICS | Displays the column statistics and histograms on tables accessible to the current user. |
| ALL_TAB_HISTOGRAMS | Displays all table-level histograms. |
| ALL_TAB_STATISTICS | Displays the optimizer statistics of tables accessible to the current user. |
| DBA_PART_COL_STATISTICS | Displays the column statistics and histograms on partitions in the partitioned tables of the database. |
| DBA_PART_HISTOGRAMS | Displays the histograms on partitions of the current database. |
| DBA_SUBPART_COL_STATISTICS | Displays the column statistics and histograms on subpartitions in the partitioned tables of the database. |
| DBA_SUBPART_HISTOGRAMS | Displays the histograms on subpartitions of the current database. |
| DBA_TAB_COL_STATISTICS | Displays the column statistics and histograms on all tables in the database. |
| DBA_TAB_HISTOGRAMS | Displays the table-level histograms on the current database. |
| DBA_TAB_STATISTICS | Displays the optimizer statistics of all tables in the database. |
| USER_PART_COL_STATISTICS | Displays the column statistics and histograms on partitions in the partitioned tables of the current user. |
| USER_PART_HISTOGRAMS | Displays the histograms on partitions of the current user. |
| USER_SUBPART_COL_STATISTICS | Displays the column statistics and histograms on subpartitions in the partitioned tables of the current user. |
| USER_SUBPART_HISTOGRAMS | Displays the histograms on subpartitions of the current user. |
| USER_TAB_COL_STATISTICS | Displays the column statistics and histograms on tables of the current user. |
| USER_TAB_HISTOGRAMS | Displays the table-level histograms on the current user. |
| USER_TAB_STATISTICS | Displays the optimizer statistics of all tables of the current user. |
| ALL_TAB_STATS_HISTORY | Displays the change history of the table statistics of all tables accessible to the current user. |
| DBA_TAB_STATS_HISTORY | Displays the change history of the table statistics of all tables in the database. |
| USER_TAB_STATS_HISTORY | Displays the change history of the table statistics of all tables owned by the current user. |
| ALL_IND_STATISTICS | Displays the optimizer statistics on the indexes of tables accessible to the current user. |
| DBA_IND_STATISTICS | Displays the optimizer statistics of all indexes in the database. |
| USER_IND_STATISTICS | Displays the optimizer statistics on the indexes of tables owned by the current user. |
| ALL_TAB_MODIFICATIONS | Displays the modification history of tables accessible to the current user since the table statistics were collected the last time. |
| DBA_TAB_MODIFICATIONS | Displays the modification history of all tables in the database since the table statistics were collected the last time. |
| USER_TAB_MODIFICATIONS | Displays the modification history of tables owned by the current user since the table statistics were collected the last time. |
Views related to users and privileges
| View | Description |
|---|---|
| ALL_USERS | Displays all database users visible to the current user. |
| DBA_USERS | Displays all users in the database. |
| USER_USERS | Displays the information about the current user. |
| ALL_COL_PRIVS | Displays the column object grants for which the current user is the object owner, grantor, or grantee, and the column object grants for which an enabled role or PUBLIC is the grantee. |
| ALL_TAB_PRIVS | Displays the object grants for which the current user is the object owner, grantor, or grantee, and the object grants for which an enabled role or PUBLIC is the grantee. |
| DBA_COL_PRIVS | Displays all column object grants in the database. |
| DBA_SYS_PRIVS | Displays the system privileges granted to users and roles. |
| DBA_TAB_PRIVS | Displays all object grants in the database. |
| USER_TAB_PRIVS | Displays the object grants for which the current user is the object owner, grantor, or grantee. |
| USER_COL_PRIVS | Displays the column object grants for which the current user is the object owner, grantor, or grantee. |
| USER_ROLE_PRIVS | Displays the roles granted to the current user. |
| USER_SYS_PRIVS | Displays the system privileges granted to the current user. |
| ROLE_TAB_PRIVS | Displays the table privileges granted to roles. Information is provided only about roles to which the user has access. |
| ROLE_SYS_PRIVS | Displays the system privileges granted to roles. |
| ROLE_ROLE_PRIVS | Displays the roles granted to other roles. Information is provided only about roles to which the user has access. |
| DBA_ROLE_PRIVS | Displays the roles granted to all users and roles in the database. |
| DBA_ROLES | Displays all roles that exist in the database. |
| ALL_DIRECTORIES | Displays all directories accessible to the current user. |
| DBA_DIRECTORIES | Displays all directories accessible to the current user. |
Views related to constraints
| View | Description |
|---|---|
| ALL_CONSTRAINTS | Displays the constraints on all tables accessible to the current user. |
| ALL_CONS_COLUMNS | Displays the columns that are specified in the constraints on all tables accessible to the current user. |
| DBA_CONSTRAINTS | Displays the constraints on all tables in the database. |
| DBA_CONS_COLUMNS | Displays the columns that are specified in the constraints on all tables in the database. |
| USER_CONSTRAINTS | Displays the constraints on all tables owned by the current user. |
| USER_CONS_COLUMNS | Displays the columns that are specified in the constraints on all tables owned by the current user. |
Views related to audit
| View | Description |
|---|---|
| ALL_DEF_AUDIT_OPTS | Displays the default object-auditing options for any object. |
| AUDIT_ACTIONS | Displays the action IDs and names in audit records. |
| DBA_AUDIT_EXISTS | Displays audit trail entries produced by AUDIT EXISTS and AUDIT NOT EXISTS. |
| DBA_AUDIT_OBJECT | Displays the audit trail records for all objects in the database. |
| DBA_AUDIT_SESSION | Displays all audit trail records concerning CONNECT and DISCONNECT. |
| DBA_AUDIT_STATEMENT | Displays audit trail records for the GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements in the database. |
| DBA_AUDIT_TRAIL | Displays all audit trail entries. |
| DBA_OBJ_AUDIT_OPTS | Displays detailed auditing configurations at the object level. |
| DBA_STMT_AUDIT_OPTS | Displays detailed auditing configuration at the statement level. |
| STMT_AUDIT_OPTION_MAP | Displays statement-level auditing types and their corresponding names and priorities. |
| USER_AUDIT_OBJECT | Displays audit trail records for objects accessible to the current user. |
| USER_AUDIT_SESSION | Displays audit trail records for connections and disconnections of the current user. |
| USER_AUDIT_STATEMENT | Displays audit trail entries for the GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements issued by the current user. |
| USER_AUDIT_TRAIL | Displays standard audit trail entries concerning the current user. |
Views related to indexes
| View | Description |
|---|---|
| ALL_INDEXES | Displays the columns of indexes on all tables accessible to the current user. |
| ALL_IND_COLUMNS | Displays the columns of indexes on all tables accessible to the current user. |
| ALL_IND_EXPRESSIONS | Displays the information about function-based indexes accessible to the current user in the database. |
| ALL_IND_PARTITIONS | Displays the information about index partitions accessible to the current user in the database. |
| ALL_IND_SUBPARTITIONS | Displays the information about all index subpartitions accessible to the current user in the database. |
| ALL_PART_INDEXES | Displays the partitioning information of all partitioned indexes accessible to the current user. |
| DBA_INDEXES | Displays the indexes on all tables in the database. |
| DBA_IND_COLUMNS | Displays the columns of indexes on all tables in the database. |
| DBA_IND_EXPRESSIONS | Displays the information about all function-based indexes in the database. |
| DBA_IND_PARTITIONS | Displays the information about all index partitions in the database. |
| DBA_IND_SUBPARTITIONS | Displays the information about all index subpartitions in the database. |
| USER_INDEXES | Displays the indexes on all tables owned by the current user. |
| USER_IND_COLUMNS | Displays the columns of indexes on all tables owned by the current user. |
| USER_IND_EXPRESSIONS | Displays the information about function-based indexes owned by the current user in the database. |
| USER_IND_PARTITIONS | Displays the information about the index partitions owned by the current user in the database. This view does not have the INDEX_OWNER column compared with the ALL_IND_PARTITIONS and DBA_IND_PARTITIONS views. |
| USER_IND_SUBPARTITIONS | Displays the information about all index subpartitions owned by the current user in the database. This view does not have the INDEX_OWNER column compared with the DBA_IND_SUBPARTITIONS and ALL_IND_SUBPARTITIONS views. |
| USER_PART_INDEXES | Displays the partitioning information of partitioned indexes owned by the current user. |
Views related to partitions
| View | Description |
|---|---|
| ALL_PART_KEY_COLUMNS | Displays the partitioning key columns of all partitioned objects accessible to the current user. |
| ALL_PART_TABLES | Displays the partitioning information of all partitioned tables accessible to the current user. |
| ALL_SUBPARTITION_TEMPLATES | Displays the information about all subpartition templates. |
| ALL_SUBPART_KEY_COLUMNS | Displays the subpartitioning key columns of all partitioned objects accessible to the current user. |
| ALL_TAB_PARTITIONS | Displays the multi-level partitioning information, partition storage parameters, and partition statistics of all partitioned tables. |
| ALL_TAB_SUBPARTITIONS | Displays the partition-level partitioning information, partition storage parameters, and partition statistics generated by the DBMS_STATS package for the partitions accessible to the current user. |
| DBA_PART_INDEXES | Displays the information about partitions of all partitioned indexes. |
| DBA_PART_KEY_COLUMNS | Displays the partitioning key columns of all partitioned objects in the database. |
| DBA_PART_TABLES | Displays the partitioning information of all partitioned tables accessible to the current user. |
| DBA_SUBPARTITION_TEMPLATES | Displays the information about all subpartition templates. |
| DBA_SUBPART_KEY_COLUMNS | Displays the subpartitioning key columns of all partitioned objects in the database. |
| DBA_TAB_PARTITIONS | Displays the multi-level partitioning information, partition storage parameters, and partition statistics accessible to the current user. |
| DBA_TAB_SUBPARTITIONS | Displays, for each subpartition, the subpartition name, the names of the table and partition to which it belongs, its storage attributes, and statistics generated by the DBMS_STATS package. |
| USER_PART_KEY_COLUMNS | Displays the partitioning key columns of all partitioned objects owned by the current user. |
| USER_PART_TABLES | Displays the partitioning information of all partitioned tables owned by the current user. |
| USER_SUBPARTITION_TEMPLATES | Displays the information about all subpartition templates. |
| USER_SUBPART_KEY_COLUMNS | Displays the subpartitioning key columns of all partitioned objects owned by the current user. |
| USER_TAB_SUBPARTITIONS | Displays, for each table subpartition owned by the current user, the subpartition name, the names of the table and partition to which it belongs, and its storage attributes. |
| USER_TAB_PARTITIONS | Displays the multi-level partitioning information, partition storage parameters, and partition statistics of the current user. |
Views related to sessions
| View | Description |
|---|---|
| DBA_OB_DEADLOCK_EVENT_HISTORY | Displays the history of deadlock events. You can query this view from a user tenant for the history of deadlock events of the current tenant. |
Views related to sequences
| View | Description |
|---|---|
| ALL_SEQUENCES | Displays all sequences accessible to the current user. |
| DBA_SEQUENCES | Displays all sequences in the database. |
| USER_SEQUENCES | Displays all sequences owned by the current user. |
| TENANT_VIRTUAL_GLOBAL_VARIABLE | Displays the information about global variables. |
| TENANT_VIRTUAL_SESSION_VARIABLE | Displays the information about session variables. |
Views related to synonyms
| View | Description |
|---|---|
| ALL_SYNONYMS | Displays all synonyms accessible to the current user. |
| DBA_SYNONYMS | Displays all synonyms in the database. |
| USER_SYNONYMS | Displays all synonyms owned by the current user. |
Views related to triggers
| View | Description |
|---|---|
| ALL_TRIGGERS | Displays the triggers 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 | Displays all triggers in the database. |
| USER_TRIGGERS | Displays the triggers owned by the current user. |
Views related to recycle bins
| View | Description |
|---|---|
| DBA_RECYCLEBIN | Displays the information about all recycle bins in the database. |
| USER_RECYCLEBIN | Displays the information about recycle bins owned by the current user. Its columns are the same as those of the DBA_RECYCLEBIN view, except that it does not have the OWNER column. |
Views related to resource groups
| View | Description |
|---|---|
| DBA_RSRC_GROUP_MAPPINGS | Displays the binding relationships between the user and resource groups. |
| DBA_RSRC_CONSUMER_GROUPS | Displays the information about all resource groups in the database. |
| DBA_RSRC_PLANS | Displays all resource management plans defined in the system. |
| DBA_RSRC_PLAN_DIRECTIVES | Displays the details about each group of resource plan directives in the database. |
Views related to NLS parameters
| View | Description |
|---|---|
| NLS_DATABASE_PARAMETERS | Displays the National Language Support (NLS) parameters at the OceanBase Database tenant level. |
| NLS_INSTANCE_PARAMETERS | Displays the NLS parameters at the instance level. |
| NLS_SESSION_PARAMETERS | Displays the NLS parameters at the session level. |
Views related to user-defined types
| View | Description |
|---|---|
| ALL_COLL_TYPES | Displays the user-defined collection types available in the database. Its columns are the same as those of the DBA_COLL_TYPES view. |
| ALL_TYPES | Displays the user-defined types available in the database. |
| ALL_TYPE_ATTRS | Displays the attributes of user-defined types available in the database. |
| DBA_COLL_TYPES | Displays the user-defined collection types available in the database. Its columns are the same as those of the ALL_COLL_TYPES view. |
| DBA_TYPES | Displays the user-defined types available in the database. |
| DBA_TYPE_ATTRS | Displays the attributes of user-defined types available in the database. |
| USER_COLL_TYPES | Displays the user-defined collection types accessible to the current user. |
| USER_TYPES | Displays the user-defined types accessible to the current user. |
| USER_TYPE_ATTRS | Displays the attributes of user-defined types accessible to the current user. |
Views related to stored objects
| View | Description |
|---|---|
| ALL_ERRORS | Displays the current errors of all stored objects accessible to the current user. |
| DBA_ERRORS | Displays the current errors of all stored objects in the database. |
| USER_ERRORS | Displays the current errors of all stored objects accessible to the current user. |
| DBA_SEGMENTS | Displays the storage allocated for all segments in the database. |
| USER_SEGMENTS | Displays the storage allocated for the segments of the objects that are owned by the current user. |
Views related to profiles
| View | Description |
|---|---|
| ALL_PROFILES | Displays all profiles accessible to the current user and their limitations. |
| DBA_PROFILES | Displays all profiles accessible to the current user and their limitations. |
| USER_PROFILES | Displays all profiles accessible to the current user and their limitations. |
Views related to replicas and logs
| View | Description |
|---|---|
| DBA_OB_LS_LOCATIONS | Displays the distribution of the log stream replicas in the current tenant. |
| DBA_OB_TABLEGROUPS | Displays the metadata of table groups, mainly the partition information of the table groups. |
| DBA_OB_TABLEGROUP_PARTITIONS | Displays the information about the partitions of partitioned table groups. |
| DBA_OB_TABLEGROUP_SUBPARTITIONS | Displays the information about the subpartitions of partitioned table groups. |
| DBA_OB_TABLET_REPLICAS | Displays the information about all tablet replicas in the current tenant. Each tablet replica is uniquely identified by the joint key string of <TENANT_ID, TABLET_ID, SVR_IP, SVR_PORT, LS_ID>. |
| DBA_OB_TABLET_TO_LS | Displays the list of tablets in the current tenant and information about the log streams to which these tablets belong. |
| DBA_OB_LS | Displays the status and restore progress of log streams. |
Views related to WR
| View | Description |
|---|---|
| DBA_WR_SNAPSHOT | Displays the snapshots of the current tenant. |
| DBA_WR_ACTIVE_SESSION_HISTORY | Displays the persisted ASH data of the current tenant. |
| DBA_WR_STATNAME | Displays the names of system statistical items of the current tenant. |
| DBA_WR_SYSSTAT | Displays the details about system statistical items of the current tenant. |
| DBA_WR_CONTROL | Displays WR configurations. |
| DBA_WR_SYSTEM_EVENT | Displays the persisted tenant-level wait events of the current tenant. |
| DBA_WR_EVENT_NAME | Displays the persisted tenant-level wait events of the current tenant. |
| DBA_WR_SQLTEXT | Displays the SQL statements of the current tenant collected by WR. |
Views related to SQL statistics
| View | Description |
|---|---|
| DBA_WR_SQLSTAT | Displays the basic performance statistics of SQL statements executed in the current tenant. |
Views related to SQL statistics
| View | Description |
|---|---|
| DBA_WR_SYS_TIME_MODEL | Displays the WR data for the time model statistical items of the current tenant. |
Views related to load balancing
| View | Description |
|---|---|
| DBA_OB_TRANSFER_PARTITION_TASKS | Displays the ongoing partition transfer tasks in the current tenant. |
| DBA_OB_TRANSFER_PARTITION_TASK_HISTORY | Displays the historical partition transfer tasks executed in the current tenant. |
Views related to schedulers
| View | Description |
|---|---|
| DBA_SCHEDULER_JOBS | Displays the scheduler jobs accessible to the current user. |
| DBA_SCHEDULER_PROGRAM | Displays all scheduler programs in the database. |
| DBA_SCHEDULER_JOB_RUN_DETAILS | Displays all scheduler jobs in the current tenant. |
Views related to DBLinks
| View | Description |
|---|---|
| ALL_DB_LINKS | Displays all DBLinks accessible to the current user. |
| DBA_DB_LINKS | Displays all DBLinks created in the current tenant. |
| USER_DB_LINKS | Displays the DBLinks created by the current user. |
Unsupported views
| View | Description |
|---|---|
| ALL_METHOD_PARAMS | Displays the method parameters of the object types accessible to the current user. |
| ALL_SCHEDULER_JOB_ARGS | Displays the arguments of all scheduler jobs accessible to the current user. |
| ALL_SCHEDULER_PROGRAM_ARGS | Displays the arguments of all scheduler programs accessible to the current user. |
| ALL_TYPE_METHODS | Displays the methods of the object types accessible to the current user. |
| DBA_METHOD_PARAMS | Displays the method parameters of the object types in the database. |
| DBA_SCHEDULER_JOB_ARGS | Displays the arguments of all scheduler jobs in the database. |
| USER_SCHEDULER_JOB_ARGS | Displays the arguments of scheduler jobs owned by the current user. |
| DBA_SCHEDULER_PROGRAM_ARGS | Displays the arguments of all scheduler programs in the database. |
| USER_SCHEDULER_PROGRAM_ARGS | Displays the arguments of scheduler programs owned by the current user. |
| DBA_TYPE_METHODS | Displays the methods of all object types in the database. |
| USER_TYPE_METHODS | Displays the methods of the object types accessible to the current user. Its columns are the same as those of the ALL_TYPE_METHODS view, except that it does not have the OWNER column. |
Performance views
Views related to statistics
| View | Description |
|---|---|
| GV$OB_KVCACHE | Displays the information about the KV cache on each OBServer node. |
| GV$OB_PARAMETERS | Displays the parameters on all OBServer nodes of the current tenant. |
| GV$OB_SERVER_SCHEMA_INFO | Displays the information about schemas on all OBServer nodes. |
| V$OB_SERVER_SCHEMA_INFO | Displays the information about schemas on all OBServer nodes. |
| GV$OB_UNITS | Displays the information about the units on the OBServer nodes where the current tenant resid. You can view the units of all OBServer nodes in the current cluster from the sys tenant. |
| GV$SYSSTAT | Displays the system-level statistical events on all OBServer nodes. |
| GV$DML_STATS | Displays the information about the DML operations performed in the current user table. |
| V$DML_STATS | Displays the information about the DML operations performed in the current user table. |
| V$GLOBALCONTEXT | Displays the CLIENT_IDENTIFIER values of the global context attributes accessible to the current session. |
| V$OB_KVCACHE | Displays the information about the KV cache on each OBServer node. |
| V$OB_PARAMETERS | Displays the parameters on the current OBServer node. |
| V$SYSSTAT | Displays the system-level statistical events on the current OBServer node. |
| V$OB_UNITS | Displays the information about the units on the current OBServer node. |
| V$VERSION | Displays the names and versions of all components of the database. |
| V$STATNAME | Displays the statistical items. |
Views related to instances
| View | Description |
|---|---|
| GV$INSTANCE | Displays the status of the current database instance. |
| V$INSTANCE | Displays the status of the current database instance. |
Views related to memory
| View | Description |
|---|---|
| GV$OB_MEMORY | Displays the memory usage of each tenant on all OBServer nodes. |
| GV$OB_MEMSTORE | Displays the memory usage of all MemTables of all tenants on all OBServer nodes. |
| GV$OB_SQL_WORKAREA_MEMORY_INFO | Displays the overall information about the SQL workarea, such as the maximum available memory, current memory usage, and currently held memory. |
| GV$OB_SSTABLES | Displays the SSTables of the current tenant. |
| GV$OB_MEMSTORE_INFO | Displays the details about MemTables of all partitions of all tenants on all OBServer nodes. |
| V$OB_MEMSTORE_INFO | Displays the details about MemTables of all partitions of all tenants on all OBServer nodes. |
| V$OB_MEMORY | Displays the tenant-level memory statistics. |
| V$OB_MEMSTORE | Displays the memory usage of all MemTables of all tenants on the current OBServer node. |
| V$OB_SSTABLES | Displays the SSTables of the current tenant. |
| GV$OB_TENANT_MEMORY | Displays the memory usage of each tenant in the cluster. |
| V$OB_TENANT_MEMORY | Displays the memory usage of each tenant in the current observer process. |
Views related to cache
| View | Description |
|---|---|
| GV$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans cached in the plan caches of all OBServer nodes. |
| GV$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan caches on all OBServer nodes. |
| GV$OB_PLAN_CACHE_STAT | Displays the overall status of each plan cache of the current tenant on all OBServer nodes. |
| V$OB_PLAN_CACHE_PLAN_EXPLAIN | Displays the physical execution plans that are cached in the plan cache on the current OBServer node. |
| V$OB_PLAN_CACHE_PLAN_STAT | Displays the status of each object cached by the current tenant in the plan cache on the current OBServer node. |
| V$OB_PLAN_CACHE_STAT | Displays the overall status of each plan cache of the current tenant on all OBServer nodes. |
| V$RSRC_PLAN | Displays the active resource plans on the current OBServer node. |
Views related to logs
| View | Description |
|---|---|
| GV$OB_LOG_STAT | Displays the Palf status. |
| V$OB_LOG_STAT | Displays the Palf status. |
Views related to monitoring information
| View | Description |
|---|---|
| GV$OB_PX_TARGET_MONITOR | Displays the usage of PX worker threads on all OBServer nodes. |
| GV$OB_PS_ITEM_INFO | Displays the monitoring information of prepared statements, including the basic information of all prepared statements in the PS cache. |
| GV$OB_PS_STAT | Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items. |
| GV$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
| V$OB_DTL_INTERM_RESULT_MONITOR | Displays the monitoring information of the DTL intermediate result manager. |
| V$OB_PX_TARGET_MONITOR | Displays the usage of PX worker threads on the current OBServer node. |
| V$OB_PS_ITEM_INFO | Displays the monitoring information of prepared statements, including the basic information of all prepared statements in the PS cache. |
| V$OB_PS_STAT | Displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items. |
| V$SQL_MONITOR_STATNAME | Displays the numbers in the OTHERSTAT_X_ID column of the GV$SQL_PLAN_MONITOR view. |
Views related to sessions
| View | Description |
|---|---|
| GV$OB_PROCESSLIST | Displays the information about sessions on all OBServer nodes of the current tenant. |
| GV$SESSION_WAIT | Displays the information about the current or previous wait events of all sessions on all OBServer nodes, including the event names and the amount of time spent on waiting. |
| GV$SESSION_WAIT_HISTORY | Displays the latest 10 wait events of all sessions on all OBServer nodes. |
| GV$SESSTAT | Displays the session-level statistics on all OBServer nodes. |
| GV$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$ACTIVE_SESSION_HISTORY | Displays the active session history. |
| V$NLS_PARAMETERS | Displays the NLS parameters at the session level. |
| V$OB_PROCESSLIST | Displays the information about sessions on the current OBServer node. |
| V$SESSION_WAIT | Displays the information about the current or last wait events of all sessions on the current OBServer node, such as the event name and the amount of time spent on waiting. |
| V$SESSION_WAIT_HISTORY | Displays the latest 10 wait events of all sessions on the current OBServer node. |
| V$SESSTAT | Displays the session-level statistics on the current OBServer node. |
| V$EVENT_NAME | Displays the definitions of all wait events on the current OBServer node. |
Views related to SQL statistics
| View | Description |
|---|---|
| GV$OB_SQL_AUDIT | Displays the statistics of each SQL request on all OBServer nodes, such as the source and execution status. |
| V$OB_SQL_AUDIT | Displays the statistics of each SQL request on the current OBServer node, such as the source and execution status. |
| GV$SQL_PLAN_MONITOR | Displays plan-level statistics of slow queries on all OBServer nodes. Each slow query corresponds to one row in this view. It also records the trace information of the plan. |
| V$SQL_PLAN_MONITOR | Displays plan-level statistics of slow queries on all OBServer nodes. Each slow query corresponds to one row in this view. It also records the trace information of the plan. |
| GV$OB_FLT_TRACE_CONFIG | Displays the information about end-to-end diagnostics. |
Views related to threads
| View | Description |
|---|---|
| GV$OB_PX_WORKER_STAT | Displays the execution information of each PX worker thread in parallel execution. |
| V$OB_PX_WORKER_STAT | Displays the execution information of each PX worker thread in parallel execution. |
Views related to workareas
| View | Description |
|---|---|
| GV$SQL_WORKAREA | Displays the workarea statistics of all operators previously subject to automatic SQL memory management. |
| GV$SQL_WORKAREA_ACTIVE | Displays the workarea information of active operators. |
| GV$SQL_WORKAREA_HISTOGRAM | Displays the cumulative execution statistics of all workareas. |
| V$OB_SQL_WORKAREA_MEMORY_INFO | Displays the overall information about the SQL workarea, such as the maximum available memory, current memory usage, and currently held memory. |
| V$SQL_WORKAREA | Displays the workarea statistics of all operators previously subject to automatic SQL memory management. |
| V$SQL_WORKAREA_ACTIVE | Displays the workarea information of active operators. |
| V$SQL_WORKAREA_HISTOGRAM | Displays the cumulative execution statistics of all workareas. |
Views related to transactions
| View | Description |
|---|---|
| GV$OB_COMPACTION_PROGRESS | Displays the progress of OBServer node-level compactions in the current tenant. |
| GV$OB_COMPACTION_SUGGESTIONS | Displays the suggestions on compactions. |
| GV$OB_COMPACTION_DIAGNOSE_INFO | Displays the compaction diagnostic information. |
| GV$OB_TABLET_COMPACTION_HISTORY | Displays the tablet-level compaction history. |
| GV$OB_TABLET_COMPACTION_PROGRESS | Displays the progress of tablet-level compactions. |
| GV$OB_TRANSACTION_PARTICIPANTS | Displays the information about the transaction participants on all OBServer nodes. |
| GV$SYSTEM_EVENT | Displays the system wait events of the current tenant on all OBServer nodes, including the number of occurrences, wait time, and number of timeouts of each type of wait event. |
| GV$GLOBAL_TRANSACTION | Displays the information about currently active global transactions. |
| V$OB_COMPACTION_PROGRESS | Displays the progress of OBServer node-level compactions in the current tenant. |
| V$OB_COMPACTION_SUGGESTIONS | Displays the suggestions on compactions. |
| V$OB_COMPACTION_DIAGNOSE_INFO | Displays the compaction diagnostic information. |
| V$OB_TABLET_COMPACTION_HISTORY | Displays the tablet-level compaction history. |
| V$OB_TABLET_COMPACTION_PROGRESS | Displays the progress of tablet-level compactions. |
| V$OB_TRANSACTION_PARTICIPANTS | Displays the information about the transaction participants on all OBServer nodes. |
| V$SYSTEM_EVENT | Displays the system wait events of the current tenant on the current OBServer node, including the number of occurrences, wait time, and number of timeouts of each type of wait event. |
| V$GLOBAL_TRANSACTION | Displays the information about currently active global transactions. |
| GV$OB_GLOBAL_TRANSACTION | Displays the information about all eXtended Architecture (XA) transactions in the cluster. |
| V$OB_GLOBAL_TRANSACTION | Displays the information about all XA transactions whose original scheduler is the current OBServer node. |
Views related to time zones
| View | Description |
|---|---|
| V$TIMEZONE_NAMES | Displays the valid time zone names. |
Views related to encrypted tables
| View | Description |
|---|---|
| V$OB_ENCRYPTED_TABLES | Displays the encryption status of tables with encryption enabled. |
| V$ENCRYPTED_TABLESPACES | Displays the encryption status of tablespaces with encryption enabled. |
Views related to DBLinks
| View | Description |
|---|---|
| GV$DBLINK | Displays all DBLinks (the links with IN_TRANSACTION set to YES) opened by the session that issues the query on this view. These DBLinks must be committed or rolled back before they are closed. |
| V$DBLINK | Displays all DBLinks (the links with IN_TRANSACTION set to YES) opened by the session that issues the query on this view. These DBLinks must be committed or rolled back before they are closed. |
Views related to SQL statistics
| View | Description |
|---|---|
| GV$OB_SQLSTAT | Displays the basic performance statistics of SQL statements in the cluster. Each row indicates one SQL statement. To be specific, each row is uniquely identified by SQL_ID and Plan_Hash. |
| V$OB_SQLSTAT | Displays the basic performance statistics of SQL statements on the current OBServer node. Each row indicates one SQL statement. To be specific, each row is uniquely identified by SQL_ID and Plan_Hash. |
Views related to time models
| View | Description |
|---|---|
| GV$OB_SESS_TIME_MODEL | Displays the session-level time model statistical items of the cluster. |
| V$OB_SESS_TIME_MODEL | Displays the session-level time model statistical items of the current OBServer node. |
| GV$OB_SYS_TIME_MODEL | Displays the tenant-level time model statistical items of the cluster. |
| V$OB_SYS_TIME_MODEL | Displays the tenant-level time model statistical items of the current OBServer node. |