Start on Cloud

A unified distributed database ready for your transactional, analytical, and AI workloads.

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All

BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All

PRODUCTS

OceanBase Cloud

OceanBase Database

Tools Connectors and Middleware

QUICK START

OceanBase Cloud OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Document Feedback

GV$OB_PX_WORKER_STAT

Last Updated：2024-04-19 08:42:49 Updated

Purpose

The GV$OB_PX_WORKER_STAT view displays the execution information about each PX worker thread in parallel execution.

Note

This view is introduced since OceanBase Database V4.0.0.

Columns

Column	Type	Nullable?	Description
SESSION_ID	NUMBER(38)	NO	The ID of the session.
TENANT_ID	NUMBER(38)	NO	The ID of the tenant.
SVR_IP	VARCHAR2(46)	NO	The IP address of the server.
SVR_PORT	NUMBER(38)	NO	The port number of the server.
TRACE_ID	VARCHAR2(128)	NO	The trace ID of the SQL statement.
QC_ID	NUMBER(38)	NO	The query coordinator (QC) ID in parallel execution.
SQC_ID	NUMBER(38)	NO	The sub query coordinator (SQC) ID in parallel execution.
WORKER_ID	NUMBER(38)	NO	The thread ID.
DFO_ID	NUMBER(38)	NO	The data flow operator (DFO) ID in parallel execution.
START_TIME	TIMESTAMP(6) WITH LOCAL TIME ZONE	NO	The time when the thread started to run.

Previous topic

GV$OB_PROCESSLIST

Last

Next topic

GV$OB_TABLET_COMPACTION_HISTORY

OceanBase Database

SQL - V4.3.0

What's New
What is OceanBase Database
- Compatibility with MySQL
- Overview
- Differences between the Enterprise Edition and the Community Edition
- Limitations
- System architecture
- Compatibility with Oracle
  - Compatibility with Oracle
  - System views
  - SQL data types
  - Built-in functions
Get Started
- Video tutorials
- Try out OceanBase Database Community Edition
- Try out advanced features of OceanBase Database
  - Scalable OLTP
    - Try out the hot row update capability of OceanBase Database
    - Run the TPC-C benchmark in OceanBase Database
  - Try out operational OLAP
  - Try out parallel import and data compression
  - Try out the multi-tenant feature
- Build a sample application (Oracle mode)
  - Build a C application
  - Build a Java application
- Learn OceanBase SQL
  - Basic SQL operations (Oracle mode)
  - Basic SQL operations (MySQL mode)
  - Before you begin
- Build a sample application (MySQL mode)
  - Build a Python application
  - Build a Java application
  - Build a C application
  - Build a Go application
Develop
- Develop applications (MySQL mode)
  - Sample applications
    - Java
      - Spring Data JDBC
      - Spring Boot
      - Spring Data JPA
      - MyBatis
      - Spring Batch
      - Hibernate
      - Connector/J
      - TestContainers
    - Python
      - PyMySQL
      - mysqlclient
      - MySQL-connector-python
    - C
      - MySQL Connector/C
    - Go
      - GORM
      - Go-SQL-Driver/MySQL
    - PHP
      - EXT
      - MySQLi
      - PDO
  - Write data
    - Delete data
    - Generate test data in batches
    - Update data
    - Insert data
    - Replace data
  - Application errors
    - Common errors and troubleshooting practices
      - Table does not exist, with ERROR 1146 reported
      - Data truncated while being inserted, with ERROR 1265 reported
      - Incorrect user password, with ERROR 1045 reported
      - Transaction timed out, with ERROR 4012 reported
      - User locked, with ERROR 3118 reported
      - Idle transaction timed out, with ERROR 6002 reported
      - Table already exists, with ERROR 1050 reported
      - Duplicate data inserted, with ERROR 1062 reported
      - Disconnected from the server, with ERROR 2013 reported
      - ERROR 1215 reported in foreign key addition
    - Troubleshooting guidelines
      - About error codes
      - Error handling specifications for MySQL-compatible applications
  - Connect to OceanBase Database
    - Connect to an OceanBase tenant by using OBClient
    - Connect to an OceanBase tenant by using the mysql client
    - Connect to OceanBase Database by using ODC
    - Overview
    - Connect to OceanBase Database by using DBeaver
    - Connect to OceanBase Database by using Navicat
    - Use database connection pool
      - HikariCP
      - Proxool
      - DBCP
      - Commons Pool
      - Druid
      - Database connection pool configuration
      - Connect to OceanBase Database by using a Tomcat connection pool
      - c3p0
  - Read data
    - Use a DBLink in queries
    - Single-table queries
    - Set operations
    - Use operators and functions in queries
      - Use aggregate functions in queries
      - Use numerical functions in queries
      - Use the SELECT ... LOCK IN SHARE MODE statement to lock query results
      - Use the CASE conditional operator in queries
      - Use type conversion functions in queries
      - Use datetime functions in queries
      - Use arithmetic operators in queries
      - Use string functions in queries
      - Use string concatenation operators in queries
      - Use NULL-related functions in queries
      - Use the SELECT ... FOR UPDATE statement to lock query results
    - Join tables
      - RIGHT JOIN queries
      - Lateral derived table
      - Subqueries
      - LEFT JOIN queries
      - INNER JOIN queries
      - FULL JOIN queries
  - Plan database objects
    - Create an external table
    - Create an index
    - Create a table group
    - Create a database
    - Create a table
  - Transactions
    - Roll back a transaction
    - Commit a transaction
    - Overview
    - Start a transaction
    - Savepoints
      - Mark a savepoint
      - Release a savepoint
      - Roll back a transaction to a savepoint
- Develop applications (Oracle mode)
  - Sample applications
    - Java
      - Spring Boot
      - MyBatis
      - JFinal
      - OceanBase Connector/J
      - Spring Data JPA
      - Spring Data JDBC
      - Hibernate
      - Spring Batch
    - C/C++
      - OceanBase Connector/C
      - SqlSugar
      - OceanBase Connector/ODBC
  - Read data
    - Set operations
    - Single-table queries
    - Use a DBLink in queries
    - Join tables
      - INNER JOIN queries
      - RIGHT JOIN queries
      - LEFT JOIN queries
      - Subqueries
      - FULL JOIN queries
    - Use operators and functions in queries
      - Use arithmetic operators in queries
      - Use type conversion functions in queries
      - Use aggregate functions in queries
      - Use numerical functions in queries
      - Use string concatenation operators in queries
      - Use CASE functions in queries
      - Use the SELECT...FOR UPDATE statement to lock query results
      - Use string functions in queries
      - Use NULL-related functions in queries
      - Use datetime functions in queries
  - Connect to OceanBase Database
    - Overview
    - Connect to OceanBase Database by using ODC
    - Connect to an OceanBase tenant by using OBClient
    - Use database connection pool
      - c3p0
      - Database connection pool configuration
      - DBCP
      - HikariCP
      - Druid
      - Proxool
      - Tomcat
      - Commons Pool
  - Application errors
    - Common errors and troubleshooting practices
      - Transaction timed out, with Error ORA-00600 reported
      - Idle transaction timed out, with Error ORA-24761 reported
      - Duplicate data inserted, with Error ORA-00001 reported
      - Table does not exist, with Error ORA-04043 reported
      - Inconsistent data types, with Error ORA-00932 reported
      - User locked, with ERROR 3118 reported
      - Table already exists, with Error ORA-00955 reported
      - Error ORA-00600 reported in foreign key addition
      - Incorrect user password, with ERROR 1045 reported
    - Troubleshooting guidelines
      - Error handling specifications for Oracle-compatible applications
      - About error codes
  - Write data
    - Insert data
    - Update data
    - Replace data
    - Delete data
    - Generate test data in batches
  - Transactions
    - Overview
    - Roll back a transaction
    - Commit a transaction
    - Start a transaction
    - Savepoints
      - Roll back a transaction to a savepoint
      - Mark a savepoint
  - Plan database objects
    - Create a table
    - Create an index
    - Create an external table
    - Create a table group
Deploy
- Delete old clusters
- Overview
- High availability deployment solutions for OceanBase clusters
- Deploy OceanBase Database Community Edition
  - Overview
  - Deploy OceanBase Database in a Kubernetes cluster
  - Deploy locally
    - Deploy OceanBase Database in a production environment by using the command line
    - Software and hardware requirements
    - Deploy OceanBase Database by using systemd
    - Before deployment
      - (Optional) Check resources
      - (Optional) Set password-free SSH logon
      - (Optional) Configure the clock source
      - (Optional) Perform disk planning
      - (Optional) Configure limits.conf
      - (Optional) Configure sysctl.conf
      - (Optional) Disable the firewall and SELinux
      - (Optional) Create a user
    - Deploy through GUI
      - Deploy an OceanBase cluster through the GUI of OCP
      - Deploy an OceanBase cluster through the GUI of OBD
- Deploy OceanBase Database Enterprise Edition
  - Deployment process
  - Deploy through GUI
    - (Optional) Deploy ODP
    - Deploy OceanBase clusters using OCP
      - Deploy a two-replica OceanBase cluster with the arbitration service by using OCP
      - Deploy a three-replica OceanBase cluster by using OCP
      - Deploy a single-replica OceanBase cluster by using OCP
    - Configure deployment environment using OAT
      - Add a server
    - Deploy OCP
      - Deploy OCP
      - Create MetaDB
      - Upload installation packages
      - Overview
  - Deploy through CLI
    - (Optional) Deploy ODP
    - Configure deployment environment
      - Initialize an OBServer node using oatcli
      - (Optional) Configure the clock source
    - Deploy OceanBase clusters using CLI
      - Deploy an OceanBase cluster with two replicas and arbitration service using the CLI
      - Deploy a three-replica OceanBase cluster using the CLI
      - Deploy a single-replica OceanBase cluster using the CLI
  - Before deployment
    - Deploy OAT
    - Prepare the installation packages
    - Server configuration
    - Prepare servers
Migrate
- Import data from SQL files to OceanBase Database
- Overview
- Migrate from DB2 databases to OceanBase Database
  - Use OMS to migrate data from a DB2 LUW database to a MySQL tenant of OceanBase Database
  - Use OMS to migrate data from a DB2 LUW database to an Oracle tenant of OceanBase Database
  - Use DBCAT to migrate table schemas from a DB2 LUW database to OceanBase Database
- Migrate from Oracle databases to OceanBase Database
  - Use OMS to migrate data from an Oracle database to an Oracle tenant of OceanBase Database
  - Use DataX to migrate table data from an Oracle database to OceanBase Database
  - Use DBCAT to migrate schemas from an Oracle database to OceanBase Database
  - Use OMS to migrate data from an Oracle database to a MySQL tenant of OceanBase Database
- Migrate from OceanBase Database to MySQL databases
  - Use DataX to migrate table data from OceanBase Database to a MySQL database
  - Use OMS to migrate incremental data from an Oracle tenant of OceanBase Database to a MySQL database
  - Use Flink CDC to migrate data from OceanBase Database to a MySQL database
  - Migrate data from a MySQL database in OceanBase Database to a MySQL database using ChunJun
  - Synchronize data from OceanBase Database to a MySQL database using Canal
  - Use DBCAT to migrate schemas from OceanBase Database to a MySQL database
  - Migrate data from a MySQL OceanBase database to a MySQL database using CloudCanal
  - Use OMS to migrate data from a MySQL tenant of OceanBase Database to a MySQL database
- Migrate data between OceanBase Database
  - Use OBLOADER & OBDUMPER to migrate data from a MySQL tenant to an Oracle tenant in OceanBase Database
  - Use OMS to migrate data from an OceanBase tenant to another of the same type
  - Use OMS to migrate data from an OceanBase tenant to another of the same type in active-active disaster recovery scenarios
  - Use OBLOADER & OBDUMPER to migrate data between Oracle tenants in OceanBase Database
  - Use OBLOADER & OBDUMPER to migrate data between MySQL tenants in OceanBase Database
  - Use OBLOADER & OBDUMPER to migrate data from an Oracle tenant to a MySQL tenant in OceanBase Database
- Bypass import
  - Import data in bypass mode by using the INSERT INTO SELECT statement
  - Import data in bypass mode by using the LOAD DATA statement
  - Overview
- Migrate from MySQL databases to OceanBase Database
  - Use Flink CDC to synchronize data from a MySQL database to OceanBase Database
  - Use OMS to migrate data from a MySQL database to a MySQL tenant of OceanBase Database
  - Use mydumper and myloader to migrate data from a MySQL database to OceanBase Database
  - Use ChunJun to migrate data from a MySQL database to OceanBase Database
  - Migrate data from a MySQL database to OceanBase Database using CloudCanal
  - Use DataX to migrate table data from a MySQL database to OceanBase Database
  - Use DBCAT to migrate schemas from a MySQL database to OceanBase Database
  - Use Canal to synchronize data from a MySQL database to OceanBase Database
- Migrate from CSV files to OceanBase Database
  - Import data by using the LOAD DATA statement
  - Use DataX to migrate CSV files to OceanBase Database
- Migrate from OceanBase Database to Oracle databases
  - Use DBCAT to migrate schemas from OceanBase Database to an Oracle database
  - Use DataX to migrate table data from OceanBase Database to an Oracle database
  - Use OMS to migrate data from an Oracle tenant of OceanBase Database to an Oracle database
- Migrate from PostgreSQL databases to OceanBase Database
  - Use OMS to migrate data from a PostgreSQL database to a MySQL tenant of OceanBase Database
- Migrate data using SQL statements
  - Export data by using OUTFILE statements
  - Migrate resource units
  - Migrate data between tables
- Migrate from OceanBase Database to DB2 databases
  - Use OMS to migrate data from a MySQL tenant of OceanBase Database to a DB2 LUW database
  - Use OMS to migrate data from an Oracle tenant of OceanBase Database to a DB2 LUW database
- Migrate from TiDB databases to OceanBase Database
  - Use OMS to migrate data from a TiDB database to a MySQL tenant of OceanBase Database
Manage
- Log on to an OceanBase tenant
- Manage replicas
  - Traffic distribution
  - Data distribution
  - Overview
  - Replica distribution
    - Locality
    - Common locality operations
      - View locality
      - Adjust the distribution of replicas
      - Remove replicas
      - Add replicas
      - View the locality change history
      - Migrate units
      - Modify locality
- Performance tuning
  - Identify bottlenecks on the data link
  - Overview
  - SQL tuning
    - Locate and analyze slow queries (II)
    - Locate and analyze slow queries I
    - Typical scenarios and cases
    - SQL tuning system
    - Execution plan optimization
      - Order and limit optimization
        Overview
        Optimization in ORDER BY + LIMIT scenarios
        SORT assignment and optimization
      - Plan management
        Disadvantages of the plan cache and countermeasures
        Plan cache
        Views related to the plan cache
      - Statistical information and row estimation
        Overview
        Use statistical information and row estimation
        Statistical information
        Query statistics
        Overview
        Manage statistical information
        Overview
        Lock statistics
        Configure statistics collection strategies
        Query historical versions of statistics and roll back to a specified version
        Delete and set statistics
        Import and export statistics
        Collect statistical information
        Automatic statistics collection
        Overview
        Manually collect statistics
        Row estimation
        Row estimation based on the selectivity
        Overview
        Row estimation based on the storage layer
      - Join order and join algorithm
        Join order
        Join types
        Joins
        Join algorithm
        Nested loop joins
        Common business issues
        Hash joins
        Merge joins
      - Index selection
        Reduce row reads
        Avoid sorting
        Overview
        Avoid table access by index primary key
    - Business logic optimization
      - Schema specifications
      - SQL specifications
  - Identify bottlenecks within components
    - ODP performance bottlenecks
    - ODP performance analysis
    - OBServer performance bottlenecks
      - Overview
      - Capacity issues
      - Hard parsing
      - Internal wait events
      - Non-optimal plan
        Non-optimal plan
        Cardinality
        Buffer tables
- Daily inspection
  - Deadlock detection
  - Overview
  - Check tenant resource usage
  - Check cluster parameters
  - Check cluster resource usage
  - Check the host status
  - Check the NTP offset
  - Check the OBServer node status
  - End-to-end tracing
    - Show end-to-end tracing information
    - Process
    - Methods
    - Overview
- Manage clusters
  - Cluster parameters
  - Overview
  - Common cluster operations
    - Delete a zone
    - Isolate a zone
    - Add a zone
    - Reset a cluster parameter
    - Restart a node
    - Delete a node
    - Modify a zone
    - Modify cluster parameters
    - Isolate a node
    - View cluster parameters
    - View a zone
    - Add a node
    - Start a zone
    - View a node
    - Replace a node
  - Troubleshoot common problems
    - Failures of a minority of nodes
    - Failures of the majority of nodes
- Security and permissions
  - Overview
  - Access control
    - Network security access control
    - Row-level access control
    - RPC connection authentication
    - Overview
    - Users and permissions
      - Overview
      - MySQL mode
        Privilege delegation
        Drop a user
        Lock or unlock a user
        Grant privileges
        Modify user privileges
        Query user privileges
        Create a user
        Privilege types in MySQL mode
      - Oracle mode
        Privilege types in Oracle mode
        Modify user privileges
        Grant indirect privileges
        Query user privileges
        Create a user
        Privilege delegation
        View the information of a user
        Grant direct privileges
        Drop a user
        Lock or unlock a user
        Manage roles
        View roles
        Create a role
        Grant a role to a user
        Overview
        Activate or deactivate roles for a user
        Revoke a role
        Drop a role
        Modify a role
        Grant a role to another role
  - Transparent data encryption
    - Overview
    - Oracle mode
      - Decrypt a table
      - Enable transparent data encryption for existing tables
      - Enable transparent data encryption for new tables
    - MySQL mode
      - Enable transparent data encryption for existing tables
      - Decrypt a table
      - Enable transparent data encryption for new tables
  - Identification and authentication
    - Oracle mode
      - Identity authentication
      - Password complexity
      - Logon failure processing
    - MySQL mode
      - Password complexity
      - Identity authentication
      - Logon failure processing
  - Security audit
    - Audit specified database objects
    - Overview
    - Enable security audit
    - Audit user logon operations
    - Set and view audit rules
    - View audit records
    - Audit user operations
  - Data transmission encryption
    - ODP transmission encryption
    - OBServer transmission encryption
    - Overview
- Backup and restore
  - Introduction to physical backup and restore
  - Experience physical backup and restore with simplified deployment
  - Deploy NFS
  - Optimize backup and restore performance
  - Restore by table
    - Preparations
    - Parameters related to table restore
    - View the table restore result
    - Views related to table restore
    - View the table restore progress
    - Restore data by table
    - Cancel table restore
  - Clear backup data
    - Stop backup cleanup
    - Backup cleanup parameter
    - Query the backup cleanup history
    - Query the backup cleanup progress
    - Views related to backup cleanup
    - Automatic cleanup of expired backups
  - Log archive
    - Overview
    - Disable ARCHIVELOG
    - Change the log archive destination
    - View information about pieces
    - Views related to log archiving
    - View the archiving progress
    - Prepare for log archiving
    - View the archiving history
    - Suspend archiving
    - View archiving parameter settings
    - Enable ARCHIVELOG
  - Restore data
    - Replay logs to a standby tenant
    - Physical restore parameters
    - Views related to physical restore
    - Convert a standby tenant into primary tenant
    - Cancel physical restore
    - Preparations
    - Upgrade a tenant after restore
    - View the physical restore progress
    - View physical restore results
    - Perform physical restore
  - Data backup
    - Views for monitoring backup progress and results
    - View data backup parameter settings
    - Change the backup destination
    - Prepare for the backup
    - View the data backup history
    - Initiate an incremental data backup job
    - Initiate a full data backup job
    - Stop a backup job
    - View the data backup progress
    - Overview
- Emergency response
  - Emergency response overview
  - Analysis, diagnosis, and decision-making procedure
  - Common emergency problem handling
    - Capacity issues
      - Node data disk full
      - obproxy thread exhaustion
      - Exceptions of SQL queries
      - Tenant memory full
      - Node network card overload
      - Tenant request queue backlog
      - Node disk I/O high
      - Node clog disk full
    - Hardware issues
      - Other hardware and network issues
      - Node failure
      - ODP failure
      - Network failure
    - Other cluster issues
      - Insufficiency or leakage of system memory
      - sys tenant or RootService exceptions
