A MySQL tenant supports some CDB_* views that are compatible with Oracle databases.
Storage location
Oracle-compatible views in the sys tenant are stored in the OceanBase database and can be accessed only from the sys tenant.
Characteristics
- In Oracle-compatible views prefixed with
CDB_,CON_IDrepresents the tenant ID, while in OceanBase-specific views (prefixed withDBA_OB_,GV$OB_, and so on) usesTENANT_ID. DATA_OBJECT_IDin Oracle-compatible views in the sys tenant corresponds toTABLET_IDin OceanBase-specific views.OWNERin Oracle-compatible views in the sys tenant corresponds todatabasein MySQL-compatible views.
View types
Oracle-compatible views in the sys tenant contain only data dictionary views named in the oceanbase.CDB_* format. Views of this type provide information about some database objects in the sys tenant and user tenants, including all object information, partition information, and table information. Oracle databases provide standard data dictionary views for these database objects. These views can be accessed cross tenants. For example, CDB_OBJECTS can display the information about database objects of all tenants.