- High availability
  - Flashback queries
  - High availability overview
  - Physical standby database disaster recovery
    - Limitations
    - Overview
    - Log storage service
    - Drop primary and standby tenants
    - Log transmission service
      - Pause or resume log synchronization
      - View the log synchronization progress
      - Overview
      - Set log synchronization compression
      - Optimize the log synchronization performance
      - Set the log synchronization bandwidth limit
      - View log restore source information
      - Configure log transmission service
        Configure the log restore source
        Set the log recovery endpoint
    - Create a standby tenant
      - Create a standby tenant by using the BACKUP DATABASE PLUS ARCHIVELOG feature
      - Create a standby tenant by using the backup and recovery feature
      - Create an empty standby tenant
      - Preparations
    - Switch roles
      - Switchover
      - Overview of tenant roles
      - Failover
  - Multi-replica disaster recovery
    - Disaster recovery architecture and levels
    - ODP high availability
    - Database-level high availability
    - Data link introduction
  - Arbitration high availability
    - Enable the arbitration service for a tenant
    - Remove the arbitration service for a cluster
    - Disable the arbitration service for a tenant
    - Query log stream upgrade/downgrade information
    - Replace the arbitration service for a cluster
    - Clear residual cluster information
    - Overview
    - Modify the log stream downgrade control time
  - Manage recycle bin
    - Purge the recycle bin
    - Overview
    - Enable or disable the recycle bin
    - Restore objects from the recycle bin
    - View objects in the recycle bin
- Manage tenants
  - User tenant introduction
  - Tenant system variables
  - Tenant capacity
  - Tenant types
  - Tenant introduction
  - Common tenant operations
    - Rename a tenant
    - Drop a tenant
    - Lock and unlock a tenant
    - Modify attributes of a tenant
    - View tenant and resource information
    - Cancel tenant cloning
    - Modify attributes of a resource pool
    - Create a tenant
    - View and set the tenant allowlist
    - Modify system variables of a tenant
    - Clone a tenant
    - Recover a tenant
    - View tenant system variables
    - Resource isolation
      - Resource isolation overview
      - Manage resource isolation (Oracle mode)
        Configure SQL statement-level resource isolation
        Update a resource management plan config
        Configure cgroups
        Delete a resource management plan
        Configure user-level resource isolation
        Delete a resource management plan config
        Clear cgroup configurations
        Calibrate the disk performance
        Delete a resource group
      - Manage resource isolation (MySQL mode)
        Delete a resource management plan
        Delete a resource group
        Configure user-level resource isolation
        Clear cgroup configurations
        Delete a resource management plan config
        Update a resource management plan config
        Configure cgroups
        Configure SQL statement-level resource isolation
        Calibrate the disk performance
    - Manage unit configs
      - Query unit configs
      - Modify unit configs
      - Drop unit configs
    - Manage resource pools
      - Drop a resource pool
      - Merge and split resource pools
      - View resource pool information
      - Remove resource pools from a tenant
      - Allocate a resource pool to a tenant
    - Scale in/out
      - Modify the unit configs for a tenant
      - Modify the number of primary zones for a tenant
      - Introduction to scaling in/out
      - Modify the number of resource units for a tenant
- Troubleshooting
  - Bootstrap
  - Log synchronization-related errors
  - Overview
  - Troubleshoot SQL execution errors
  - Application exception -- error message does not contain OceanBase error code
  - Application exception -- error message contains an OceanBase error code
  - Backup and restore
    - Physical restore failures
    - Data backup failures
  - Transaction
    - Suspended transactions
    - Long-running transactions
    - Transaction-related errors
    - Transaction rollbacks
    - Idle transactions
  - Physical standby database
    - Switchover failures
    - Log synchronization stuck for the physical standby database
  - Election
    - Leader switchover exceptions
    - Absence of the leader
    - Election
  - Storage
    - Migration, replication, and rebuild tasks
    - Minor compaction and major compaction
    - Memory-related errors
- Monitor
  - Overview
  - Cases
  - Metrics
    - SQL monitoring
      - Overview
      - SQL audit
      - Execution plans
    - System monitoring
      - Wait events
      - Metrics
      - Latch events
      - Overview
- Logs
  - Log levels
  - Log metrics
  - Log control
  - Overview
  - Log stability
  - View logs
    - Query the log of a previous SQL request by using the SQL Trace feature
    - Search for the logs of a specific SQL request
Reference
- SQL reference
  - Reserved keywords (Oracle mode)
  - Reserved keywords (MySQL mode)
  - SQL syntax
    - User tenants (MySQL mode)
      - Sequence pseudocolumns
      - Functions
        Overview
        JSON functions
        Overview
        JSON_TABLE
        Search JSON text functions
        JSON_OVERLAPS
        JSON_EXTRACT
        JSON_KEYS
        JSON_CONTAINS
        JSON_CONTAINS_PATH
        MEMBER OF
        JSON_SEARCH
        JSON_VALUE
        Return JSON text property functions
        JSON_VALID
        JSON_DEPTH
        JSON_LENGTH
        JSON_TYPE
        Modify JSON text functions
        JSON_REPLACE
        JSON_MERGE_PATCH
        JSON_MERGE
        JSON_SET
        JSON_UNQUOTE
        JSON_REMOVE
        JSON_INSERT
        JSON_ARRAY_INSERT
        JSON_ARRAY_APPEND
        JSON_MERGE_PRESERVE
        Create JSON text functions
        JSON_OBJECT
        JSON_QUOTE
        JSON_ARRAY
        JSON aggregate functions
        JSON_ARRAYAGG
        JSON_OBJECTAGG
        JSON utility functions
        JSON_PRETTY
        JSON_STORAGE_SIZE
        Single-row functions
        Mathematical functions
        COS
        GENERATOR
        ZIPF
        RANDOM
        ACOS
        CONV
        ABS
        LOG2
        TAN
        EXP
        LOG10
        ATAN
        RAND
        DEGREES
        FLOOR
        ATAN2
        BIT_COUNT
        LOG
        POWER
        CEIL
        SIGN
        PI
        MOD
        TRUNCATE
        RADIANS
        NEG
        UNIFORM
        NORMAL
        SQRT
        LN
        ASIN
        CRC32
        RANDSTR
        CEILING
        POW
        SIN
        ROUND
        COT
        Datetime functions
        FROM_DAYS
        CURRENT_TIMESTAMP
        TIME
        SUBTIME
        DATE_FORMAT
        FROM_UNIXTIME
        UTC_DATE
        DATE_ADD
        LOCALTIME
        GET_FORMAT
        USEC_TO_TIME
        SECOND
        TIME_TO_SEC
        QUARTER
        LAST_DAY
        TIME_FORMAT
        SEC_TO_TIME
        MICROSECOND
        CURRENT_DATE
        YEARWEEK
        TO_SECONDS
        MINUTE
        MAKEDATE
        TIMESTAMPADD
        YEAR
        PERIOD_DIFF
        SUBDATE
        DAYOFYEAR
        SYSDATE
        UTC_TIMESTAMP
        HOUR
        CURDATE
        DAYOFWEEK
        TIMEDIFF
        STR_TO_DATE
        MONTH
        WEEK
        EXTRACT
        MAKETIME
        DAY
        UNIX_TIMESTAMP
        WEEKDAY
        ADDTIME
        CURTIME
        DAYNAME
        DAYOFMONTH
        DATE_SUB
        TIMESTAMPDIFF
        CURRENT_TIME
        UTC_TIME
        PERIOD_ADD
        WEEKOFYEAR
        NOW
        DATEDIFF
        TO_DAYS
        MONTHNAME
        CONVERT_TZ
        ADDDATE
        DATE
        LOCALTIMESTAMP
        TIMESTAMP
        TIME_TO_USEC
        String functions
        UNHEX
        RTRIM
        UCASE
        REPLACE
        LOWER
        CONCAT_WS
        REGEXP_SUBSTR
        OCTET_LENGTH
        LEFT
        REGEXP_REPLACE
        REGEXP_LIKE
        WEIGHT_STRING
        CONCAT
        IP2INT
        LPAD
        BIN
        RPAD
        SUBSTRING
        SPACE
        FORMAT
        MAKE_SET
        REPEAT
        ASCII
        LOCATE
        FROM_BASE64
        SOUNDEX
        INSERT
        TO_BASE64
        OCT
        FIELD
        QUOTE
        CHARACTER_LENGTH
        HEX
        RLIKE
        POSITION
        REVERSE
        REGEXP
        STRCMP
        EXPORT_SET
        INSTR
        SUBSTR
        SUBSTRING_INDEX
        BIT_LENGTH
        REGEXP_INSTR
        MID
        LCASE
        UPPER
        ORD
        ELT
        LENGTH
        CHAR
        TRIM
        CHAR_LENGTH
        RIGHT
        FIND_IN_SET
        INT2IP
        LTRIM
        Comparison functions
        INTERVAL
        LEAST
        GREATEST
        ISNULL
        Conversion functions
        CAST
        CONVERT
        SCN_TO_TIMESTAMP
        TIMESTAMP_TO_SCN
        Process control functions
        IF
        NULLIF
        IFNULL
        ORA_DECODE
        CASE
        Encryption functions
        AES_DECRYPT
        RANDOM_BYTES
        DES_ENCRYPT
        COMPRESS
        UNCOMPRESS
        SHA1
        SHA2
        AES_ENCRYPT
        DES_DECRYPT
        ENCODE
        UNCOMPRESSED_LENGTH
        ENCRYPT
        MD5
        DECODE
        SHA
        VALIDATE_PASSWORD_STRENGTH
        Aggregate functions
        VAR_POP
        GROUPING
        GROUP_CONCAT
        STD
        COUNT
        VARIANCE
        STDDEV_POP
        MIN
        BIT_AND
        SUM
        BIT_XOR
        AVG
        STDDEV
        APPROX_COUNT_DISTINCT
        VAR_SAMP
        MAX
        BIT_OR
        STDDEV_SAMP
        Analysis functions
        STDDEV_SAMP
        BIT_XOR
        CUME_DIST
        STD
        COUNT
        LAG
        FIRST_VALUE
        MIN
        STDDEV_POP
        VAR_SAMP
        SUM
        STDDEV
        RANK
        BIT_OR
        VARIANCE
        DENSE_RANK
        LAST_VALUE
        PERCENT_RANK
        NTILE
        AVG
        MAX
        APPROX_COUNT_DISTINCT
        VAR_POP
        LEAD
        NTH_VALUE
        ROW_NUMBER
        BIT_AND
        Other functions
        BIN_TO_UUID
        ANY_VALUE
        INET_NTOA
        UUID
        DEFAULT
        IS_UUID
        COALESCE
        UUID_TO_BIN
        IS_IPV6
        SLEEP
        UUID_SHORT
        VALUES
        NAME_CONST
        INET6_ATON
        IS_IPV4_COMPAT
        IS_IPV4
        INET_ATON
        INET6_NTOA
        NVL
        Information functions
        SESSION_USER
        SCHEMA
        BENCHMARK
        LAST_INSERT_ID
        SYSTEM_USER
        ICU_VERSION
        CONNECTION_ID
        COERCIBILITY
        FOUND_ROWS
        VERSION
        CURRENT_USER
        USER
        COLLATION
        CHARSET
        ROW_COUNT
        DATABASE
        OB_VERSION
        OB_TRANSACTION_ID
        Spatial functions
        Spatial relation functions
        Functions that create geometry values
        Geometry property functions
        Geometry format conversion functions
        Spatial operation functions
        Performance schema functions
        FORMAT_BYTES
        FORMAT_PICO_TIME
      - SQL statements
        LOAD DATA
        CREATE DATABASE
        INSERT
        SET CHARSET
        EXPLAIN
        HELP
        DROP TABLE
        RENAME USER
        EXECUTE
        General syntax
        LOCK TABLES
        DROP SEQUENCE
        SELECT INTO
        PURGE
        REVOKE
        DROP VIEW
        CREATE RESTORE POINT
        PREPARE
        TRUNCATE TABLE
        RENAME TABLE
        CREATE MATERIALIZED VIEW LOG
        DEALLOCATE PREPARE
        CREATE INDEX
        DELETE
        DROP OUTLINE
        CREATE TABLE
        CREATE SEQUENCE
        CREATE VIEW
        SAVEPOINT
        GRANT
        DROP TABLEGROUP
        CREATE OUTLINE
        ALTER DATABASE
        ALTER OUTLINE
        ALTER TABLEGROUP
        DROP DATABASE
        SET PASSWORD
        CREATE DATABASE LINK
        SHOW
        DESCRIBE
        REPLACE
        VALUES
        DROP MATERIALIZED VIEW LOG
        ALTER USER
        SET
        DROP USER
        TRANSACTION
        MERGE
        SET NAMES
        UPDATE
        DROP INDEX
        KILL
        ANALYZE
        CREATE USER
        OPTIMIZE
        DROP DATABASE LINK
        CREATE EXTERNAL TABLE
        CREATE TABLEGROUP
        ALTER SEQUENCE
        ALTER TABLE
        ALTER VIEW
        DROP MATERIALIZED VIEW
        MAJOR and MINOR
        FLASHBACK
        SCHEMA
        USE
        CREATE MATERIALIZED VIEW
        PURGE RECYCLEBIN
        ALTER EXTERNAL TABLE
        Common Table Expressions
        SET TRANSACTION
        ALTER TABLEGROUP
        CREATE TABLESPACE
        DROP TABLESPACE
        SELECT
        SELECT statement
        OVER clause
        JOIN clause
        UNION clause
      - Basic elements
        Schema object names
        Comments
        User-defined variables
        Data types
        SET type
        Overview
        ENUM type
        Datetime types
        TIME type
        DATE, DATETIME, and TIMESTAMP types
        Overview
        YEAR type
        Numeric types
        Floating-point data types
        Overview
        Fixed-point data types
        Bit value data type
        Integer data types
        Spatial data types
        Overview
        Spatial data formats
        Create a spatial index
        Create a spatial column
        SRS
        Large objects and text types
        TEXT types
        LOB type
        Overview
        BLOB types
        JSON data types
        Overview
        Query and modify JSON values
        Create a JSON value
        Convert a JSON data type
        String types
        BINARY and VARBINARY
        Overview
        CHAR and VARCHAR
        Character set and collation
        Database-level character sets and collations
        Overview
        Column-level character sets and collations
        Collations
        Character sets
        Character sets and collations for client connection
        Character sets and collations for character expressions
        Table-level character sets and collations
        Literals
        Overview
        Strings
        NULLs
        Boolean values
        Bit values
        Numbers
        Datetime values
        Expressions
        Convert data types in expression evaluation
        Expression syntax
        Overview
      - Queries and subqueries
        Joins
        Overview
        Subqueries
      - Operators
        Bitwise operators
        Date and time operators
        CASE conditional operator
        Operator precedence
        Logical operators
        BINARY operator
        Assignment operators
        Arithmetic operators
        Overview
        Concatenation operators
        Comparison operators
      - DDL feature
        Column type change rules
        Generated column operations
        Column operations
        Foreign key operations
        Partition operations
        Overview
        Online and offline DDL operations
        Primary key operations
        Index operations
        Conversion rules for numeric data types
        Table operations
    - User tenants (Oracle mode)
      - Introduction to SQL
      - Functions
        Overview
        Single-row functions
        JSON functions
        Overview
        Modify JSON text functions
        JSON_MERGEPATCH
        Create JSON text functions
        JSON_ARRAY
        JSON_OBJECTAGG
        JSON_ARRAYAGG
        JSON_OBJECT
        Query JSON text functions
        JSON_TABLE
        JSON_VALUE
        JSON_EXISTS
        JSON_QUERY
        Validate JSON text functions
        JSON_EQUAL
        Conversion functions
        TO_CHAR(number)
        TO_TIMESTAMP
        RAWTOHEX
        ASCIISTR
        TO_DATE
        TO_NCHAR(character)
        TO_NCHAR(number)
        TO_YMINTERVAL
        TO_MULTI_BYTE
        SCN_TO_TIMESTAMP
        TO_BLOB
        CHARTOROWID
        CONVERT
        TO_BINARY_DOUBLE
        ROWIDTONCHAR
        TO_DSINTERVAL
        TO_NUMBER
        TIMESTAMP_TO_SCN
        TO_CHAR(datetime)
        TO_BINARY_FLOAT
        NUMTOYMINTERVAL
        TO_CLOB
        NUMTODSINTERVAL
        UNISTR
        HEXTORAW
        TO_CHAR(character)
        ROWIDTOCHAR
        TO_NCHAR(datetime)
        TO_TIMESTAMP_TZ
        CAST
        TO_SINGLE_BYTE
        Numeric functions
        ABS
        ACOS
        ASIN
        ATAN
        ATAN2
        BITAND
        CEIL
        COS
        COSH
        EXP
        FLOOR
        LN
        GENERATOR
        LOG
        MOD
        NANVL
        NORMAL
        POWER
        REMAINDER
        ROUND
        RANDOM
        RANDSTR
        SIGN
        SIN
        SINH
        SQRT
        TAN
        TANH
        TRUNC
        UNIFORM
        WIDTH_BUCKET
        ZIPF
        Datetime functions
        NUMTODSINTERVAL
        EXTRACT(datetime)
        TRUNC(date)
        TZ_OFFSET
        CURRENT_DATE
        ADD_MONTHS
        FROM_TZ
        SYS_EXTRACT_UTC
        TO_TIMESTAMP
        TO_CHAR(datetime)
        TO_YMINTERVAL
        SYSTIMESTAMP
        NEXT_DAY
        TO_DSINTERVAL
        DBTIMEZONE
        ROUND(date)
        MONTHS_BETWEEN
        NUMTOYMINTERVAL
        SESSIONTIMEZONE
        SYSDATE
        LAST_DAY
        TO_TIMESTAMP_TZ
        LOCALTIMESTAMP
        CURRENT_TIMESTAMP
        Generic comparison functions
        GREATEST
        LEAST
        String functions that return a string
        CONCAT
        INITCAP
        CHR
        NLS_LOWER
        REPLACE
        LPAD
        SUBSTR
        LTRIM
        NLSSORT
        TRANSLATE ... USING
        TRIM
        UPPER
        REGEXP_REPLACE
        TRANSLATE
        RTRIM
        RPAD
        LOWER
        NLS_UPPER
        REGEXP_SUBSTR
        XML functions
        Overview
        Construct XMLType data functions
        XMLAGG
        XMLATTRIBUTES
        XMLPARSE
        XMLELEMENT
        Modify XMLType data functions
        UPDATEXML
        Query XMLType data functions
        EXTRACTVALUE
        XMLSERIALIZE
        XMLCAST
        EXTRACT
        Null value related functions
        NULLIF
        NVL2
        COALESCE
        NANVL
        NVL
        LNNVL
        String functions that return numbers
        INSTR
        LENGTH
        ASCII
        REGEXP_COUNT
        REGEXP_INSTR
        Environment and identifier functions
        SYS_GUID
        OB_VERSION
        UID
        USERENV
        SYS_CONTEXT
        USER
        Encoding and decoding functions
        ORA_HASH
        DECODE
        VSIZE
        DUMP
        Hierarchical functions
        SYS_CONNECT_BY_PATH
        Analysis functions
        AVG
        CORR
        PERCENTILE_DISC
        VARIANCE
        LISTAGG
        VAR_SAMP
        WMSYS.WM_CONCAT/WM_CONCAT
        COVAR_SAMP
        CUME_DIST
        PERCENT_RANK
        MIN
        STDDEV_POP
        LAG
        Analytic functions
        STDDEV_SAMP
        NTILE
        MAX
        VAR_POP
        RANK
        NTH_VALUE
        MEDIAN
        COUNT
        RATIO_TO_REPORT
        FIRST_VALUE
        STDDEV
        SUM
        KEEP
        COVAR_POP
        LEAD
        PERCENTILE_CONT
        REGR_(Linear Regression)
        ROW_NUMBER
        DENSE_RANK
        LAST_VALUE
        Aggregate functions
        WMSYS.WM_CONCAT/WM_CONCAT
        GROUPING
        COVAR_POP
        GROUPING_ID
        PERCENTILE_DISC
        LISTAGG
        ROLLUP
        VAR_SAMP
        GROUP_ID
        STDDEV_POP
        SUM
        MAX
        VAR_POP
        CORR
        AVG
        STDDEV_SAMP
        STDDEV
        MIN
        PERCENT_RANK
        VARIANCE
        CUME_DIST
        PERCENTILE_CONT
        RANK
        REGR_(Linear Regression)
        DENSE_RANK
        APPROX_COUNT_DISTINCT
        MEDIAN
        KEEP
        COVAR_SAMP
        COUNT
        Information functions
        OB_TRANSACTION_ID
      - SQL statements
        DDL
        CREATE PROFILE
        CREATE MATERIALIZED VIEW
        CREATE TABLESPACE
        CREATE SYNONYM
        DROP TABLE
        DROP USER
        DROP TABLESPACE
        CREATE TABLEGROUP
        ALTER KEYSTORE
        CREATE DIRECTORY
        DROP DATABASE LINK
        ALTER TABLE
        CREATE VIEW
        MAJOR and MINOR
        DROP MATERIALIZED VIEW
        CREATE TABLE
        DROP PROFILE
        ALTER EXTERNAL TABLE
        DROP DIRECTORY
        ALTER PROFILE
        DROP TABLEGROUP
        CREATE EXTERNAL TABLE
        ALTER SYSTEM PARAMETER
        CREATE INDEX
        CREATE KEYSTORE
        CREATE OUTLINE
        DROP VIEW
        ALTER SESSION
        ALTER INDEX
        CREATE SEQUENCE
        CREATE USER
        ALTER TABLEGROUP
        RENAME
        CREATE MATERIALIZED VIEW LOG
        CREATE ROLE
        ALTER OUTLINE
        DROP SEQUENCE
        ALTER SYSTEM FLUSH PLAN CACHE
        CREATE DATABASE LINK
        ALTER ROLE
        DROP CONTEXT
        DROP OUTLINE
        CREATE CONTEXT
        DROP INDEX
        ALTER USER
        DROP SYNONYM
        ALTER SEQUENCE
        DROP MATERIALIZED VIEW LOG
        DROP ROLE
        TRUNCATE TABLE
        DML
        UPDATE
        MERGE
        PURGE
        EXPLAIN
        INSERT
        DELETE
        SELECT
        Set-based SELECT
        SIMPLE SELECT
        WITH clause
        DCL
        SET PASSWORD
        TRANSACTION
        GRANT
        SHRINK
        SET VARIABLE
        SET NAMES
        AUDIT
        ANALYZE
        FLASHBACK TABLE BEFORE DROP
        ALTER SYSTEM KILL SESSION
        LOAD DATA
        LOCK TABLE
        COMMENT
        COMMIT
        REVOKE
        SAVEPOINT
        KILL
        ROLLBACK
        SHOW
        SET ROLE
      - Pseudo columns
        Sequence pseudocolumns
        Overview
        ORA_ROWSCN pseudocolumn
        ROWNUM pseudocolumn
        Hierarchical query pseudocolumns
        ROWID pseudocolumn
      - Expressions
        Function expressions
        Datetime expressions
        Column expressions
        Compound expressions
        Scalar subquery expressions
        Overview
        Case expressions
        Expression list
        Interval expressions
        CURSOR expressions
        Type constructor expressions
        Simple expressions
      - DDL feature
        Online and offline DDL operations
        Index operations
        Partition operations
        Column operations
        Primary key operations
        Column type change rules
        Generated column operations
        Table operations
        Foreign key operations
        Conversion rules for numeric data types
        Overview
      - Basic elements
        Character sets and collations
        Built-in data types
        Rowid data types
        Any types
        RAW data type
        Overview
        User-defined data types
        Numeric data types
        Precedence of numeric data types
        NUMBER data type
        FLOAT data type
        Overview
        Floating-point numbers
        Datetime and interval data types
        INTERVAL YEAR TO MONTH data type
        TIMESTAMP data type
        TIMESTAMP WITH TIME ZONE data type
        DATE data type
        INTERVAL DAY TO SECOND data type
        Calculation of dates, timestamps, and intervals
        TIMESTAMP WITH LOCAL TIME ZONE data type
        Overview
        Large object data types
        CLOB data type
        BLOB data type
        Overview
        JSON data types
        Create JSON columns
        Query JSON data
        Overview
        Conversion rules for JSON data types
        Character data types
        CHAR data type
        Overview
        NVARCHAR2 data type
        NCHAR data type
        VARCHAR2 data type
        VARCHAR data type
        XML data types
        Query XMLType data
        XML data definition
        Convert XMLType data
        Create an XMLType column
        Overview
        Database objects
        Non-schema objects
        Schema objects
        Database naming conventions
        Suggestions on schema object names
        Overview
        Annotations
        Overview
        Comments on schema and non-schema objects
        Comments within SQL statements
        Hints
        Overview
        Hint list
        Hints related to access path
        Hints related to join orders
        Hints related to joins
        Hints related to parallel execution
        Hints related to query strategy
        Hints related to query conversion
        Other hints
        Database object reference methods
        Reference an attribute or method of an object type
        Overview
        Reference partitioned tables and indexes
        Reference schema objects
        Reference objects in a remote database
        Create a DBLink
        Reference a DBLink
        Literals
        Interval literals
        Text literals
        Numeric literals
        Overview
        Datetime literals
        Timestamp literals
        Date literals
        Data type comparison rules
        Data type conversion rules
        Date value comparison rules
        Overview
        Security considerations for data conversion
        Numeric value comparison rules
        Data type precedence
        Character value comparison rules
        Format model
        Number format models
        RR datetime format element
        Datetime format models
        Overview
        String-to-date conversion rules
        NULL value
        Overview
        NULLs in comparison conditions
        NULLs in SQL functions
        NULLs in conditional expressions
      - Conditions
        Pattern-matching conditions
        Logical conditions
        NULL conditions
        Overview
        IN condition
        Condition precedence
        BETWEEN condition
        Compound conditions
        Floating-point conditions
        Comparison conditions
        EXISTS condition
      - Operators
        Arithmetic operators
        Set operators
        COLLATE operator
        Operator precedence
        Overview
        Hierarchical query operators
        Concatenation operator
      - Queries and subqueries
        DUAL table query
        Simple query
        Hierarchical query
        Subquery
        Join query
        Compound query
        Overview
    - System tenants
      - ALTER RESOURCE UNIT
      - CREATE RESOURCE POOL
      - SET DECRYPTION
      - DROP RESOURCE UNIT
      - CREATE TENANT
      - CREATE RESOURCE UNIT
      - SET ENCRYPTION
      - ALTER RESOURCE POOL
      - ALTER RESOURCE TENANT
      - CREATE STANDBY TENANT
      - DROP TENANT
      - ALTER TENANT
      - DROP RESOURCE POOL
      - Overview
      - ALTER SYSTEM
        CANCEL RECOVER TABLE
        RECOVER TABLE
        ACTIVATE STANDBY
        REFRESH
        RECOVER STANDBY
        ARBITRATION
        ARCHIVELOG
        CANCEL DELETE BACKUP
        SET LOG_RESTORE_SOURCE
        BOOTSTRAP
        SET DATA_BACKUP_DEST
        SET LOG_ARCHIVE_DEST
        CHANGE TENANT
        THROTTLE
        BACKUP KEY
        SWITCHOVER
        CANCEL CLONE
        RESTORE
        BACKUP
        NOARCHIVELOG
        SERVER
        FLUSH PLAN CACHE
        CANCEL MIGRATE UNIT
        JOB
        CANCEL RESTORE
        MIGRATE UNIT
        SET LOG_ARCHIVE_DEST_STATE
        PARAMETER
        BALANCE TASK
        RECOVER STANDBY CANCEL
        CANCEL BACKUP
        DELETE BACKUP POLICY
        ZONE
        MAJOR and MINOR
        WASH MEMORY FRAGMENTATION
  - PL reference
    - PL reference (Oracle mode)
      - Reserved PL keywords
      - DDL operations on stored PL units
        Overview
        DROP FUNCTION
        CREATE PACKAGE BODY
        CREATE TRIGGER
        DROP TYPE BODY
        CREATE FUNCTION
        CREATE PACKAGE
        CREATE PROCEDURE
        DROP TYPE
        DROP PROCEDURE
        DROP TRIGGER
        ALTER PACKAGE
        CREATE TYPE
        DROP PACKAGE
        ALTER TRIGGER
        ALTER PROCEDURE
        CREATE TYPE BODY
        ALTER TYPE
        ALTER FUNCTION
      - PL static SQL
        Transaction processing and control
        Overview
        Cursors
        Traverse cursor data by using the FOR loop
        Overview
        Implicit cursors
        Cursor variables
        Cursor attributes
        Explicit cursors
        Modify and drop a cursor
        Autonomous transactions
        Call autonomous functions from SQL statements
        Autonomous triggers
        Control autonomous transactions
        Overview
      - PL stored procedures and functions
        Privilege control
        Create a function
        Manage stored procedures and functions
        Collection of stored procedure information and its impact on parallel execution of SQL statements
        Create a stored procedure
        PL DBLinks
        Overview
        User-defined functions
        Use user-defined aggregate functions
        Overview
        Interface for user-defined aggregate functions
        Create user-defined aggregate functions
        Pipeline functions
        Overview
        Application
        Create a pipelined table function
      - PL system package (Oracle mode)
        Overview
        UTL_RAW
        BIT_AND
        CAST_TO_VARCHAR2
        CAST_TO_BINARY_FLOAT
        Overview
        CAST_TO_RAW
        CAST_FROM_BINARY_DOUBLE
        BIT_OR
        REVERSE
        CAST_FROM_BINARY_FLOAT
        CAST_TO_BINARY_DOUBLE
        COMPARE
        CONCAT
        CAST_FROM_BINARY_INTEGER
        BIT_XOR
        CAST_FROM_NUMBER
        CAST_TO_BINARY_INTEGER
        SUBSTR
        BIT_COMPLEMENT
        COPIES
        LENGTH
        CAST_TO_NUMBER
        DBMS_XPLAN
        Overview
        DISPLAY_ACTIVE_SESSION_PLAN
        DISPLAY_CURSOR
        DISPLAY
        DISABLE_OPT_TRACE
        DISPLAY_SQL_PLAN_BASELINE
        ENABLE_OPT_TRACE
        SET_OPT_TRACE_PARAMETER
        DBMS_LOB
        CREATETEMPORARY
        GETLENGTH
        OPEN
        APPEND
        SUBSTR
        INSTR
        ERASE
        WRITEAPPEND
        ISTEMPORARY
        Overview
        CLOSE
        READ
        TRIM
        COPY
        FREETEMPORARY
        WRITE
        ISOPEN
        DBMS_MVIEW
        REFRESH
        Overview
        PURGE_LOG
        DBMS_DEBUG
        Overview
        ATTACH_SESSION
        CONTINUE
        DEBUG_ON
        DEBUG_OFF
        DETACH_SESSION
        DELETE_BREAKPOINT
        DISABLE_BREAKPOINT
        ENABLE_BREAKPOINT
        GET_VALUE
        GET_VALUES
        GET_RUNTIME_INFO
        GET_TIMEOUT_BEHAVIOUR
        INITIALIZE
        PROBE_VERSION
        PRINT_BACKTRACE
        SET_TIMEOUT
        SET_TIMEOUT_BEHAVIOUR
        SET_BREAKPOINT
        SHOW_BREAKPOINTS
        DBMS_STATS
        GET_PARAM
        LOCK_SCHEMA_STATS
        LOCK_PARTITION_STATS
        RESET_PARAM_DEFAULTS
        UNLOCK_PARTITION_STATS
        IMPORT_COLUMN_STATS
        CREATE_STAT_TABLE
        EXPORT_INDEX_STATS
        EXPORT_SCHEMA_STATS
        SET_SYSTEM_STATS
        GATHER_INDEX_STATS
        SET_GLOBAL_PREFS
        GATHER_SCHEMA_STATS
        COPY_TABLE_STATS
        EXPORT_TABLE_STATS
        RESET_GLOBAL_PREF_DEFAULTS
        SET_PARAM
        GATHER_SYSTEM_STATS
        FLUSH_DATABASE_MONITORING_INFO
        IMPORT_TABLE_STATS
        UNLOCK_TABLE_STATS
        IMPORT_SCHEMA_STATS
        EXPORT_COLUMN_STATS
        RESTORE_TABLE_STATS
        GATHER_TABLE_STATS
        PURGE_STATS
        DELETE_SCHEMA_STATS
        DELETE_TABLE_STATS
        DELETE_TABLE_PREFS
        GET_PREFS
        SET_INDEX_STATS
        DELETE_INDEX_STATS
        DELETE_COLUMN_STATS
        UNLOCK_SCHEMA_STATS
        SET_TABLE_STATS
        SET_TABLE_PREFS
        ALTER_STATS_HISTORY_RETENTION
        DELETE_SCHEMA_PREFS
        RESTORE_SCHEMA_STATS
        SET_COLUMN_STATS
        DELETE_SYSTEM_STATS
        Overview
        DROP_STAT_TABLE
        SET_SCHEMA_PREFS
        GET_STATS_HISTORY_AVAILABILITY
        LOCK_TABLE_STATS
        GET_STATS_HISTORY_RETENTION
        IMPORT_INDEX_STATS
        DBMS_UTILITY
        IS_CLUSTER_DATABASE
        OLD_CURRENT_SCHEMA
        GET_SQL_HASH
        FORMAT_ERROR_BACKTRACE
        DB_VERSION
        FORMAT_ERROR_STACK
        GET_ENDIANNESS
        ACTIVE_INSTANCES
        Overview
        GET_HASH_VALUE
        GET_PARAMETER_VALUE
        PORT_STRING
        TABLE_TO_COMMA
        NAME_RESOLVE
        GET_TIME
        IS_BIT_SET
        OLD_CURRENT_USER
        FORMAT_CALL_STACK
        NAME_TOKENIZE
        CURRENT_INSTANCE
        DBMS_AUDIT_MGMT
        CLEAN_AUDIT_TRAIL
        SET_LAST_ARCHIVE_TIMESTAMP
        SET_PURGE_JOB_STATUS
        Overview
        CREATE_PURGE_JOB
        DROP_PURGE_JOB
        DBMS_MVIEW_STAT
        PURGE_REFRESH_STATS
        SET_MVREF_STATS_PARAMS
        Overview
        SET_SYSTEM_DEFAULT
        DBMS_XA
        DBMS_XA_XID object type
        XA_RECOVER
        DBMS_XA constants
        XA_PREPARE
        XA_SETTIMEOUT
        XA_GETLASTOER
        XA_START
        XA_END
        XA_ROLLBACK
        XA_FORGET
        Overview
        DIST_TXN_SYNC
        XA_COMMIT
        UTL_FILE
        FFLUSH
        PUT
        FREMOVE
        FCLOSE
        PUT_LINE
        FGETPOS
        FSEEK
        NEW_LINE
        Overview
        FOPEN
        FRENAME
        GET_LINE
        DBMS_OUTPUT
        Overview
        DISABLE
        ENABLE
        GET_LINE
        GET_LINES
        NEW_LINE
        PUT
        PUT_LINE
        DBMS_SQL
        DEFINE_ARRAY
        EXECUTE_AND_FETCH
        DESCRIBE_COLUMNS
        Overview
        BIND_VARIABLE
        OPEN_CURSOR
        EXECUTE
        COLUMN_VALUE
        CLOSE_CURSOR
        LAST_ERROR_POSITION
        IS_OPEN
        DEFINE_COLUMN
        PARSE
        FETCH_ROWS
        VARIABLE_VALUE
        XMLType
        CREATEXML
        XMLTYPE
        GETSTRINGVAL
        Overview
        TRANSFORM
        GETCLOBVAL
        DBMS_MONITOR
        OB_SESSION_TRACE_DISABLE
        OB_CLIENT_ID_TRACE_ENABLE
        Overview
        OB_SESSION_TRACE_ENABLE
        OB_CLIENT_ID_TRACE_DISABLE
        OB_TENANT_TRACE_DISABLE
        OB_MOD_ACT_TRACE_DISABLE
        OB_MOD_ACT_TRACE_ENABLE
        OB_TENANT_TRACE_ENABLE
        DBMS_DESCRIBE
        DESCRIBE_PROCEDURE
        Overview
        DBMS_SCHEDULER
        Overview
        SET_ATTRIBUTE
        DROP_JOB
        DISABLE
        SET_JOB_ARGUMENT_VALUE
        GENERATE_JOB_NAME
        ENABLE
        RUN_JOB
        DROP_PROGRAM
        CREATE_PROGRAM
        DEFINE_PROGRAM_ARGUMENT
        CREATE_JOB
        DBMS_XMLGEN
        Overview
        CONVERT
        UTL_I18N
        Overview
        RAW_TO_CHAR
        STRING_TO_RAW
        ODCIConst
        ODCIStatsOptions.Options
        ODCIIndexInfo.IndexParaDegree
        ODCIEnv.CallProperty
        Overview
        ODCIIndexInfo.IndexInfoFlags
        ODCIIndexAlter
        ODCIStatsOptions.Flags
        ScnFlg
        ODCIIndexAlter parameter alter_option
        ODCIArgDesc.ArgType
        ODCIPredInfo.Flags
        ODCIQueryInfo.Flags
        Return Status
        ODCIEnv.Envflags
        DBMS_SESSION
        SET_CONTEXT
        CLEAR_CONTEXT
        SET_IDENTIFIER
        CLEAR_IDENTIFIER
        CLEAR_ALL_CONTEXT
        Overview
        RESET_PACKAGE
        ANYDATA TYPE
        ENDCREATE member procedure
        SET* member procedures
        GETTYPE member function
        Overview
        GET* member functions
        PIECEWISE member procedure
        BEGINCREATE static procedure
        GETTYPENAME member function
        DBMS_RANDOM
        TERMINATE
        STRING
        Overview
        RANDOM
        NORMAL
        SEED
        INITIALIZE
        VALUE
        UTL_ENCODE
        BASE64_ENCODE
        Overview
        BASE64_DECODE
        DBMS_UDR
        DISABLE_RULE
        ENABLE_RULE
        REMOVE_RULE
        Overview
        CREATE_RULE
        DBMS_LOCK
        REQUEST
        SLEEP
        ALLOCATE_UNIQUE
        ALLOCATE_UNIQUE_AUTONOMOUS
        Overview
        DBMS_RESOURCE_MANAGER
        CREATE_PLAN
        CREATE_PLAN_DIRECTIVE
        DELETE_CONSUMER_GROUP
        DELETE_PLAN
        Overview
        UPDATE_PLAN_DIRECTIVE
        CREATE_CONSUMER_GROUP
        DELETE_PLAN_DIRECTIVE
        SET_CONSUMER_GROUP_MAPPING
        DBMS_METADATA
        Overview
        GET_DDL
        DBMS_JOB
        RUN
        Overview
        SUBMIT
        INTERVAL
        BROKEN
        ZONE
        WHAT
        USER_EXPORT
        REMOVE
        NEXT_DATE
        CHANGE
        DBMS_APPLICATION_INFO
        Overview
        READ_CLIENT_INFO
        READ_MODULE
        SET_ACTION
        SET_CLIENT_INFO
        SET_MODULE
        DBMS_CRYPTO
        ENCRYPT
        DECRYPT
        HASH
        Overview
        DBMS_PLAN_CACHE
        PURGE
        Overview
        DBMS_WORKLOAD_REPOSITORY
        Overview
        ASH_REPORT
      - PL triggers
        Query trigger information
        INSTEAD OF DML trigger
        Create a DML trigger
        Overview
        Disable or enable a trigger
        Modify and drop a trigger
        Compound DML trigger
      - PL label security package
        Overview
        SA_SESSION session management package
        SA_SESSION.ROW_LABEL
        SA_SESSION.RESTORE_DEFAULT_LABELS
        SA_SESSION.SET_LABEL
        SA_SESSION.SET_ROW_LABEL
        Overview
        SA_SESSION.LABEL
        SA_LABEL_ADMIN label management package
        SA_LABEL_ADMIN.ALTER_LABEL
        SA_LABEL_ADMIN.CREATE_LABEL
        SA_LABEL_ADMIN.DROP_LABEL
        Overview
        SA_POLICY_ADMIN policy management package
        Overview
        SA_POLICY_ADMIN.APPLY_TABLE_POLICY
        SA_POLICY_ADMIN.DISABLE_TABLE_POLICY
        SA_POLICY_ADMIN.REMOVE_TABLE_POLICY
        SA_POLICY_ADMIN.ENABLE_TABLE_POLICY
        SA_USER_ADMIN user label management package
        SA_USER_ADMIN.SET_LEVELS
        Overview
        SA_SYSDBA policy management package
        Overview
        SA_SYSDBA.ALTER_POLICY
        SA_SYSDBA.DROP_POLICY
        SA_SYSDBA.CREATE_POLICY
        SA_COMPONENTS label component package
        SA_COMPONENTS.CREATE_LEVEL
        SA_COMPONENTS.DROP_LEVEL
        SA_COMPONENTS.ALTER_LEVEL
        Overview
      - PL collections and records
        Create and call a subprogram with record type parameters
        Insert records into a table and update a table by using records
        Varrays
        Associative arrays
        Collections
        Overview
        Collection constructor function
        Records
        Nested tables
        Collection methods
        COUNT method
        EXISTS method
        EXTEND method
        FIRST and LAST methods
        Overview
        DELETE method
        TRIM method
        LIMIT method
        PRIOR and NEXT methods
      - PL data types
        SQL data types
        PLS_INTEGER and BINARY_INTEGER
        PL JSON data types
        LOB data types
        Arrays
        BOOLEAN type
        User-defined subtypes
        Overview
      - PL language basics
        Subprograms
        Scope and visibility of identifiers
        Lexical units
        Error-reporting functions
        Character sets
        Declare
        Expressions
        PL blocks
        Reference identifiers
        Assign values
      - PL exception handling
        Exception handling processes
        Exception types
        Overview
        Compile-Time alerts
      - PL process control
        Overview
        Sequential control
        Loop control
        Conditional control
      - PL dynamic SQL
        DBMS_SQL system package
        Execute dynamic SQL statements
        Overview
      - PL packages
        Create a program package
        Manage program packages
        Definition of the PL environment by the STANDARD package
        Overview
        Overloaded programs in a package
    - PL reference (MySQL mode)
      - Syntax of PL stored programs
      - Reserved and non-reserved PL keywords
      - PL system packages
        Overview
        DBMS_RESOURCE_MANAGER
        CREATE_PLAN
        DELETE_PLAN_DIRECTIVE
        DELETE_CONSUMER_GROUP
        SET_CONSUMER_GROUP_MAPPING
        CREATE_CONSUMER_GROUP
        DELETE_PLAN
        Overview
        CREATE_PLAN_DIRECTIVE
        UPDATE_PLAN_DIRECTIVE
        DBMS_STATS
        GET_PREFS
        GATHER_INDEX_STATS
        DROP_STAT_TABLE
        GET_STATS_HISTORY_AVAILABILITY
        CREATE_STAT_TABLE
        SET_TABLE_STATS
        GATHER_SCHEMA_STATS
        DELETE_SYSTEM_STATS
        DELETE_COLUMN_STATS
        UNLOCK_SCHEMA_STATS
        SET_PARAM
        IMPORT_SCHEMA_STATS
        RESET_PARAM_DEFAULTS
        GET_PARAM
        SET_TABLE_PREFS
        GET_STATS_HISTORY_RETENTION
        DELETE_TABLE_STATS
        DELETE_INDEX_STATS
        LOCK_PARTITION_STATS
        FLUSH_DATABASE_MONITORING_INFO
        EXPORT_INDEX_STATS
        UNLOCK_PARTITION_STATS
        UNLOCK_TABLE_STATS
        SET_GLOBAL_PREFS
        DELETE_TABLE_PREFS
        ALTER_STATS_HISTORY_RETENTION
        SET_COLUMN_STATS
        SET_INDEX_STATS
        SET_SYSTEM_STATS
        IMPORT_TABLE_STATS
        EXPORT_TABLE_STATS
        IMPORT_COLUMN_STATS
        DELETE_SCHEMA_PREFS
        IMPORT_INDEX_STATS
        LOCK_TABLE_STATS
        SET_SCHEMA_PREFS
        GATHER_SYSTEM_STATS
        RESET_GLOBAL_PREF_DEFAULTS
        EXPORT_COLUMN_STATS
        LOCK_SCHEMA_STATS
        RESTORE_SCHEMA_STATS
        EXPORT_SCHEMA_STATS
        PURGE_STATS
        GATHER_TABLE_STATS
        DELETE_SCHEMA_STATS
        Overview
        RESTORE_TABLE_STATS
        DBMS_XPLAN
        DISPLAY_ACTIVE_SESSION_PLAN
        DISABLE_OPT_TRACE
        DISPLAY
        DISPLAY_CURSOR
        ENABLE_OPT_TRACE
        SET_OPT_TRACE_PARAMETER
        Overview
        DISPLAY_SQL_PLAN_BASELINE
        DBMS_UDR
        CREATE_RULE
        DISABLE_RULE
        Overview
        ENABLE_RULE
        REMOVE_RULE
        DBMS_MVIEW_STAT
        Overview
        SET_SYSTEM_DEFAULT
        SET_MVREF_STATS_PARAMS
        PURGE_REFRESH_STATS
        DBMS_WORKLOAD_REPOSITORY
        DROP_SNAPSHOT_RANGE
        ASH_REPORT
        Overview
        CREATE_SNAPSHOT
        MODIFY_SNAPSHOT_SETTINGS
        DBMS_MVIEW
        PURGE_LOG
        REFRESH
        Overview
        DBMS_TRUSTED_CERTIFICATE_MANAGER
        DELETE_TRUSTED_CERTIFICATE
        Overview
        ADD_TRUSTED_CERTIFICATE
        UPDATE_TRUSTED_CERTIFICATE
      - PL conditional control statements
        REPEAT
        LEAVE
        IF
        RETURN
        WHILE
        LOOP
        CASE
        ITERATE
      - PL exception handling
        Exception handling and OUT/INOUT parameters
        DECLARE ... CONDITION
        Limitations on exception handling
        DECLARE ... HANDLER
        RESIGNAL
        Diagnostics area
        GET DIAGNOSTICS
        Overview
        Effective scope of an exception handler
        SIGNAL
      - PL stored procedures
        Variables in stored programs
        Limitations on stored programs
        Stored functions
        Overview
        Stored procedures
        Trigger
      - PL data definition statements
        DROP FUNCTION
        ALTER FUNCTION
        ALTER PROCEDURE
        DROP PROCEDURE
        CREATE TRIGGER
        CREATE FUNCTION
        DROP TRIGGER
        CREATE PROCEDURE
      - PL related dictionary views
        INFORMATION_SCHEMA ROUTINES
        INFORMATION_SCHEMA PARAMETERS
        INFORMATION_SCHEMA TRIGGERS
      - PL database management statements
        SHOW TRIGGERS
        SHOW CREATE TRIGGER
        SHOW FUNCTION STATUS
        SHOW CREATE FUNCTION
        SHOW PROCEDURE STATUS
        SHOW CREATE PROCEDURE
      - PL cursors
        Overview
        Cursor execution process
        Limitations on server cursors
      - PL data manipulation statements
        CALL
        DO
    - What is PL
      - PL architecture
      - Overview
      - Main features of PL
  - SQL specifications and practices
    - Limitations on writing SQL statements
    - SQL writing specifications
      - Transactions
      - Table scan
      - SELECT statements
      - Multi-table join specifications
      - Cache
      - Hint
      - DML statements
      - Others
    - SQL statement examples
      - Weak consistency read
      - Pagination queries
      - Join tables
      - Implicit data type conversion
- System views
  - Overview of system views
  - Changes in views in OceanBase Database V3.x and V4.x
  - Common statistical events
  - General wait events
  - Overview
  - SYS tenant views
    - Dictionary views
      - oceanbase.DBA_OB_BALANCE_TASKS
      - oceanbase.DBA_SUBPART_COL_STATISTICS
      - mysql.time_zone_name
      - oceanbase.DBA_RSRC_PLAN_DIRECTIVES
      - oceanbase.CDB_OB_RESTORE_HISTORY
      - oceanbase.DBA_OB_LS_LOCATIONS
      - oceanbase.DBA_SUBPART_KEY_COLUMNS
      - oceanbase.DBA_OB_TENANTS
      - oceanbase.DBA_OB_TABLEGROUP_TABLES
      - oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY
      - information_schema.PARTITIONS
      - DBA_MVREF_STMT_STATS
      - oceanbase.DBA_WR_SQLTEXT
      - oceanbase.CDB_OB_BACKUP_PARAMETER
      - oceanbase.DBA_OB_TENANT_EVENT_HISTORY
      - oceanbase.CDB_OB_BACKUP_DELETE_JOBS
      - oceanbase.CDB_OB_LS
      - oceanbase.DBA_RSRC_GROUP_MAPPINGS
      - oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO
      - oceanbase.DBA_OB_RESTORE_HISTORY
      - oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
      - DBA_OB_CLONE_PROGRESS
      - oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
      - oceanbase.CDB_OB_BALANCE_JOBS
      - oceanbase.DBA_OB_SERVER_JOBS
      - information_schema.GLOBAL_STATUS
      - oceanbase.DBA_OB_LS_REPLICA_TASKS
      - oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS
      - oceanbase.CDB_WR_CONTROL
      - oceanbase.DBA_OB_USER_DEFINED_RULES
      - oceanbase.CDB_OB_TABLE_LOCATIONS
      - oceanbase.CDB_WR_SQLTEXT
      - oceanbase.CDB_OB_KV_TTL_TASKS
      - oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
      - oceanbase.CDB_TAB_COLS_V$
      - DBA_MVREF_STATS_SYS_DEFAULTS
      - CDB_MVREF_STATS_PARAMS
      - oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
      - oceanbase.DBA_RSRC_CONSUMER_GROUPS
      - oceanbase.DBA_WR_STATNAME
      - oceanbase.DBA_SEQUENCES
      - oceanbase.DBA_OB_FREEZE_INFO
      - oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
      - oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY
      - oceanbase.DBA_WR_SNAPSHOT
      - oceanbase.DBA_OB_USERS
      - oceanbase.CDB_OB_RECOVER_TABLE_JOBS
      - oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES
      - oceanbase.DBA_OB_TABLE_STAT_STALE_INFO
      - DBA_INDEX_USAGE
      - oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY
      - oceanbase.DBA_OB_RESOURCE_POOLS
      - oceanbase.CDB_OB_LS_ARB_REPLICA_TASKS
      - oceanbase.DBA_OB_TABLEGROUP_PARTITIONS
      - oceanbase.CDB_TABLES
      - oceanbase.DBA_IND_PARTITIONS
      - oceanbase.CDB_OB_TABLET_REPLICAS
      - mysql.help_category
      - oceanbase.DBA_DB_LINKS
      - oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO
      - information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
      - oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
      - oceanbase.CDB_WR_SYS_TIME_MODEL
      - oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY
      - oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY
      - oceanbase.CDB_OB_BACKUP_JOBS
      - oceanbase.CDB_PART_KEY_COLUMNS
      - oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY
      - oceanbase.CDB_OB_TRANSFER_TASK_HISTORY
      - oceanbase.DBA_OB_EXTERNAL_TABLE_FILES
      - oceanbase.DBA_OB_BALANCE_TASK_HISTORY
      - oceanbase.CDB_OB_TABLET_TO_LS
      - mysql.time_zone_transition
      - DBA_OB_AUX_STATISTICS
      - CDB_OB_AUX_STATISTICS
      - information_schema.CHECK_CONSTRAINTS
      - oceanbase.CDB_OB_BACKUP_DELETE_POLICY
      - oceanbase.DBA_PART_TABLES
      - oceanbase.DBA_OB_AUTO_INCREMENT
      - oceanbase.DBA_OB_SERVERS
      - oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY
      - oceanbase.DBA_OB_DATABASE_PRIVILEGE
      - oceanbase.DBA_OB_TABLEGROUPS
      - oceanbase.DBA_OB_RESTORE_PROGRESS
      - oceanbase.DBA_PART_INDEXES
      - oceanbase.DBA_OB_KV_TTL_TASK_HISTORY
      - oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS
      - oceanbase.CDB_OB_DATABASES
      - CDB_MVIEWS
      - mysql.db
      - oceanbase.CDB_OB_ARCHIVE_DEST
      - oceanbase.CDB_OB_TABLEGROUP_TABLES
      - oceanbase.CDB_OB_IMPORT_TABLE_TASKS
      - oceanbase.DBA_PART_COL_STATISTICS
      - DBA_OB_CLONE_HISTORY
      - oceanbase.DBA_TAB_COL_STATISTICS
      - mysql.user
      - CDB_MVREF_STMT_STATS
      - oceanbase.DBA_WR_SYSTEM_EVENT
      - information_schema.SCHEMA_PRIVILEGES
      - CDB_MVREF_STATS_SYS_DEFAULTS
      - oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
      - oceanbase.DBA_WR_CONTROL
      - oceanbase.DBA_OB_LS
      - information_schema.TABLES
      - oceanbase.CDB_OB_USERS
      - information_schema.ENGINES
      - oceanbase.DBA_OB_BALANCE_JOB_HISTORY
      - oceanbase.DBA_OB_ACCESS_POINT
      - oceanbase.DBA_SCHEDULER_WINDOWS
      - oceanbase.CDB_OB_BALANCE_TASKS
      - oceanbase.CDB_OB_DATABASE_PRIVILEGE
      - oceanbase.CDB_OB_BALANCE_TASK_HISTORY
      - oceanbase.DBA_OBJECTS
      - information_schema.SESSION_VARIABLES
      - DBA_MVREF_CHANGE_STATS
      - information_schema.COLUMNS
      - oceanbase.CDB_OB_LS_ARB_REPLICA_TASK_HISTORY
      - oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
      - oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY
      - oceanbase.CDB_OB_LS_LOCATIONS
      - oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY
      - oceanbase.CDB_OB_TENANT_EVENT_HISTORY
      - oceanbase.DBA_SUBPARTITION_TEMPLATES
      - oceanbase.CDB_IND_PARTITIONS
      - information_schema.TABLE_PRIVILEGES
      - oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY
      - oceanbase.DBA_TAB_STATISTICS
      - mysql.help_topic
      - oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS
      - oceanbase.DBA_OB_TRANSFER_TASK_HISTORY
      - information_schema.CHARACTER_SETS
      - oceanbase.CDB_OB_BACKUP_TASK_HISTORY
      - oceanbase.DBA_TAB_STATS_HISTORY
      - oceanbase.DBA_OB_TRANSFER_TASKS
      - mysql.help_relation
      - mysql.help_keyword
      - oceanbase.CDB_OB_TABLEGROUP_PARTITIONS
      - oceanbase.DBA_IND_SUBPARTITIONS
      - oceanbase.CDB_OB_AUTO_INCREMENT
      - oceanbase.CDB_OB_BALANCE_JOB_HISTORY
      - oceanbase.CDB_OB_BACKUP_JOB_HISTORY
      - oceanbase.DBA_TAB_MODIFICATIONS
      - information_schema.USER_PRIVILEGES
      - oceanbase.CDB_OB_SYS_VARIABLES
      - oceanbase.DBA_OB_ZONES
      - oceanbase.DBA_OB_SEQUENCE_OBJECTS
      - oceanbase.DBA_OB_TABLET_TO_LS
      - oceanbase.CDB_OB_ARCHIVELOG_SUMMARY
      - DBA_MVREF_STATS_PARAMS
      - DBA_MVIEW_LOGS
      - oceanbase.CDB_SUBPART_KEY_COLUMNS
      - information_schema.ROUTINES
      - oceanbase.CDB_OB_TABLEGROUPS
      - oceanbase.DBA_SUBPART_HISTOGRAMS
      - information_schema.QUERY_RESPONSE_TIME
      - oceanbase.DBA_OB_UNITS
      - oceanbase.DBA_OB_RSRC_IO_DIRECTIVES
      - oceanbase.DBA_SQL_PLAN_BASELINES
      - oceanbase.DBA_TAB_HISTOGRAMS
      - oceanbase.DBA_WR_SQLSTAT
      - oceanbase.DBA_TAB_PARTITIONS
      - CDB_MVREF_STATS
      - oceanbase.DBA_OB_IMPORT_TABLE_TASKS
      - oceanbase.DBA_OB_RECOVER_TABLE_JOBS
      - oceanbase.DBA_OB_UNIT_JOBS
      - oceanbase.CDB_OB_ARCHIVELOG
      - oceanbase.CDB_OB_RESTORE_PROGRESS
      - oceanbase.DBA_OB_ARBITRATION_SERVICE
      - information_schema.SCHEMATA
      - oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS
      - oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION
      - oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG
      - oceanbase.CDB_OB_FREEZE_INFO
      - oceanbase.CDB_OB_BACKUP_STORAGE_INFO
      - oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
      - information_schema.VIEWS
      - CDB_MVREF_CHANGE_STATS
      - oceanbase.DBA_OB_BACKUP_DELETE_TASKS
      - oceanbase.CDB_WR_EVENT_NAME
      - oceanbase.CDB_OB_BACKUP_SET_FILES
      - oceanbase.CDB_OB_TRANSFER_TASKS
      - oceanbase.DBA_OB_BACKUP_TASKS
      - oceanbase.CDB_TAB_PARTITIONS
      - oceanbase.DBA_SQL_MANAGEMENT_CONFIG
      - oceanbase.DBA_OB_ARCHIVELOG
      - oceanbase.CDB_INDEXES
      - oceanbase.CDB_WR_SYSSTAT
      - information_schema.COLLATIONS
      - oceanbase.DBA_OB_BACKUP_STORAGE_INFO
      - oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY
      - oceanbase.DBA_WR_SYS_TIME_MODEL
      - oceanbase.DBA_OB_BACKUP_DELETE_JOBS
      - oceanbase.DBA_OB_BACKUP_DELETE_POLICY
      - information_schema.REFERENTIAL_CONSTRAINTS
      - mysql.time_zone_transition_type
      - oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY
      - oceanbase.CDB_PART_TABLES
      - information_schema.KEY_COLUMN_USAGE
      - CDB_MVREF_RUN_STATS
      - oceanbase.DBA_PART_KEY_COLUMNS
      - DBA_MVIEWS
      - mysql.time_zone
      - oceanbase.DBA_OB_TABLET_REPLICAS
      - information_schema.PARAMETERS
      - DBA_MVREF_STATS
      - oceanbase.CDB_TAB_COLS
      - oceanbase.CDB_IND_COLUMNS
      - oceanbase.DBA_OB_TABLE_LOCATIONS
      - oceanbase.CDB_OB_LOG_RESTORE_SOURCE
      - oceanbase.DBA_OB_TENANT_JOBS
      - oceanbase.DBA_OB_BACKUP_JOBS
      - oceanbase.DBA_OB_BACKUP_TASK_HISTORY
      - information_schema.COLUMN_PRIVILEGES
      - oceanbase.CDB_SUBPARTITION_TEMPLATES
      - oceanbase.DBA_OB_UNIT_CONFIGS
      - oceanbase.CDB_TAB_SUBPARTITIONS
      - oceanbase.CDB_IND_SUBPARTITIONS
      - oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY
      - oceanbase.DBA_OB_BALANCE_JOBS
      - CDB_MVIEW_LOGS
      - information_schema.SESSION_STATUS
      - oceanbase.DBA_OB_IMPORT_TABLE_JOBS
      - oceanbase.DBA_OB_OUTLINES
      - oceanbase.DBA_WR_SYSSTAT
      - CDB_INDEX_USAGE
      - oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS
      - oceanbase.DBA_OB_ARCHIVE_DEST
      - oceanbase.CDB_OB_KV_TTL_TASK_HISTORY
      - oceanbase.DBA_RSRC_PLANS
      - oceanbase.DBA_OB_MAJOR_COMPACTION
      - oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY
      - oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS
      - information_schema.STATISTICS
      - oceanbase.CDB_OBJECTS
      - oceanbase.CDB_OB_IMPORT_TABLE_JOBS
      - oceanbase.DBA_OB_BACKUP_SET_FILES
      - oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
      - oceanbase.DBA_IND_STATISTICS
      - oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG
      - oceanbase.CDB_WR_SYSTEM_EVENT
      - DBA_OB_TRUSTED_ROOT_CERTIFICATE
      - oceanbase.CDB_OB_LS_HISTORY
      - oceanbase.CDB_PART_INDEXES
      - oceanbase.CDB_OB_LS_REPLICA_TASKS
      - oceanbase.CDB_OB_ACCESS_POINT
      - oceanbase.DBA_WR_EVENT_NAME
      - information_schema.GLOBAL_VARIABLES
      - oceanbase.CDB_OB_BACKUP_DELETE_TASKS
      - oceanbase.DBA_OB_LS_ARB_REPLICA_TASK_HISTORY
      - information_schema.PROCESSLIST
      - oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
      - oceanbase.CDB_OB_EXTERNAL_TABLE_FILES
      - information_schema.TABLE_CONSTRAINTS
      - mysql.proc
      - oceanbase.DBA_OB_DATABASES
      - oceanbase.DBA_SCHEDULER_JOBS
      - oceanbase.DBA_OB_BACKUP_JOB_HISTORY
      - oceanbase.CDB_OB_BACKUP_TASKS
      - oceanbase.DBA_TAB_SUBPARTITIONS
      - oceanbase.CDB_TAB_COL_STATISTICS
      - oceanbase.CDB_WR_SNAPSHOT
      - oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
      - oceanbase.DBA_OB_BACKUP_PARAMETER
      - oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
      - oceanbase.DBA_OB_SERVER_EVENT_HISTORY
      - oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY
      - oceanbase.CDB_OB_MAJOR_COMPACTION
      - oceanbase.DBA_OB_LS_HISTORY
      - oceanbase.ALL_OB_EXTERNAL_TABLE_FILES
      - DBA_MVREF_RUN_STATS
      - information_schema.VIEW_TABLE_USAGE
      - oceanbase.CDB_WR_SQLSTAT
      - oceanbase.DBA_OB_LOG_RESTORE_SOURCE
      - oceanbase.DBA_OB_KV_TTL_TASKS
      - oceanbase.DBA_PART_HISTOGRAMS
      - information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
      - oceanbase.CDB_WR_STATNAME
    - Performance views
      - GV$OB_LOCKS
      - GV$OB_UNITS
      - GV$ACTIVE_SESSION_HISTORY
      - GV$OB_PARAMETERS
      - GV$OB_COMPACTION_SUGGESTIONS
      - GV$OB_MEMORY
      - GV$OB_IO_BENCHMARK
      - V$OB_ENCRYPTED_TABLES
      - V$OB_RPC_OUTGOING
      - GV$OB_RPC_INCOMING
      - GV$OB_SYS_TIME_MODEL
      - GV$OB_SQL_AUDIT
      - V$OB_TENANT_MEMORY
      - V$SYSSTAT
      - GV$OB_COMPACTION_PROGRESS
      - GV$OB_PLAN_CACHE_STAT
      - V$OB_SQL_WORKAREA_MEMORY_INFO
      - V$SESSION_WAIT_HISTORY
      - V$OB_PLAN_CACHE_PLAN_STAT
      - V$OB_IO_BENCHMARK
      - V$OB_TABLET_COMPACTION_HISTORY
      - GV$LATCH
      - V$OB_SSTABLES
      - V$OB_IO_CALIBRATION_STATUS
      - GV$OB_TRANSACTION_PARTICIPANTS
      - GV$OB_PX_WORKER_STAT
      - V$OB_ARBITRATION_SERVICE_STATUS
      - V$OB_LOCKS
      - V$OB_TENANT_RUNTIME_INFO
      - GV$OB_LS_SNAPSHOTS
      - V$SESSTAT
      - V$OB_ARBITRATION_MEMBER_INFO
      - V$OB_PLAN_CACHE_PLAN_EXPLAIN
      - GV$OB_MEMSTORE_INFO
      - V$OB_TRANSACTION_PARTICIPANTS
      - GV$OB_PX_P2P_DATAHUB
      - GV$OB_PLAN_CACHE_PLAN_STAT
      - V$STATNAME
      - V$OB_SQL_PLAN
      - V$OB_PX_TARGET_MONITOR
      - GV$OB_KVCACHE
      - V$OB_RPC_INCOMING
      - V$OB_DTL_INTERM_RESULT_MONITOR
      - GV$OB_ACTIVE_SESSION_HISTORY
      - GV$OB_PX_TARGET_MONITOR
      - GV$OB_IO_CALIBRATION_STATUS
      - GV$OB_OPT_STAT_GATHER_MONITOR
      - GV$SESSION_EVENT
      - V$OB_SERVERS
      - V$OB_MERGE_INFO
      - GV$OB_ARBITRATION_MEMBER_INFO
      - GV$OB_PS_ITEM_INFO
      - GV$SQL_WORKAREA
      - GV$OB_MEMSTORE
      - GV$OB_SQL_WORKAREA_MEMORY_INFO
      - GV$OB_TENANT_RUNTIME_INFO
      - V$OB_SESS_TIME_MODEL
      - V$OB_SQLSTAT
      - V$LATCH
      - V$OB_PS_STAT
      - V$OB_PX_P2P_DATAHUB
      - V$OB_SESSION
      - V$SQL_WORKAREA_HISTOGRAM
      - V$OB_COMPACTION_SUGGESTIONS
      - GV$OB_COMPACTION_DIAGNOSE_INFO
      - GV$SQL_PLAN_MONITOR
      - GV$SQL_WORKAREA_HISTOGRAM
      - GV$OB_DTL_INTERM_RESULT_MONITOR
      - V$OB_PLAN_CACHE_STAT
      - GV$OB_PLAN_CACHE_PLAN_EXPLAIN
      - V$SQL_WORKAREA_ACTIVE
      - V$SESSION_WAIT
      - GV$OB_LOG_STAT
      - V$OB_TABLET_COMPACTION_PROGRESS
      - V$OB_SERVER_SCHEMA_INFO
      - V$OB_OPT_STAT_GATHER_MONITOR
      - V$OB_SYS_TIME_MODEL
      - V$OB_PARAMETERS
      - V$OB_COMPACTION_DIAGNOSE_INFO
      - GV$OB_SQL_PLAN
      - V$RSRC_PLAN
      - V$OB_LOG_STAT
      - V$OB_ARCHIVE_DEST_STATUS
      - GV$SESSTAT
      - GV$OB_SQLSTAT
      - GV$OB_TABLET_COMPACTION_HISTORY
      - V$EVENT_NAME
      - GV$OB_SSTABLES
      - GV$DML_STATS
      - V$SESSION_EVENT
      - GV$OB_PROCESSLIST
      - V$DML_STATS
      - GV$OB_TABLET_COMPACTION_PROGRESS
      - V$OB_LS_LOG_RESTORE_STATUS
      - GV$OB_THREAD
      - V$OB_ACTIVE_SESSION_HISTORY
      - GV$OB_RPC_OUTGOING
      - GV$SQL_WORKAREA_ACTIVE
      - V$OB_LS_SNAPSHOTS
      - V$OB_PS_ITEM_INFO
      - GV$OB_TENANT_MEMORY
      - GV$SYSTEM_EVENT
      - V$OB_COMPACTION_PROGRESS
      - V$OB_THREAD
      - GV$OB_SESSION
      - GV$OB_SERVER_SCHEMA_INFO
      - V$OB_UNITS
      - V$OB_LS_REPLICA_TASK_PLAN
      - GV$OB_SERVERS
      - GV$OB_FLT_TRACE_CONFIG
      - V$OB_KVCACHE
      - GV$SESSION_WAIT
      - V$OB_MEMSTORE_INFO
      - V$OB_TIMESTAMP_SERVICE
      - GV$OB_SESS_TIME_MODEL
      - V$SESSION_LONGOPS
      - GV$SESSION_WAIT_HISTORY
      - GV$OB_PS_STAT
      - V$ENCRYPTED_TABLESPACES
      - V$SYSTEM_EVENT
      - V$SQL_JOIN_FILTER
      - V$ACTIVE_SESSION_HISTORY
      - V$OB_MEMSTORE
      - V$SQL_MONITOR_STATNAME
      - GV$OB_ARBITRATION_SERVICE_STATUS
      - V$OB_PROCESSLIST
      - GV$OB_MERGE_INFO
      - V$OB_PX_WORKER_STAT
      - V$OB_MEMORY
      - GV$SYSSTAT
      - GV$SQL_JOIN_FILTER
      - GV$SESSION_LONGOPS
      - V$SQL_PLAN_MONITOR
      - V$OB_SQL_AUDIT
      - V$SQL_WORKAREA
  - MySQL tenant views
    - Dictionary views
      - oceanbase.DBA_TAB_STATS_HISTORY
      - DBA_INDEX_USAGE
      - oceanbase.DBA_OB_LS_HISTORY
      - DBA_MVREF_STMT_STATS
      - mysql.time_zone_name
      - information_schema.GLOBAL_STATUS
      - information_schema.PARAMETERS
      - oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
      - oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
      - oceanbase.DBA_IND_SUBPARTITIONS
      - DBA_MVIEW_LOGS
      - mysql.user
      - oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS
      - information_schema.VIEWS
      - oceanbase.DBA_OB_BACKUP_DELETE_TASKS
      - oceanbase.DBA_OB_BALANCE_JOB_HISTORY
      - information_schema.COLUMN_PRIVILEGES
      - oceanbase.DBA_OB_BACKUP_JOB_HISTORY
      - oceanbase.DBA_OB_TENANTS
      - oceanbase.DBA_DB_LINKS
      - oceanbase.DBA_OB_TRANSFER_TASKS
      - oceanbase.DBA_OB_LS_ARB_REPLICA_TASK_HISTORY
      - oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
      - oceanbase.DBA_OB_LS
      - mysql.proc
      - oceanbase.DBA_OB_TABLEGROUPS
      - oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
      - mysql.db
      - oceanbase.DBA_RSRC_CONSUMER_GROUPS
      - oceanbase.DBA_OB_LOG_RESTORE_SOURCE
      - information_schema.PARTITIONS
      - oceanbase.DBA_OB_BACKUP_SET_FILES
      - oceanbase.DBA_WR_CONTROL
      - oceanbase.DBA_IND_PARTITIONS
      - oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
      - oceanbase.DBA_PART_HISTOGRAMS
      - oceanbase.DBA_OB_LS_REPLICA_TASKS
      - oceanbase.DBA_OB_BALANCE_TASK_HISTORY
      - oceanbase.DBA_OB_EXTERNAL_TABLE_FILES
      - oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS
      - information_schema.CHARACTER_SETS
      - DBA_MVREF_STATS_SYS_DEFAULTS
      - mysql.time_zone
      - information_schema.VIEW_TABLE_USAGE
      - oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY
      - oceanbase.DBA_WR_SYS_TIME_MODEL
      - oceanbase.DBA_OB_DATABASES
      - oceanbase.DBA_RSRC_PLAN_DIRECTIVES
      - information_schema.QUERY_RESPONSE_TIME
      - information_schema.ST_GEOMETRY_COLUMNS
      - oceanbase.DBA_OB_FREEZE_INFO
      - oceanbase.DBA_OB_BACKUP_JOBS
      - oceanbase.DBA_SCHEDULER_JOBS
      - information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
      - oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
      - oceanbase.DBA_OB_BACKUP_PARAMETER
      - oceanbase.DBA_OB_OUTLINES
      - oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG
      - DBA_MVREF_STATS
      - oceanbase.DBA_OB_KV_TTL_TASKS
      - mysql.time_zone_transition_type
      - information_schema.TABLE_CONSTRAINTS
      - oceanbase.DBA_OB_MAJOR_COMPACTION
      - oceanbase.DBA_SUBPART_HISTOGRAMS
      - oceanbase.DBA_TAB_PARTITIONS
      - oceanbase.DBA_OB_USER_DEFINED_RULES
      - information_schema.PROCESSLIST
      - information_schema.CHECK_CONSTRAINTS
      - oceanbase.DBA_OB_RECOVER_TABLE_JOBS
      - oceanbase.DBA_WR_EVENT_NAME
      - DBA_MVIEWS
      - oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
      - oceanbase.DBA_SQL_MANAGEMENT_CONFIG
      - oceanbase.DBA_PART_COL_STATISTICS
      - oceanbase.DBA_SQL_PLAN_BASELINES
      - oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY
      - oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
      - information_schema.ST_SPATIAL_REFERENCE_SYSTEMS
      - oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY
      - oceanbase.DBA_SUBPART_COL_STATISTICS
      - oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
      - information_schema.STATISTICS
      - oceanbase.DBA_WR_STATNAME
      - oceanbase.DBA_WR_SNAPSHOT
      - DBA_MVREF_CHANGE_STATS
      - information_schema.ROUTINES
      - information_schema.GLOBAL_VARIABLES
      - oceanbase.DBA_OB_AUTO_INCREMENT
      - information_schema.TABLES
      - oceanbase.DBA_OB_BACKUP_TASK_HISTORY
      - information_schema.REFERENTIAL_CONSTRAINTS
      - oceanbase.DBA_OB_USERS
      - information_schema.COLUMNS
      - oceanbase.DBA_OB_BALANCE_TASKS
      - oceanbase.DBA_IND_STATISTICS
      - oceanbase.DBA_TAB_MODIFICATIONS
      - oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
      - oceanbase.DBA_OB_ARCHIVE_DEST
      - oceanbase.DBA_OB_ARCHIVELOG
      - oceanbase.DBA_OB_BALANCE_JOBS
      - oceanbase.DBA_OB_TABLET_REPLICAS
      - oceanbase.DBA_OBJECTS
      - oceanbase.DBA_TAB_SUBPARTITIONS
      - oceanbase.DBA_SCHEDULER_WINDOWS
      - DBA_MVREF_STATS_PARAMS
      - oceanbase.DBA_OB_IMPORT_TABLE_TASKS
      - information_schema.COLLATIONS
      - oceanbase.DBA_SUBPART_KEY_COLUMNS
      - information_schema.ENGINES
      - oceanbase.DBA_OB_TENANT_EVENT_HISTORY
      - oceanbase.DBA_WR_SQLSTAT
      - oceanbase.DBA_OB_KV_TTL_TASK_HISTORY
      - DBA_OB_AUX_STATISTICS
      - oceanbase.DBA_SUBPARTITION_TEMPLATES
      - information_schema.KEY_COLUMN_USAGE
      - oceanbase.DBA_PART_KEY_COLUMNS
      - oceanbase.DBA_WR_SYSSTAT
      - information_schema.TABLE_PRIVILEGES
      - information_schema.USER_PRIVILEGES
      - oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
      - oceanbase.DBA_OB_TABLE_STAT_STALE_INFO
      - oceanbase.DBA_OB_TABLEGROUP_TABLES
      - oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY
      - oceanbase.DBA_SEQUENCES
      - oceanbase.DBA_OB_RESTORE_PROGRESS
      - oceanbase.DBA_OB_RESTORE_HISTORY
      - DBA_MVREF_RUN_STATS
      - oceanbase.DBA_RSRC_GROUP_MAPPINGS
      - information_schema.SESSION_VARIABLES
      - information_schema.SCHEMA_PRIVILEGES
      - mysql.help_category
      - oceanbase.DBA_TAB_HISTOGRAMS
      - oceanbase.DBA_RSRC_PLANS
      - information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
      - oceanbase.DBA_PART_TABLES
      - oceanbase.DBA_OB_DATABASE_PRIVILEGE
      - oceanbase.DBA_OB_BACKUP_DELETE_JOBS
      - mysql.help_keyword
      - oceanbase.DBA_OB_TABLEGROUP_PARTITIONS
      - mysql.time_zone_transition
      - oceanbase.DBA_OB_TRANSFER_TASK_HISTORY
      - oceanbase.DBA_OB_LS_ARB_REPLICA_TASKS
      - mysql.help_topic
      - oceanbase.DBA_PART_INDEXES
      - information_schema.SESSION_STATUS
      - oceanbase.DBA_WR_SYSTEM_EVENT
      - oceanbase.DBA_TAB_STATISTICS
      - oceanbase.DBA_OB_LS_LOCATIONS
      - oceanbase.DBA_WR_SQLTEXT
      - oceanbase.DBA_OB_TABLET_TO_LS
      - oceanbase.DBA_OB_BACKUP_TASKS
      - oceanbase.DBA_TAB_COL_STATISTICS
      - information_schema.SCHEMATA
      - oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
      - oceanbase.ALL_OB_EXTERNAL_TABLE_FILES
      - oceanbase.DBA_OB_RSRC_IO_DIRECTIVES
      - oceanbase.DBA_OB_SEQUENCE_OBJECTS
      - mysql.help_relation
      - oceanbase.DBA_OB_IMPORT_TABLE_JOBS
      - oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
      - oceanbase.DBA_OB_BACKUP_STORAGE_INFO
      - oceanbase.DBA_OB_BACKUP_DELETE_POLICY
      - oceanbase.DBA_OB_ACCESS_POINT
      - oceanbase.DBA_OB_TABLE_LOCATIONS
    - Performance views
      - V$SESSION_WAIT_HISTORY
      - GV$ACTIVE_SESSION_HISTORY
      - V$SESSION_EVENT
      - V$OB_MEMORY
      - V$OB_COMPACTION_PROGRESS
      - GV$OB_PX_WORKER_STAT
      - GV$OB_PLAN_CACHE_PLAN_STAT
      - V$OB_DTL_INTERM_RESULT_MONITOR
      - GV$SESSTAT
      - GV$OB_SESSION
      - V$OB_SQL_PLAN
      - GV$SQL_WORKAREA_ACTIVE
      - GV$OB_RPC_OUTGOING
      - V$SQL_JOIN_FILTER
      - GV$OB_PS_ITEM_INFO
      - V$OB_LOCKS
      - V$OB_PX_P2P_DATAHUB
      - V$OB_ARCHIVE_DEST_STATUS
      - V$OB_MERGE_INFO
      - V$OB_KVCACHE
      - V$OB_ENCRYPTED_TABLES
      - GV$SYSTEM_EVENT
      - GV$OB_COMPACTION_SUGGESTIONS
      - V$SESSION_LONGOPS
      - GV$SESSION_WAIT_HISTORY
      - GV$OB_LS_SNAPSHOTS
      - V$SQL_WORKAREA_HISTOGRAM
      - V$OB_TRANSACTION_PARTICIPANTS
      - V$SQL_WORKAREA_ACTIVE
      - GV$LATCH
      - V$RSRC_PLAN
      - V$SQL_MONITOR_STATNAME
      - V$OB_SESS_TIME_MODEL
      - GV$OB_PROCESSLIST
      - GV$OB_SQL_AUDIT
      - GV$OB_COMPACTION_PROGRESS
      - V$OB_PX_WORKER_STAT
      - GV$SQL_JOIN_FILTER
      - GV$OB_PLAN_CACHE_PLAN_EXPLAIN
      - V$OB_SQL_AUDIT
      - GV$OB_SERVER_SCHEMA_INFO
      - GV$SESSION_EVENT
      - GV$OB_SERVERS
      - GV$OB_PARAMETERS
      - V$OB_THREAD
      - V$OB_LS_REPLICA_TASK_PLAN
      - V$OB_PROCESSLIST
      - V$OB_PX_TARGET_MONITOR
      - GV$OB_FLT_TRACE_CONFIG
      - GV$OB_PX_TARGET_MONITOR
      - V$STATNAME
      - GV$OB_SQL_WORKAREA_MEMORY_INFO
      - GV$OB_MEMSTORE
      - V$SQL_PLAN_MONITOR
      - GV$SYSSTAT
      - GV$OB_PS_STAT
      - V$OB_SQL_WORKAREA_MEMORY_INFO
      - V$OB_MEMSTORE
      - GV$SESSION_WAIT
      - GV$OB_SESS_TIME_MODEL
      - V$OB_UNITS
      - V$OB_SYS_TIME_MODEL
      - V$OB_PLAN_CACHE_PLAN_EXPLAIN
      - V$OB_MEMSTORE_INFO
      - V$OB_ARBITRATION_SERVICE_STATUS
      - V$OB_TABLET_COMPACTION_PROGRESS
      - V$OB_SESSION
      - V$ENCRYPTED_TABLESPACES
      - V$OB_LOG_STAT
      - V$LATCH
      - V$OB_RPC_INCOMING
      - GV$OB_SQL_PLAN
      - V$OB_PARAMETERS
      - V$OB_RPC_OUTGOING
      - V$EVENT_NAME
      - GV$OB_ARBITRATION_SERVICE_STATUS
      - V$OB_COMPACTION_DIAGNOSE_INFO
      - V$SESSTAT
      - V$SQL_WORKAREA
      - V$OB_OPT_STAT_GATHER_MONITOR
      - GV$SQL_WORKAREA
      - GV$OB_LOG_STAT
      - GV$SQL_PLAN_MONITOR
      - GV$OB_SYS_TIME_MODEL
      - GV$SESSION_LONGOPS
      - V$OB_SERVERS
      - GV$OB_THREAD
      - GV$OB_COMPACTION_DIAGNOSE_INFO
      - GV$OB_MEMORY
      - V$OB_SERVER_SCHEMA_INFO
      - V$OB_TIMESTAMP_SERVICE
      - V$OB_TENANT_MEMORY
      - V$SESSION_WAIT
      - GV$OB_TABLET_COMPACTION_HISTORY
      - GV$SQL_WORKAREA_HISTOGRAM
      - V$DML_STATS
      - V$OB_ACTIVE_SESSION_HISTORY
      - V$OB_SQLSTAT
      - V$SYSTEM_EVENT
      - GV$OB_UNITS
      - GV$OB_SSTABLES
      - V$OB_PLAN_CACHE_PLAN_STAT
      - GV$OB_TENANT_MEMORY
      - GV$OB_TABLET_COMPACTION_PROGRESS
      - GV$OB_TRANSACTION_PARTICIPANTS
      - GV$OB_KVCACHE
      - V$OB_LS_SNAPSHOTS
      - V$SYSSTAT
      - V$OB_PLAN_CACHE_STAT
      - V$OB_TABLET_COMPACTION_HISTORY
      - V$OB_SSTABLES
      - V$OB_PS_STAT
      - GV$OB_ARBITRATION_MEMBER_INFO
      - GV$OB_PX_P2P_DATAHUB
      - GV$OB_PLAN_CACHE_STAT
      - GV$DML_STATS
      - GV$OB_SQLSTAT
      - GV$OB_MEMSTORE_INFO
      - GV$OB_OPT_STAT_GATHER_MONITOR
      - V$OB_ARBITRATION_MEMBER_INFO
      - V$OB_LS_LOG_RESTORE_STATUS
      - GV$OB_ACTIVE_SESSION_HISTORY
      - V$ACTIVE_SESSION_HISTORY
      - GV$OB_RPC_INCOMING
      - V$OB_PS_ITEM_INFO
      - GV$OB_LOCKS
      - GV$OB_MERGE_INFO
      - V$OB_COMPACTION_SUGGESTIONS
      - GV$OB_DTL_INTERM_RESULT_MONITOR
  - Oracle tenant views
    - Dictionary views
      - USER_COL_PRIVS
      - DBA_INDEXES
      - ALL_PART_INDEXES
      - USER_IND_PARTITIONS
      - DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
      - DBA_OB_TRANSFER_TASK_HISTORY
      - DBA_OB_BACKUP_DELETE_TASKS
      - DBA_OB_FREEZE_INFO
      - USER_TRIGGERS
      - ALL_SCHEDULER_JOB_ARGS
      - DBA_SYS_PRIVS
      - DBA_OB_TENANT_EVENT_HISTORY
      - ALL_DB_LINKS
      - USER_DB_LINKS
      - DBA_RSRC_PLANS
      - DBA_RSRC_CONSUMER_GROUPS
      - DBA_SCHEDULER_WINDOWS
      - DBA_CONTEXT
      - ALL_POLICY_CONTEXTS
      - DBA_OB_IMPORT_TABLE_TASKS
      - DBA_OB_RECOVER_TABLE_JOBS
      - USER_TAB_COMMENTS
      - USER_OBJECTS
      - DBA_METHOD_PARAMS
      - DBA_OB_TABLET_REPLICAS
      - DBA_OBJ_AUDIT_OPTS
      - ALL_PART_TABLES
      - DBA_MVREF_STATS
      - USER_PROCEDURES
      - ALL_TYPE_METHODS
      - ALL_CONS_COLUMNS
      - NLS_SESSION_PARAMETERS
      - ALL_SUBPART_COL_STATISTICS
      - ALL_METHOD_PARAMS
      - DBA_TABLESPACES
      - DBA_PART_TABLES
      - USER_SEC_RELEVANT_COLS
      - USER_TABLES
      - ROLE_SYS_PRIVS
      - ALL_TRIGGER_ORDERING
      - USER_RECYCLEBIN
      - USER_AUDIT_TRAIL
      - ALL_SUBPART_HISTOGRAMS
      - USER_POLICY_CONTEXTS
      - USER_ERRORS
      - DBA_RSRC_PLAN_DIRECTIVES
      - DBA_TYPE_METHODS
      - DBA_OB_DATA_DICTIONARY_IN_LOG
      - USER_TAB_MODIFICATIONS
      - DBA_OB_TABLE_LOCATIONS
      - USER_MVIEWS
      - DBA_OB_CONCURRENT_LIMIT_SQL
      - DBA_USERS
      - ALL_CONSTRAINTS
      - USER_POLICY_GROUPS
      - DBA_IND_STATISTICS
      - USER_MVIEW_LOGS
      - DBA_OB_EXTERNAL_TABLE_FILES
      - DBA_SCHEDULER_PROGRAM
      - DBA_PART_INDEXES
      - DBA_TYPES
      - DBA_SQL_MANAGEMENT_CONFIG
      - DBA_OB_BACKUP_DELETE_TASK_HISTORY
      - DBA_OB_LOG_RESTORE_SOURCE
      - DBA_SUBPARTITION_TEMPLATES
      - DBA_TYPE_ATTRS
      - USER_TAB_STATS_HISTORY
      - USER_COL_COMMENTS
      - USER_TAB_PARTITIONS
      - DBA_MVREF_CHANGE_STATS
      - ALL_PART_COL_STATISTICS
      - USER_TYPE_METHODS
      - DBA_OB_LS_REPLICA_TASKS
      - DBA_DB_LINKS
      - DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
      - DBA_OB_MAJOR_COMPACTION
      - USER_DEPENDENCIES
      - STMT_AUDIT_OPTION_MAP
      - ALL_TAB_COLS
      - DBA_OB_BALANCE_TASKS
      - DBA_IND_SUBPARTITIONS
      - ALL_ALL_TABLES
      - DBA_POLICIES
      - USER_SCHEDULER_JOB_ARGS
      - DBA_OB_ACCESS_POINT
      - DBA_AUDIT_STATEMENT
      - DBA_IND_EXPRESSIONS
      - DBA_AUDIT_SESSION
      - DBA_IND_PARTITIONS
      - DBA_OB_BACKUP_DELETE_JOBS
      - ALL_TAB_HISTOGRAMS
      - DBA_PART_KEY_COLUMNS
      - DBA_OB_ARCHIVELOG_PIECE_FILES
      - USER_AUDIT_OBJECT
      - DBA_OB_IMPORT_TABLE_TASK_HISTORY
      - ALL_POLICY_GROUPS
      - USER_SYNONYMS
      - ALL_OB_EXTERNAL_TABLE_FILES
      - DBA_WR_SYSSTAT
      - DBA_AUDIT_TRAIL
      - DBA_OB_ARCHIVE_DEST
      - ALL_POLICIES
      - DBA_OB_BACKUP_DELETE_JOB_HISTORY
      - ALL_TRIGGERS
      - DBA_SUBPART_KEY_COLUMNS
      - ALL_PROCEDURES
      - DBA_OB_OUTLINES
      - DBA_SUBPART_COL_STATISTICS
      - DBA_MVREF_STMT_STATS
      - DBA_TRIGGERS
      - DBA_SQL_PLAN_BASELINES
      - DBA_OB_OUTLINE_CONCURRENT_HISTORY
      - DBA_SCHEDULER_PROGRAM_ARGS
      - DBA_ROLES
      - USER_SEQUENCES
      - ALL_IND_COLUMNS
      - DICT
      - USER_SYS_PRIVS
      - USER_INDEXES
      - DBA_OB_TABLEGROUP_TABLES
      - ALL_TYPES
      - DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
      - DBA_OB_LS_LOG_ARCHIVE_PROGRESS
      - USER_PART_HISTOGRAMS
      - USER_ROLE_PRIVS
      - DBA_AUDIT_EXISTS
      - DBA_TAB_COLUMNS
      - TENANT_VIRTUAL_SESSION_VARIABLE
      - DBA_OB_LS_ARB_REPLICA_TASK_HISTORY
      - USER_PART_COL_STATISTICS
      - DBA_MVREF_STATS_PARAMS
      - DBA_STMT_AUDIT_OPTS
      - ALL_TYPE_ATTRS
      - DBA_OB_DEADLOCK_EVENT_HISTORY
      - DBA_OB_RSRC_IO_DIRECTIVES
      - DBA_DEPENDENCIES
      - DBA_CONS_COLUMNS
      - USER_SUBPART_KEY_COLUMNS
      - DBA_TAB_MODIFICATIONS
      - DBA_POLICY_CONTEXTS
      - DBA_OB_BACKUP_TASK_HISTORY
      - DBA_OB_BACKUP_STORAGE_INFO_HISTORY
      - USER_SUBPART_COL_STATISTICS
      - USER_AUDIT_STATEMENT
      - USER_MVREF_STATS_PARAMS
      - DBA_RSRC_GROUP_MAPPINGS
      - DBA_VIEWS
      - ALL_OBJECTS
      - ALL_PART_HISTOGRAMS
      - ROLE_TAB_PRIVS
      - DBA_SEQUENCES
      - USER_TAB_COL_STATISTICS
      - USER_SOURCE
      - ALL_PART_KEY_COLUMNS
      - DBA_OB_BACKUP_TASKS
      - USER_TRIGGER_ORDERING
      - ALL_IND_SUBPARTITIONS
      - DBA_TAB_COL_STATISTICS
      - DBA_SUBPART_HISTOGRAMS
      - DBA_WR_ACTIVE_SESSION_HISTORY
      - DBA_OB_USER_DEFINED_RULES
      - DBA_TAB_PRIVS
      - USER_TYPES
      - USER_TAB_SUBPARTITIONS
      - ALL_MVIEWS
      - ALL_IND_PARTITIONS
      - ALL_TAB_PRIVS
      - ALL_TAB_COL_STATISTICS
      - ALL_MVIEW_LOGS
      - DBA_CONSTRAINTS
      - DBA_WR_SYS_TIME_MODEL
      - DBA_COLL_TYPES
      - DBA_TAB_STATS_HISTORY
      - ALL_SOURCE
      - USER_TYPE_ATTRS
      - ALL_TAB_SUBPARTITIONS
      - DBA_MVIEW_LOGS
      - DBA_OB_ARCHIVELOG_SUMMARY
      - USER_SUBPART_HISTOGRAMS
      - ALL_SCHEDULER_PROGRAM_ARGS
      - DBA_JOBS_RUNNING
      - USER_MVREF_STATS_SYS_DEFAULTS
      - USER_IND_COLUMNS
      - DBA_SYNONYMS
      - DBA_TAB_STATISTICS
      - ALL_TAB_MODIFICATIONS
      - DBA_TAB_COMMENTS
      - ALL_TAB_COMMENTS
      - DBA_TAB_SUBPARTITIONS
      - ROLE_ROLE_PRIVS
      - USER_TAB_COLUMNS
      - DBA_WR_SNAPSHOT
      - USER_TAB_STATISTICS
      - DBA_OB_BALANCE_JOBS
      - ALL_TAB_STATS_HISTORY
      - DBA_OB_TABLEGROUP_SUBPARTITIONS
      - USER_JOBS
      - DBA_OB_DATABASES
      - DBA_TAB_HISTOGRAMS
      - DBA_OB_TABLEGROUPS
      - USER_MVREF_STMT_STATS
      - DBA_OB_TABLET_TO_LS
      - DBA_RECYCLEBIN
      - ALL_INDEXES
      - USER_TAB_COLS
      - USER_TAB_HISTOGRAMS
      - DBA_PROCEDURES
      - USER_PART_KEY_COLUMNS
      - DBA_OBJECTS
      - DBA_WR_STATNAME
      - DBA_OB_BACKUP_STORAGE_INFO
      - DBA_PROFILES
      - DBA_OB_BALANCE_TASK_HISTORY
      - DBA_ALL_TABLES
      - ALL_DIRECTORIES
      - DBA_IND_COLUMNS
      - DBA_ARGUMENTS
      - DBA_OB_RESTORE_HISTORY
      - USER_USERS
      - ALL_SUBPARTITION_TEMPLATES
      - DICTIONARY
      - DBA_PART_COL_STATISTICS
      - DBA_OB_LS_HISTORY
      - ALL_TAB_COLUMNS
      - ALL_COL_PRIVS
      - DBA_ROLE_PRIVS
      - DBA_MVREF_RUN_STATS
      - DBA_OB_ZONE_MAJOR_COMPACTION
      - USER_SEGMENTS
      - USER_POLICIES
      - USER_CONSTRAINTS
      - DBA_OB_BALANCE_JOB_HISTORY
      - DBA_OB_BACKUP_DELETE_POLICY
      - DBA_OB_RECOVER_TABLE_JOB_HISTORY
      - DBA_MVIEWS
      - ALL_DEPENDENCIES
      - USER_PROFILES
      - DBA_OB_IMPORT_TABLE_JOBS
      - DBA_SEC_RELEVANT_COLS
      - DBMS_LOCK_ALLOCATED
      - USER_MVREF_RUN_STATS
      - DBA_INDEX_USAGE
      - DBA_TAB_COLS
      - ALL_COLL_TYPES
      - DBA_AUDIT_OBJECT
      - ALL_USERS
      - USER_AUDIT_SESSION
      - DBA_OB_AUX_STATISTICS
      - DBA_WR_SQLTEXT
      - ALL_PROFILES
      - ALL_SEC_RELEVANT_COLS
      - DBA_OB_IMPORT_TABLE_JOB_HISTORY
      - USER_IND_EXPRESSIONS
      - ALL_TAB_PARTITIONS
      - DBA_OB_LS_LOCATIONS
      - DBA_ERRORS
      - USER_PART_TABLES
      - DBA_OB_LS
      - USER_IND_SUBPARTITIONS
      - DBA_TAB_PARTITIONS
      - DBA_WR_SYSTEM_EVENT
      - DBA_WR_CONTROL
      - DBA_OB_TRANSFER_TASKS
      - DBA_OB_TRANSFER_PARTITION_TASKS
      - DBA_WR_EVENT_NAME
      - USER_TABLESPACES
      - USER_ALL_TABLES
      - AUDIT_ACTIONS
      - DBA_SEGMENTS
      - USER_TAB_PRIVS
      - ALL_SCHEDULER_WINDOWS
      - ALL_IND_EXPRESSIONS
      - DBA_OB_TABLEGROUP_PARTITIONS
      - ALL_SEQUENCES
      - DBA_PART_HISTOGRAMS
      - NLS_DATABASE_PARAMETERS
      - DBA_OB_ARCHIVELOG
      - USER_VIEWS
      - USER_IND_STATISTICS
      - ALL_TAB_STATISTICS
      - USER_ARGUMENTS
      - DBA_COL_COMMENTS
      - ALL_SYNONYMS
      - DBA_SOURCE
      - DBA_OB_BACKUP_JOBS
      - USER_MVREF_CHANGE_STATS
      - DBA_OB_TABLE_STAT_STALE_INFO
      - USER_CONS_COLUMNS
      - DBA_OB_LS_ARB_REPLICA_TASKS
      - DBA_OB_BACKUP_PARAMETER
      - DBA_TABLES
      - ALL_DEF_AUDIT_OPTS
      - DBA_SCHEDULER_JOB_RUN_DETAILS
      - TENANT_VIRTUAL_GLOBAL_VARIABLE
      - DBA_MVREF_STATS_SYS_DEFAULTS
      - ALL_ERRORS
      - DBA_OB_TENANTS
      - DBA_OB_DATABASE_PRIVILEGE
      - DBA_SCHEDULER_JOB_ARGS
      - DBA_WR_SQLSTAT
      - ALL_VIEWS
      - DBA_TRIGGER_ORDERING
      - USER_COLL_TYPES
      - ALL_SUBPART_KEY_COLUMNS
      - NLS_INSTANCE_PARAMETERS
      - ALL_IND_STATISTICS
      - ALL_TABLES
      - DBA_OB_BACKUP_JOB_HISTORY
      - DBA_SCHEDULER_JOBS
      - USER_SCHEDULER_PROGRAM_ARGS
      - DBA_JOBS
      - ALL_ARGUMENTS
      - DBA_OB_RESTORE_PROGRESS
      - USER_MVREF_STATS
      - ALL_COL_COMMENTS
      - USER_PART_INDEXES
      - DBA_DIRECTORIES
      - DBA_OB_BACKUP_SET_FILES
      - DBA_POLICY_GROUPS
      - USER_SUBPARTITION_TEMPLATES
      - DBA_COL_PRIVS
    - Performance views
      - GV$SESSION_WAIT_HISTORY
      - V$DBLINK
      - GV$OB_SYS_TIME_MODEL
      - GV$OB_PX_P2P_DATAHUB
      - GV$SQL_JOIN_FILTER
      - GV$OB_UNITS
      - V$OB_LS_REPLICA_TASK_PLAN
      - GV$OB_SESSION
      - GV$OB_MEMORY
      - V$ENCRYPTED_TABLESPACES
      - V$OPEN_CURSOR
      - GV$OB_THREAD
      - GV$SYSSTAT
      - GV$OB_SSTABLES
      - GV$OB_ACTIVE_SESSION_HISTORY
      - V$OB_PARAMETERS
      - V$SYSTEM_EVENT
      - V$OB_TENANT_MEMORY
      - GV$SESSION_WAIT
      - V$OB_TABLET_COMPACTION_PROGRESS
      - GV$OB_TENANT_MEMORY
      - GV$OB_SESS_TIME_MODEL
      - V$OB_SQL_AUDIT
      - GV$OB_LOCKS
      - GV$OB_TABLET_COMPACTION_PROGRESS
      - V$SQL_PLAN_MONITOR
      - V$OB_ACTIVE_SESSION_HISTORY
      - GV$OB_FLT_TRACE_CONFIG
      - GV$OPEN_CURSOR
      - V$OB_MEMSTORE_INFO
      - GV$OB_LS_SNAPSHOTS
      - GV$OB_SERVER_SCHEMA_INFO
      - GV$OB_COMPACTION_PROGRESS
      - V$OB_PLAN_CACHE_PLAN_STAT
      - V$OB_PX_WORKER_STAT
      - V$OB_LOCKS
      - GV$DBLINK
      - V$SYSSTAT
      - V$OB_COMPACTION_DIAGNOSE_INFO
      - V$OB_MEMORY
      - GV$OB_KVCACHE
      - GV$OB_MEMSTORE_INFO
      - V$OB_TRANSACTION_PARTICIPANTS
      - V$OB_SERVER_SCHEMA_INFO
      - GV$SESSTAT
      - GV$OB_GLOBAL_TRANSACTION
      - V$OB_PX_TARGET_MONITOR
      - GV$DML_STATS
      - GV$SQL_WORKAREA_HISTOGRAM
      - GV$SQL_PLAN_MONITOR
      - V$OB_SESSION
      - V$OB_PROCESSLIST
      - V$OB_COMPACTION_PROGRESS
      - V$SESSION_WAIT_HISTORY
      - V$OB_SYS_TIME_MODEL
      - GV$OB_SQL_PLAN
      - V$OB_SSTABLES
      - GV$OB_COMPACTION_DIAGNOSE_INFO
      - GV$ACTIVE_SESSION_HISTORY
      - V$SQL_WORKAREA_HISTOGRAM
      - GV$OB_PARAMETERS
      - GV$GLOBAL_TRANSACTION
      - V$VERSION
      - V$OB_LOG_STAT
      - V$OB_SQLSTAT
      - GV$SQL_WORKAREA
      - GV$OB_PROCESSLIST
      - GV$OB_PX_WORKER_STAT
      - GV$OB_TABLET_COMPACTION_HISTORY
      - V$OB_PS_ITEM_INFO
      - V$OB_TABLET_COMPACTION_HISTORY
      - GV$OB_PLAN_CACHE_PLAN_STAT
      - V$TIMEZONE_NAMES
      - V$OB_PLAN_CACHE_PLAN_EXPLAIN
      - V$OB_OPT_STAT_GATHER_MONITOR
      - GV$OB_LOG_STAT
      - GV$OB_SQL_WORKAREA_MEMORY_INFO
      - V$OB_SESS_TIME_MODEL
      - V$STATNAME
      - GV$SQL_WORKAREA_ACTIVE
      - V$OB_UNITS
      - GV$OB_PS_STAT
      - GV$INSTANCE
      - GV$OB_PS_ITEM_INFO
      - V$OB_COMPACTION_SUGGESTIONS
      - GV$OB_PLAN_CACHE_PLAN_EXPLAIN
      - GV$SYSTEM_EVENT
      - V$SESSTAT
      - V$SQL_MONITOR_STATNAME
      - V$NLS_PARAMETERS
      - V$OB_LS_LOG_RESTORE_STATUS
      - V$OB_TIMESTAMP_SERVICE
      - V$OB_SQL_WORKAREA_MEMORY_INFO
      - GV$OB_TRANSACTION_PARTICIPANTS
      - V$GLOBAL_TRANSACTION
      - V$OB_ARCHIVE_DEST_STATUS
      - V$OB_MEMSTORE
      - V$INSTANCE
      - GV$OB_OPT_STAT_GATHER_MONITOR
      - V$OB_DTL_INTERM_RESULT_MONITOR
      - V$SQL_WORKAREA_ACTIVE
      - V$OB_SQL_PLAN
      - V$SESSION_WAIT
      - V$OB_PX_P2P_DATAHUB
      - V$OB_ENCRYPTED_TABLES
      - V$RSRC_PLAN
      - GV$OB_ARBITRATION_MEMBER_INFO
      - GV$OB_SQLSTAT
      - GV$OB_ARBITRATION_SERVICE_STATUS
      - GV$OB_MEMSTORE
      - GV$OB_PLAN_CACHE_STAT
      - GV$OB_COMPACTION_SUGGESTIONS
      - V$OB_PS_STAT
      - V$EVENT_NAME
      - V$OB_THREAD
      - V$DML_STATS
      - GV$OB_PX_TARGET_MONITOR
      - V$GLOBALCONTEXT
      - GV$OB_DTL_INTERM_RESULT_MONITOR
      - V$OB_PLAN_CACHE_STAT
      - V$OB_KVCACHE
      - V$SQL_JOIN_FILTER
      - V$ACTIVE_SESSION_HISTORY
      - V$OB_ARBITRATION_SERVICE_STATUS
      - V$SQL_WORKAREA
      - V$OB_ARBITRATION_MEMBER_INFO
      - V$OB_GLOBAL_TRANSACTION
      - GV$OB_SQL_AUDIT
      - V$OB_LS_SNAPSHOTS
- Platforms
  - ODC
  - OCP
  - OMS
  - OAT
  - OMA
  - OCP Express
    - Tenant management
    - OCP Express
    - Monitor a cluster
    - Log service
    - View cluster overview information
    - Diagnostic analysis
- Parameters and system variables
  - Overview
  - System variables
    - Overview of system variables
    - Global variables
      - explicit_defaults_for_timestamp
      - block_encryption_mode
      - init_connect
      - nls_comp
      - error_on_overlap_time
      - sql_auto_is_null
      - parallel_degree_limit
      - performance_schema
      - div_precision_increment
      - datadir
      - nls_calendar
      - default_password_lifetime
      - validate_password_number_count
      - optimizer_capture_sql_plan_baselines
      - nls_length_semantics
      - runtime_filter_wait_time_ms
      - version
      - ob_read_consistency
      - optimizer_dynamic_sampling
      - character_set_connection
      - collation_database
      - sql_throttle_priority
      - ob_early_lock_release
      - character_set_database
      - ob_tcp_invited_nodes
      - ob_enable_transmission_checksum
      - ob_global_debug_sync
      - query_cache_size
      - ob_enable_jit
      - sql_throttle_current_priority
      - ob_plan_cache_evict_low_percentage
      - ob_reserved_meta_memory_percentage
      - nls_date_format
      - net_read_timeout
      - sql_safe_updates
      - secure_file_priv
      - max_user_connections
      - group_concat_max_len
      - nls_characterset
      - ob_enable_truncate_flashback
      - log_row_value_options
      - lower_case_table_names
      - sql_quote_show_create
      - ob_trx_timeout
      - ob_create_table_strict_mode
      - transaction_read_only
      - sql_throttle_rt
      - net_buffer_length
      - sql_throttle_network
      - tx_read_only
      - validate_password_mixed_case_count
      - parallel_servers_target
      - sql_select_limit
      - ob_enable_rich_error_msg
      - collation_server
      - debug_sync
      - event_scheduler
      - character_set_filesystem
      - character_set_results
      - ob_enable_blk_nestedloop_join
      - identity
      - ob_default_replica_num
      - nls_territory
      - regexp_time_limit
      - sql_warnings
      - nls_currency
      - nls_sort
      - ob_default_lob_inrow_threshold
      - ob_query_timeout
      - ob_pl_block_timeout
      - character_set_server
      - validate_password_policy
      - max_sp_recursion_depth
      - optimizer_use_sql_plan_baselines
      - validate_password_special_char_count
      - ob_enable_sql_audit
      - ob_compatibility_mode
      - query_cache_type
      - nls_timestamp_format
      - max_connections
      - innodb_strict_mode
      - nls_timestamp_tz_format
      - auto_increment_cache_size
      - ob_proxy_global_variables_version
      - nls_date_language
      - auto_increment_increment
      - nls_numeric_characters
      - max_allowed_packet
      - validate_password_length
      - tx_isolation
      - ob_timestamp_service
      - autocommit
      - binlog_row_image
      - transaction_isolation
      - ob_bnl_join_cache_size
      - license
      - ob_enable_plan_cache
      - resource_manager_plan
      - runtime_filter_max_in_num
      - ob_trx_idle_timeout
      - nls_nchar_conv_excp
      - runtime_bloom_filter_max_size
      - ob_enable_hash_group_by
      - ob_log_level
      - nls_dual_currency
      - auto_increment_offset
      - character_set_client
      - parallel_max_servers
      - ob_plan_cache_percentage
      - parallel_degree_policy
      - parallel_min_scan_time_threshold
      - sql_mode
      - collation_connection
      - ob_enable_transformation
      - interactive_timeout
      - character_set_system
      - optimizer_features_enable
      - cursor_sharing
      - read_only
      - ob_plan_cache_evict_high_percentage
      - recyclebin
      - ob_route_policy
      - nls_iso_currency
      - ob_sql_audit_percentage
      - ob_sql_work_area_percentage
      - ob_enable_aggregation_pushdown
      - ob_enable_pl_cache
      - ob_max_read_stale_time
      - ob_enable_index_direct_select
      - server_uuid
      - runtime_filter_type
      - version_comment
      - ob_trx_lock_timeout
      - foreign_key_checks
      - system_time_zone
      - validate_password_check_user_name
      - wait_timeout
      - nls_nchar_characterset
      - regexp_stack_limit
      - ob_temp_tablespace_size_percentage
      - cte_max_recursion_depth
      - net_write_timeout
      - time_zone
      - connect_timeout
      - plugin_dir
      - default_storage_engine
      - plsql_optimize_level
    - Session-level variables
      - runtime_bloom_filter_max_size
      - nls_language
      - last_insert_id
      - ob_org_cluster_id
      - ob_trace_info
      - is_result_accurate
      - runtime_filter_max_in_num
      - ob_max_read_stale_time
      - timestamp
      - parallel_min_scan_time_threshold
      - optimizer_dynamic_sampling
      - runtime_filter_type
      - ob_enable_show_trace
      - runtime_filter_wait_time_ms
      - ob_proxy_partition_hit
      - parallel_degree_policy
      - tracefile_identifier
      - ob_capability_flag
      - ob_proxy_set_trx_executed
      - parallel_degree_limit
      - ob_last_schema_version
  - Parameters
    - Overview
    - Cluster-level parameters
      - location_cache_priority
      - stack_size
      - tableapi_transport_compress_func
      - devname
      - cluster_id
      - disk_io_thread_count
      - enable_pg
      - minor_merge_concurrency
      - tablet_size
      - default_transport_compress_func
      - row_purge_thread_count
      - ofs_list
      - clog_transport_compress_func
      - location_fetch_concurrency
      - rpc_timeout
      - high_priority_net_thread_count
      - datafile_size
      - datafile_maxsize
      - get_leader_candidate_rpc_timeout
      - ob_esi_memory_limit
      - enable_manual_merge
      - global_index_build_single_replica_timeout
      - schema_history_expire_time
      - lease_time
      - schema_history_recycle_interval
      - weak_read_version_refresh_interval
      - location_cache_refresh_sql_timeout
      - backup_dest_option
      - cluster
      - opt_tab_stat_cache_priority
      - enable_auto_leader_switch
      - data_dir
      - storage_meta_cache_priority
      - balancer_timeout_check_interval
      - minor_deferred_gc_time
      - merger_completion_percentage
      - enable_upgrade_mode
      - backup_recovery_window
      - index_block_cache_priority
      - log_archive_checkpoint_interval
      - sql_login_thread_count
      - ob_esi_io_concurrency
      - clog_expire_days
      - user_block_cache_priority
      - trx_2pc_retry_interval
      - memory_chunk_cache_size
      - tcp_keepintvl
      - log_storage_warning_tolerance_time
      - backup_dest
      - server_balance_disk_tolerance_percent
      - backup_backup_dest
      - cpu_count
      - token_reserved_percentage
      - server_data_copy_out_concurrency
      - cpu_reserved
      - switchover_process_thread_count
      - trx_try_wait_lock_timeout
      - ob_ratelimit_stat_period
      - dtl_buffer_size
      - enable_sys_table_ddl
      - rootservice_list
      - dead_socket_detection_timeout
      - local_ip
      - tenant_groups
      - server_permanent_offline_time
      - memstore_limit_percentage
      - backup_zone
      - tablet_meta_table_check_interval
      - location_cache_refresh_min_interval
      - server_data_copy_in_concurrency
      - standby_fetch_log_bandwidth_limit
      - minor_warm_up_duration_time
      - election_blacklist_interval
      - net_thread_count
      - virtual_table_location_cache_expire_time
      - multiblock_read_gap_size
      - rpc_port
      - autoinc_cache_refresh_interval
      - replica_safe_remove_time
      - leak_mod_to_check
      - observer_id
      - ob_esi_session_timeout
      - enable_record_trace_id
      - sql_protocol_min_tls_version
      - log_archive_batch_buffer_limit
      - large_query_threshold
      - enable_ddl
      - enable_rootservice_standalone
      - tenant_cpu_variation_per_server
      - datafile_next
      - plan_cache_evict_interval
      - memory_limit
      - syslog_io_bandwidth_limit
      - system_cpu_quota
      - restore_concurrency
      - enable_ob_ratelimit
      - wait_leader_batch_count
      - sys_bkgd_io_low_percentage
      - diag_syslog_per_error_limit
      - zone_merge_concurrency
      - sys_bkgd_migration_change_member_list_timeout
      - auto_broadcast_location_cache_rate_limit
      - log_disk_percentage
      - mysql_port
      - enable_one_phase_commit
      - log_disk_size
      - tcp_keepcnt
      - ilog_index_expire_time
      - enable_rpc_authentication_bypass
      - enable_ob_esi_process
      - obconfig_url
      - enable_record_trace_log
      - ignore_replay_checksum_error
      - migrate_concurrency
      - tenant_task_queue_size
      - data_storage_warning_tolerance_time
      - merge_thread_count
      - zone_merge_order
      - global_major_freeze_residual_memory
      - enable_rich_error_msg
      - memory_reserved
      - balancer_log_interval
      - px_task_size
      - recyclebin_object_expire_time
      - enable_cgroup
      - min_observer_version
      - enable_sys_unit_standalone
      - workers_per_cpu_quota
      - resource_soft_limit
      - rootservice_ready_check_interval
      - debug_sync_timeout
      - partition_table_check_interval
      - plan_cache_high_watermark
      - index_clog_cache_priority
      - global_write_halt_residual_memory
      - enable_syslog_wf
      - enable_log_archive
      - clog_sync_time_warn_threshold
      - syslog_level
      - system_memory
      - enable_syslog_recycle<main id="notice" type='explain'>
      - clog_disk_usage_limit_percentage
      - enable_rereplication
      - ob_startup_mode
      - clog_cache_priority
      - migration_disable_time
      - enable_async_syslog
      - config_additional_dir
      - ob_event_history_recycle_interval
      - memory_limit_percentage
      - rpc_client_authentication_method
      - unit_balance_resource_weight
      - enable_global_freeze_trigger
      - backup_concurrency
      - rootservice_async_task_thread_count
      - index_info_block_cache_priority
      - max_px_worker_count
      - bf_cache_priority
      - tablet_meta_table_scan_batch_count
      - merger_warm_up_duration_time
      - sys_bkgd_net_percentage
      - balance_blacklist_failure_threshold
      - enable_sql_operator_dump
      - merge_stat_sampling_ratio
      - user_row_cache_priority
      - bf_cache_miss_count_threshold
      - auto_refresh_location_cache_rate_limit
      - enable_sql_audit
      - all_server_list
      - ls_meta_table_check_interval
      - resource_hard_limit
      - datafile_disk_percentage
      - server_check_interval
      - internal_sql_execute_timeout
      - data_storage_error_tolerance_time
      - auto_leader_switch_interval
      - election_cpu_quota
      - zone_merge_timeout
      - data_copy_concurrency
      - max_syslog_file_count
      - sql_audit_memory_limit
      - default_compress
      - enable_tcp_keepalive
      - use_large_pages
      - micro_block_merge_verify_level
      - cache_wash_threshold
      - tcp_keepidle
      - merger_switch_leader_duration_time
      - sys_bkgd_migration_retry_num
      - ssl_external_kms_info
      - enable_perf_event
      - max_string_print_length
      - flush_log_at_trx_commit
      - enable_merge_by_turn
      - enable_dblink
      - balancer_emergency_percentage
      - large_query_worker_percentage
      - location_cache_expire_time
      - ob_esi_syslog_level
      - ob_esi_rpc_port
      - default_compress_func
      - balance_blacklist_retry_interval
      - location_refresh_thread_count
      - server_balance_cpu_mem_tolerance_percent
      - location_cache_cpu_quota
      - builtin_db_data_verify_cycle
      - px_workers_per_cpu_quota
      - server_balance_critical_disk_waterlevel
      - enable_auto_refresh_location_cache
      - rootservice_memory_limit
      - index_cache_priority
      - plan_cache_low_watermark
      - minor_freeze_times
      - ssl_client_authentication
      - all_cluster_list
      - rpc_server_authentication_method
      - multiblock_read_size
      - ignore_replica_checksum_error
      - strict_check_os_params
      - location_cache_refresh_rpc_timeout
      - zone
      - clog_disk_utilization_threshold
      - enable_major_freeze
      - backup_log_archive_option
      - data_disk_usage_limit_percentage
      - user_iort_up_percentage
      - enable_election_group
      - sys_bkgd_io_high_percentage
      - rdma_io_thread_count
      - backup_backup_dest_option
      - user_tab_col_stat_cache_priority
      - ob_esi_max_syslog_file_count
      - server_cpu_quota_min
      - system_trace_level
      - trx_force_kill_threshold
      - backup_net_limit
      - fuse_row_cache_priority
      - max_kept_major_version_number
      - trace_log_slow_query_watermark
      - enable_separate_sys_clog
      - sys_cpu_limit_trigger
      - enable_smooth_leader_switch
      - balancer_tolerance_percentage
      - balancer_task_timeout
      - row_compaction_update_limit
      - rootservice_async_task_queue_size
      - enable_asan_for_memory_context
      - fast_recovery_concurrency
      - backup_region
      - sql_net_thread_count
      - gc_wait_archive
      - rebuild_replica_data_lag_threshold
      - server_cpu_quota_max
      - trace_log_sampling_interval
      - tablet_ls_cache_priority
      - default_row_format
    - Tenant-level parameters
      - audit_sys_operations
      - audit_trail
      - clog_persistence_compress_func
      - enable_clog_persistence_compress
      - enable_early_lock_release
      - external_kms_info
      - backup_data_file_size
      - log_disk_utilization_limit_threshold
      - log_disk_utilization_threshold
      - max_stale_time_for_weak_consistency
      - compaction_high_thread_score
      - compaction_mid_thread_score
      - ob_enable_batched_multi_statement
      - ob_proxy_readonly_transaction_routing_policy
      - open_cursors
      - plsql_code_type
      - plsql_optimize_level
      - plsql_warnings
      - sql_work_area
      - tde_method
      - job_queue_processes
      - ha_high_thread_score
      - ha_mid_thread_score
      - ha_low_thread_score
      - query_response_time_flush
      - query_response_time_range_base
      - freeze_trigger_percentage
      - cpu_quota_concurrency
      - compatible
      - log_transport_compress_all
      - log_transport_compress_func
      - rpc_memory_limit_percentage
      - tenant_sql_login_thread_count
      - dump_data_dictionary_to_log_interval
      - enable_user_defined_rewrite_rules
      - enable_rebalance
      - balancer_idle_time
      - plsql_v2_compatibility
      - job_queue_processes
      - ha_high_thread_score
      - ha_mid_thread_score
      - ha_low_thread_score
      - ob_compaction_schedule_interval
      - default_auto_increment_mode
      - ob_query_switch_leader_retry_timeout
      - default_enable_extended_rowid
      - major_freeze_duty_time
      - undo_retention
      - query_response_time_stats
      - query_response_time_flush
      - query_response_time_range_base
      - merger_check_interval
      - freeze_trigger_percentage
      - cpu_quota_concurrency
      - arbitration_timeout
      - compatible
      - log_transport_compress_all
      - log_transport_compress_func
      - rpc_memory_limit_percentage
      - tenant_sql_login_thread_count
      - tenant_sql_net_thread_count
      - dump_data_dictionary_to_log_interval
      - enable_user_defined_rewrite_rules
      - partition_balance_schedule_interval
      - log_disk_throttling_percentage
      - enable_rebalance
      - balancer_idle_time
      - log_disk_throttling_maximum_duration
      - ls_gc_delay_time
      - standby_db_preferred_upstream_log_region
      - archive_lag_target
      - range_optimizer_max_mem_size
      - log_restore_concurrency
      - log_archive_concurrency
      - standby_db_fetch_log_rpc_timeout
      - enable_transfer
      - kv_ttl_duty_duration
      - kv_ttl_history_recycle_interval
      - enable_kv_ttl
      - ttl_thread_score
      - compaction_dag_cnt_limit
      - compaction_schedule_tablet_batch_cnt
      - kv_transport_compress_func
      - kv_transport_compress_threshold
      - optimizer_index_cost_adj
      - default_table_store_format
- Database object management
  - Overview
  - Oracle mode
    - Manage synonyms
    - Manage sequences
    - Manage directory objects
    - Create and manage DBLinks
      - Drop a DBLink
      - Use a DBLink to access data in a remote database
      - Query existing DBLinks
      - Use a DBLink to modify data in a remote database
      - Install and configure OCI
      - Create a DBLink
    - Manage views
      - Manage standard views
      - Manage materialized views
        Materialized views
        Drop a materialized view
        Refresh a materialized view
        Query a materialized view
        Overview
        Create a materialized view
        Materialized view logs
        Create a materialized view log
        Overview
        Drop a materialized view log
    - Create and manage table groups
      - Drop a table group
      - Query information about a table group
      - Manage tables in a table group
      - Add tables to a table group
      - Modify the SHARDING attribute of a table group
      - Overview
      - Create a table group
    - Create and manage partitions
      - Overview
      - Drop a partition
      - Create a partitioned table
      - Rename a partition
      - Partition pruning
      - Truncate a partition
      - Add a partition
      - Query data in specified partitions
      - Modify partitioning rules
      - Create indexes on partitioned tables
        Global indexes
        Local indexes
        Overview
    - Create and manage tables
      - Overview
      - Create a table
      - Column skip index attribute
      - Define column constraints
      - Query the definition of a table
      - Modify a table
      - Empty a table
      - Drop a table
      - Lock a table
      - Create and manage external tables
        Create an external table
        Overview
        Manage external files
    - Create and manage triggers
      - Create an INSTEAD OF trigger
      - Modify and drop a trigger
      - Create a DML trigger
      - Query trigger information
      - Disable or enable a trigger
      - Create a composite trigger
      - Overview
    - Create and manage indexes
      - Overview
      - Monitor indexes
      - Create an index
      - Query indexes
      - System functions not supported for function-based indexes
      - System functions supported for function-based indexes
      - Drop an index
  - MySQL mode
    - Create and manage table groups
      - Manage tables in a table group
      - Overview
      - Drop a table group
      - Add tables to a table group
      - Create a table group
      - Modify the SHARDING attribute of a table group
      - Query information about a table group
    - Create and manage indexes
      - System functions supported for function-based indexes
      - Query indexes
      - Drop an index
      - Monitor indexes
      - System functions not supported for function-based indexes
      - Create an index
      - Overview
    - Create and manage databases
      - View databases
      - Create a database
      - Drop a database
      - Modify a database
    - Manage views
      - Manage standard views
      - Manage materialized views
        Materialized views
        Query a materialized view
        Overview
        Create a materialized view
        Refresh a materialized view
        Drop a materialized view
        Materialized view logs
        Overview
        Create a materialized view log
        Drop a materialized view log
    - Create and manage partitions
      - Create a partitioned table
      - Query data in specified partitions
      - Drop a partition
      - Modify partitioning rules
      - Truncate a partition
      - Overview
      - Partition pruning
      - Add a partition
      - Create indexes on partitioned tables
        Overview
        Local indexes
        Global indexes
    - Create and manage tables
      - Empty a table
      - Create a table
      - Define column constraints
      - Lock a table
      - Modify a table
      - Query the table definition
      - Drop a table
      - Define an auto-increment column
      - Overview
      - Column skip index attribute
      - Create and manage external tables
        Overview
        Manage external files
        Create an external table
    - Create and manage sequences
      - Modify a sequence
      - Query sequences
      - Create a sequence
      - Drop a sequence
      - Reference a sequence
    - Create and manage triggers
      - Drop a trigger
      - Query trigger information
      - Overview
      - Create a DML trigger
    - Create and manage DBLinks
      - Use a DBLink to access data in a remote database
      - Query a DBLink
      - Drop a DBLink
      - Create a DBLink
- System principles
  - Development of OceanBase Database
  - Overall architecture of OceanBase Database
  - Database objects
    - Oracle mode
      - Partitions
        Overview
        Partitioning keys
        Partitioning types
        Partitioned indexes
      - Tables
        Integrity constraints
        Partitioned table
        Table storage
        Temporary tables
        Table compression
        Overview
        Tables with and without a primary key
        Data type
        ROWID data types
        Numeric data types
        Datetime data types
        LOB data types
        Character data types
        Multi-model data types
        Overview
        Format model
        Number format models
        Overview
        Datetime format models
      - Views
        Views in a database
        Materialized views
        Materialized view logs
        Materialized views
        Creation and update strategies for materialized views
        Standard views
        Standard views
        Overview
        Oracle-compatible views
        View operations and data access
        OceanBase-specific views
      - Introduction
        Overview
        Database object types
        Database object storage
        Dependencies between database objects
      - Other objects
        Sequences
        Synonyms
      - Data integrity
        Overview
        Use of integrity constraints
        Integrity constraint type
        UNIQUE KEY constraints
        Overview
        FOREIGN KEY constraints
        PRIMARY KEY constraints
        NOT NULL constraints
        CHECK constraints
      - System views
        Dictionary views
        Performance views
      - Indexes
        Local and global indexes
        Unique and non-unique indexes
        Index storage
        Use indexes
        Overview
    - MySQL mode
      - Data integrity
        Use of integrity constraints
        Overview
        Integrity constraint type
        PRIMARY KEY constraints
        Overview
        NOT NULL constraints
        UNIQUE KEY constraints
        FOREIGN KEY constraints
      - Views
        Views in a database
        Standard views
        Overview
        Overview
        OceanBase-specific views
        MySQL-compatible views
        Oracle-compatible views in MySQL tenants
        Oracle-compatible views in the sys tenant
        View operations and data access
        Materialized views
        Materialized views
        Creation and update strategies for materialized views
        Materialized view logs
      - Introduction
        Dependencies between database objects
        Overview
        Database object storage
        Database object types
      - Indexes
        About indexes
        Index storage
        Use indexes
        Unique and non-unique indexes
        Spatial indexes
        Local and global indexes
      - Partitions
        Partitioned indexes
        Overview
        Partitioning types
        Partitioning keys
      - Tables
        Table storage
        Tables with and without a primary key
        Partitioned table
        Table compression
        Integrity constraints
        Overview
        Data type
        Numeric data types
        LOB data types
        Datetime data types
        Overview
        Multi-model data types
        JSON data types
        Spatial data types
        Character data types
      - System views
        Performance views
        Dictionary views
  - OBServer node architecture
    - Structure of the OBServer node installation directory
    - Configuration files
    - Logs
    - Memory management
      - Memory-related views
      - Memory-related parameters
      - Diagnose memory errors
      - Memory usage logs
      - Overview
    - observer thread model
      - Threads
      - Worker threads
      - Background threads
  - Storage architecture
    - Query processing
    - Overview
    - Multi-level caches
    - Data storage
      - Overview
      - MemTables
      - SSTables
      - Columnar storage
      - Compression and encoding
    - Data integrity
      - Detect silent data corruption
    - Compaction
      - Overview
      - Major compaction
      - Minor compaction
  - User interface and query language
    - Client programming languages
    - SQL
      - Query SQL execution plans
      - Execution process of SQL queries
      - Introduction
        SQL data access
        SQL standards
        Overview
      - Distributed execution plan
        Perform distributed execution and parallel queries
        Manage distributed execution plans
        Run and disable a parallel query
        Generate distributed execution plans
        Perform parameter tuning for a parallel query
      - SQL statements
        Overview
        DDL statements
        DCL statements
        DML statements
    - PL
      - PL subprogram execution mechanism
      - PL concepts
        MySQL mode
        Functions
        Stored procedures
        Subprograms
        Triggers
        Oracle mode
        Subprograms
        Triggers
        Functions
        Stored procedures
        Packages
  - Data link
    - Overview
    - Database proxy
      - SQL routing
      - ODP configuration management
      - Connection management
      - Overview
      - Logs and monitoring
    - Database connector
      - Overview
      - OBCI
      - OceanBase Connector/J
      - OceanBase Connector/C
  - Distributed database objects
    - Overview
    - Cluster architecture
    - Data partitions and replicas
      - Overview
      - Log streams
      - Partition replica type
        Overview
        Read-only replicas
        Full-featured replica
      - Multi-replica consensus protocols
      - Data balancing
        Intra-tenant balancing
        Views and parameters related to data balancing
    - Dynamic scaling
      - Cluster scaling
      - Tenant resource scaling
        Horizontal scaling of tenant resources
        Overview
        Cross-zone management of tenant resources
        Vertical scaling of tenant resources
  - Multi-tenant architecture
    - Tenants
    - Overview
    - Compatibility modes
    - Tenants and resource management
      - Resource unit balancing
      - Multi-tenant resource isolation
      - Tenant resource management
  - Transaction management
    - Transaction concurrency and consistency
      - Multi-version read consistency
      - Weak consistency read
      - Overview
      - Transaction isolation level
        Transaction isolation levels in MySQL mode
        Overview
        Transaction isolation levels in Oracle mode
      - Concurrency control
        Lock mechanism
        Overview
    - Transaction
      - Overview
      - Statement-level atomicity
      - Redo logs
      - Transaction structure
      - XA transactions
      - Local transactions
      - GTS
      - Transaction control
        Active transactions
        Overview
        Savepoint
        Transaction control statements
        MySQL transaction control
        Oracle transaction control
      - Distributed transaction
        Two-phase commit
        Overview
  - Data reliability and high availability
    - Deployment solutions for disaster recovery
    - Arbitration-based high availability solution
    - Physical Standby Database solution
    - Data protection
      - Recycle bin
      - Flashback queries
      - Overview
    - High availability architecture
      - Automatic handling of node failures
      - ODP high availability
      - Paxos protocol
      - Leader election in distributed systems
      - Multi-replica log synchronization
      - Overview
    - Backup and restore
      - Overview
      - Backup directory structures
      - Restore architecture
      - Backup architecture
  - Database security
    - Security audit
    - Monitoring and alerting
    - Access control
    - Authentication
    - Data transmission encryption
    - Data storage encryption
    - Overview
- Database design specifications and practices
  - Character set specifications
  - Comments
  - ORM conventions
  - Database connection specifications
  - Exception handling
  - Object structure design specifications
    - Field design
    - Partitioned table design
    - Index design
    - Table structure design
    - Other structural designs
  - Object naming conventions
    - Tenant naming conventions
    - Overview
    - Other naming conventions
    - User naming conventions
    - Field naming conventions
    - Table naming conventions
- Performance tuning
  - Overview
  - SQL tuning
    - Glossary
    - Execution process of SQL queries
    - General issues in SQL tuning
    - SQL tuning
      - General procedure
      - Overview
      - SQL execution performance monitoring
        SQL Trace
        GV$OB_SQL_AUDIT
        Plan cache views
        SQL performance analysis example
        Query the distribution of SQL traffic and QPS among OBServer nodes
        Analyze queries related to distributed plans
        Find the TOP N queries with the longest execution time within a certain period
        Check whether the RPC execution count of a distributed subplan is balanced across servers in a cluster
        Find the TOP N SQL queries
        Check whether SQL queries are balanced across servers in a cluster
        Find full table scan SQL statements in a tenant
        Analyze SQL queries that cause an abrupt RT jitter
        Analyze slow SQL queries
        Use SQL Audit to analyze wait events in a query
        Analyze whether an unusually large number of remote execution requests exist in the system or the execution of an SQL statement
        View and analyze the shape of an execution plan
      - Query rewrite
        Cost-based query rewrite
        Overview
        Rule-based query rewriting
      - Query optimization
        Join algorithm
        Overview
        Join algorithms
        Runtime filter
        Join order
        Access path
        Cost-based path selection
        Overview
        Rule-based path selection
      - Optimizer statistics
        Examples
        Monitoring and diagnostics for statistics collection
        Overview of statistics
        Statistics collection methods
        Histograms
        Dynamic sampling
        Overview
        Online statistics collection
        Automatic statistics collection
        Manual statistics collection
        Statistics management
        Manage statistics history
        Lock and unlock statistics
        Manage statistics preferences
        Overview
        Import and export statistics
        Delete statistics
        Set statistics
      - Manage execution plans
        Optimizer hints
        Plan binding
        SQL plan management
    - SQL execution plans
      - Fast parameterization
      - Plan cache
      - Display real-time execution plans
      - Introduction to SQL execution plans
      - SQL tuning practice with EXPLAIN
      - Execution plan operators
        SUBPLAN FILTER
        COUNT
        INTERSECT
        SUBPLAN SCAN
        JOIN
        DELETE
        SEQUENCE
        EXCHANGE
        GROUP BY
        FOR UPDATE
        TABLE SCAN
        UNION
        MERGE
        EXCEPT/MINUS
        UPDATE
        WINDOW FUNCTION
        SELECT INTO
        GI
        LIMIT
        DISTINCT
        MATERIAL
        INSERT
        SORT
    - Distributed execution plans
      - Schedule distributed execution plans
      - Parallel DML
      - Enable parallel execution and set the degree of parallelism
      - Perform parameter tuning for a parallel query
      - Manage distributed execution plans
      - Perform distributed execution and parallel queries
      - Auto DOP
      - Execute parallel queries
      - Generate a distributed plan
    - Parallel execution plans
      - Quick start
      - Classification and optimization of parallel execution
      - Introduction
      - Parallel execution tuning tips
      - Parallel execution diagnostics
      - Set concurrent execution
        Concurrency control and queuing
        Set parallel execution parameters
        Set a DOP for parallel execution
  - System tuning
    - OS parameter tuning
    - Database parameter tuning
      - CPU parameters
      - I/O parameters
      - Memory-related parameters
      - Network transmission parameters
    - ODP parameter tuning
      - Network transmission parameters
      - Routing parameters on nodes
      - CPU parameters
  - Performance related tools
    - OCP
    - System tools
      - CPU tools
      - Memory tools
      - Top
      - Network tools
      - Disk I/O tools
    - Internal tables
      - GV$OB_SQL_AUDIT
      - GV$OB_TRANSACTION_PARTICIPANTS
      - GV$SYSSTAT
    - Logs
      - slow trans
      - dump tenant info
      - Trace logs
  - Performance diagnosis
    - Monitor and diagnose the cluster performance
    - Diagnose tenant performance
    - Monitor ODP performance
    - Monitor host performance
    - WR management
      - Overview
      - Manage WR
      - Monitor historical session performance
      - Clean up WR data
    - ASH report
      - Analyze ASH reports
      - Generate ASH reports
      - ASH
  - Business model tuning
    - SQL diagnostics
    - Distributed transactions
    - Load balancing
- Components & tools
  - O&M management
    - ob_error
    - OBD
    - ob-operator
    - OBShell
      - Overview
      - API references
        OBShell API requests
        AgentUpgradeCheck
        ObUpgradeCheck
        UpgradeAgent
        UpgradeOb
        AddNode
        GetPublicKey
        QueryNodeStatus
        Query the status of an OceanBase cluster
        OperateDag
        GetDagDetails
        GetNodeDetails
        GetSubtaskDetails
        QueryUnfinishedTasks
        QueryUnfinishedAgentTasks
        QueryUnfinishedObTasks
        QueryLastObTask
        QueryLastAgentTask
        AddNodeBeforeClusterInitialization
        DeleteNodeBeforeClusterInitialization
        SetClusterConfig
        SetServerConfig
        InitializeCluster
        StartCluster
        StopCluster
        UploadPkg
        Hybrid encryption for API operations
      - Command line
        Cluster commands of OBShell
        Task commands of OBShell
        Agent commands of OBShell
      - Use OBShell
        Start or stop OBShell
        Deploy an OceanBase cluster
        Take over an OceanBase cluster not deployed by OBShell
        Start an OceanBase cluster
        Stop an OceanBase cluster
        Use OBShell to scale out an OceanBase cluster
        Upgrade an OceanBase cluster
        Upgrade OBShell
        Configure an OBServer node to start automatically on boot
    - ob_admin
      - ob_admin overview
      - dumpsst
      - dump_backup
      - clog
        log_tool
        Format of clogs
        Transaction logs
  - Data integration
    - OBLogProxy
    - OBLOADER & OBDUMPER
    - Partition calculator
      - Overview
      - Use the ob-partition-calculator component
    - CDC
      - Overview
      - obcdc development guide
      - obcdc
        FAQ about obcdc
        Deploy and use obcdc
        Install and deploy obcdc
        obcdc_tailf
        obcdc parameters
        General obcdc parameters
        obcdc parameters
      - oblogmsg
        Install and deploy oblogmsg
        Description of some oblogmsg API operations
  - Monitoring and diagnostics
    - obdiag
    - DOOBA
    - SQL Diagnoser
      - Overview
      - Deploy and use SQL Diagnoser
        Install SQL Diagnoser
        Use SQL Diagnoser
      - SQL Diagnoser remarks
        Built-in diagnostic items
        Diagnostic rule expression
        API operations
        Diagnostic items of SQL review
  - Stress testing tools
    - mysqltest
      - Use obd.sh to run mysqltest
      - Use mysqltest
        Add a test case
        Test case writing conventions
        General test case writing commands
- System management
  - Configuration management
    - Overview
    - Set parameters
    - Set variables
  - Storage management
    - Major compaction management
      - View merge information
      - Adaptive major compaction
      - Overview
      - Manually initiate a major compaction
      - Configure scheduled major compactions
      - Automatically trigger a major compaction
      - Modify major compaction settings
      - Manually control a major compaction
    - Minor compaction management
      - Modify minor compaction parameters
      - Automatically trigger a minor compaction
      - Manually initiate a minor compaction
      - Overview
      - View dump information
    - Data compression
      - Data encoding and compression
      - Overview
  - Memory management
    - Overview
    - Manage the memory of the plan cache
    - Manage internal system memory
    - Set the maximum memory for an OceanBase database
    - Memory management within a tenant
    - Common memory issues
    - Memleak-based regular memory leak diagnostics mechanism
    - Memory structure
    - Query memory usage information
  - Process management
    - Background threads of OceanBase Database
    - Overview
    - Multi-tenant threads of OceanBase Database
    - FAQ about multi-tenant threads
    - View the thread status
  - Disk management
    - Configure automatic scale-out of disk space for data files
- Database proxy
  - Connection and routing
  - View tenant sessions
  - Physical connections
  - Terminate a tenant session
  - OceanBase Database Proxy
  - Set the maximum number of connections for a tenant
  - Logical connection
    - Query session variables
    - Terminate a server session
    - Query the metrics of a session
    - Query all sessions
    - Query the details of a session
  - Route management
    - LDC-based routing
    - Table-based routing of ODP
    - ODP routing policy
      - Transaction routing
      - Blocklist mechanism
      - Follower-first read
      - Read/Write splitting
  - ODP
    - ODP startup parameters
    - Overview
    - Manage ODP
      - Start an ODP
      - Stop an ODP
      - Restart an ODP
      - Refresh ODP configurations
      - Add an ODP
      - Upgrade one or more ODPs
      - Delete an ODP
    - Manage ODP clusters
      - Restart all ODPs in an ODP cluster
      - Create an ODP cluster
      - Delete an ODP cluster
      - Manage ODP cluster parameters
      - Upgrade all ODPs in an ODP cluster
      - Manage OceanBase clusters connected to an ODP cluster
      - Monitor ODP cluster performance
- Error codes
  - Oracle mode
    - ORA-01000 to ORA-01499
    - ORA-30000 to ORA-49999
    - ORA-20000 to ORA-29999
    - ORA-10000 to ORA-19999
    - ORA-50000 to ORA-99999
    - ORA-05000 to ORA-10000
    - ORA-01500 to ORA-01999
    - PLS-00000 to PLS-00999
    - ORA-00000 to ORA-00999
    - Overview
    - ORA-02000 to ORA-04999
  - MySQL mode
    - 7000 to 7999
    - 4000 to 4499
    - 5000 to 5999
    - Overview
    - 9500 to 9999
    - 4500 to 4999
    - 10000 to 12000
    - 8000 to 8999
    - 9000 to 9499
    - 6000 to 6999
    - 0001 to 3999
    - 22998, 30926, 38104, and 38105
- Drivers
  - OBCI
  - OceanBase Connector/ODBC
  - ECOB
  - OceanBase Connector/J
  - OceanBase Connector/C
- Integrations
  - Superset
  - DolphinScheduler
  - SeaTunnel
  - Linkis
  - Maxwell
  - Bytebase
- Multi-model API
  - RPC message compression
FAQ
- FAQs
- High availability
- FAQs
- FAQ about columnstores
- Cluster management
- SQL statements
Release Notes
- Version rules
- OceanBase Database Enterprise Edition
  - V3.2
    - OceanBase Database Enterprise Edition V3.2.0
    - OceanBase Database Enterprise Edition V3.2.3
    - OceanBase Database Enterprise Edition V3.2.4
    - OceanBase Database Enterprise Edition V3.2.2
    - OceanBase Database Enterprise Edition V3.2.1
  - V4.1
    - OceanBase Database Enterprise Edition V4.1.0
  - V4.2
    - OceanBase Database Enterprise Edition V4.2.1
    - OceanBase Database Enterprise Edition V4.2.0
  - V4.3
    - OceanBase Database Enterprise Edition V4.3.0
  - V3.1
    - OceanBase Database Enterprise Edition V3.1.1
    - OceanBase Database Enterprise Edition V3.1.2
  - V2.2
    - OceanBase Database Enterprise Edition V2.2.77
    - OceanBase Database Enterprise Edition V2.2.76
    - OceanBase Database Enterprise Edition V2.2.30
- OceanBase Database Community Edition
  - V4.0
    - OceanBase Database Community Edition V4.0.0
  - V3.1
    - OceanBase Database Community Edition V3.1.3
    - OceanBase Database Community Edition V3.1.4
    - OceanBase Database Community Edition V3.1.2
    - OceanBase Database Community Edition V3.1.1
    - OceanBase Database Community Edition V3.1.5
  - V4.2
    - OceanBase Database Community Edition V4.2.0
    - OceanBase Database Community Edition V4.2.1
  - V4.3
    - OceanBase Database Community Edition V4.3.0
  - V4.1
    - OceanBase Database Community Edition V4.1.0

Download PDF