OceanBase
English日本語简体中文
Docs Home
Products
Integrations
Release Notes

Databases

OceanBase DatabaseOceanBase AI DatabaseOceanBase Cloud OceanBase Best Practices

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog ServiceOceanBase DataPilotOceanBase OAgent

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Databases

OceanBase DatabaseOceanBase AI DatabaseOceanBase Cloud OceanBase Best Practices

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog ServiceOceanBase DataPilotOceanBase OAgent
OceanBase DatabaseOceanBase Cloud ToolsConnectors and MiddlewareLifecycle Support Policy

OceanBase AI Database

V4.6.3
  • Introduction
    • Overview
    • Core features
    • System architecture
  • Get Started
    • Get started with OceanBase AI Database
  • Deploy
    • Choose an appropriate deployment plan
    • Deployment process
    • Before deployment
      • Prepare servers
      • Configure Servers
      • Prepare object storage
      • Prepare installation packages
      • Deploy OAT
    • Add a server
    • Deploy OCP
      • OCP deployment overview
      • Upload installation packages
      • Create MetaDB
      • Deploy OCP
    • Deploy OceanBase AI Database
      • Create an object storage configuration
      • Deploy a LogService cluster by using OCP
      • Deploy an OceanBase AI Database cluster using OCP
    • (Optional) Deploy OBProxy
    • Deploy Java SDK
    • Recommended configurations
  • Connect
    • Overview of connection methods
    • Clients
      • MySQL client
      • OBClient
      • ODC
    • GUI tools
      • DBeaver
      • Navicat
    • Drivers and ORMs
      • Connect via driver or ORM framework
      • Examples
        • C#
          • MySQL Connector/C
        • Go
          • Go-SQL-Driver/MySQL
          • GORM
        • Java
          • Connector/J
          • Spring JDBC
          • SpringBoot
          • SpringBatch
          • SpringDataJPA
          • Hibernate
          • MyBatis
          • TestContainers
        • PHP
          • EXT
          • MySQLi
          • PDO
        • Python
          • PyMySQL
          • mysqlclient
          • MySQL-connector-python
          • SQLAlchemy
          • Django
          • peewee
    • Connection pool
      • Database connection pool configuration
      • Tomcat
      • C3P0
      • Proxool
      • HikariCP
      • DBCP
      • Commons Pool
      • Druid
      • JDBC
    • Connect to OceanBase AI Database by using SDK
  • Design Database Schema
    • Overview of database schema design
    • Table design
    • Data distribution
    • Indexes
    • Data types
    • Logical table
      • Logical table overview
      • Agent hybrid search scenario
        • Overview
        • Quick start
        • Collection and namespace management
        • Write data
        • Search data
        • Indexes and embedding functions
        • Monitoring and maintenance
        • API reference
      • Flash application scenario
        • Overview
        • Limitations and constraints
        • Connect
        • Quick start
        • Collection and app management
        • Data operations
  • Data Pipeline
    • Data ingestion
      • Data migration
        • Data migration overview
        • Use mydumper and myloader to migrate data from a MySQL database
        • Use DBCAT to migrate table structures from a MySQL database
        • Use DataX to migrate table data from a MySQL database
        • Use DBCAT to migrate table structures from an Oracle database
        • Use DataX to migrate table data from an Oracle database
        • Use DBCAT to migrate table structures from a DB2 LUW database
        • Migrate from CSV files
          • Use DataX
          • Use LOAD DATA
        • Migrate by using SQL statements
          • Migrate data between tables
          • Migrate resource units
          • Export data using the OUTFILE statement
      • Data import
        • Data import overview
        • Import data by using the LOAD DATA statement
        • INSERT INTO SELECT
          • Use the INSERT INTO SELECT FROM FILES statement for direct load
          • Import data from external tables using INSERT INTO SELECT
        • Import data via direct load using the CREATE TABLE AS SELECT statement
        • Import data by using obloader
    • Data delivery
      • Export data
      • Data lake
        • Data lake overview
        • Data lake integration
          • Access Hive tables through HMS Catalog
          • Load an Iceberg table through Catalog
          • Read Paimon tables by using plugins
          • ODPS Catalog and external tables
          • Catalogs and external tables
          • File external tables
        • External tables via URL
    • Data sharing
      • Automatic catalog data synchronization
      • Manual catalog data synchronization
  • Data Processing
    • Structured data processing
      • In-database processing
      • Materialized views
      • Data processing tools
    • Unstructured data processing
      • Vector embedding
        • Overview of Vector Embedding Technology
        • Use the AI_EMBED function
        • Use external embedding models
  • Data Branching
    • Overview of Fork
    • Fork Table
    • Fork Database
  • AI Search
    • Vector search
      • Vector search overview
      • Perform vector search using SQL
      • Vector data types overview
      • Store vector data
      • Vector index
        • Overview of vector indexes
        • Vector index memory management
        • Dense index
          • Overview of dense indexes
          • Index type selection
          • HNSW series indexes
          • IVF series indexes
        • Sparse index
          • In-memory sparse vector index
        • Monitor and maintain indexes
        • Index performance optimization
      • Search index
      • Use SQL functions
      • Vector nearest neighbor search
      • FAQ on AI scenarios
    • Semantic search
    • Full-text search
    • Hybrid search
    • Rerank search
  • Query Acceleration
    • Statistics
    • Choose the query parallelism
    • Accelerate queries with materialized views
  • Manage
    • Log in to an user tenant
    • Manage clusters
      • Cluster overview
      • Compute service management
        • Cluster parameters
        • Common cluster operations
          • View a zone
          • View a node
          • Restart a node
          • Add a node
          • Delete a node
          • Isolate a node
          • Replace a node
          • Start a zone
          • Add a zone
          • Delete a zone
          • Modify a zone
          • Isolate a zone
          • View cluster parameters
          • Modify cluster parameters
          • Reset cluster parameters
          • Update object storage access credentials
        • Data load balancing
          • Data load balancing overview
          • Transfer a partition
          • Cancel a partition transfer task
          • Cancel a balance job
          • Stop and resume a balance job
          • Table group weight management
            • Aggregation of user tables under a database
            • Set table group weights
            • Clear a table group's weight
            • Application scenarios of table group weight balancing
          • Partition weight management
            • Set partition weights
            • Clear partition weights
          • Partition balance management
            • Configure a scheduled partition balancing task
            • Manually trigger partition balancing
            • View the configurations of a scheduled partition balancing task
            • View the trigger history of scheduled partition balancing tasks
            • View background partition balancing tasks
            • View the history of background partition balancing tasks
          • GTS exclusive application case
      • Object storage management
        • Object storage overview
        • Update object storage information
        • Object storage-related views and parameters
        • FAQ on object storage
      • LogService management
        • LogService parameters
        • LogService operations
          • View a LogService node
          • Add a LogService node
          • Delete a LogService node
          • Replace a LogService node
          • Rotate LogService access credentials
          • View LogService parameters
          • Modify LogService parameters
        • LogService load balancing
          • LogService load balancing overview
          • View the load balancing status
          • Configure the load balancing strategy
    • Manage tenants
      • Tenant introduction
      • Tenant capacity
      • Tenant types
      • User tenant introduction
      • Tenant system variables
      • Common tenant operations
        • Create a tenant
        • Resource isolation
          • Resource isolation overview
          • Configure cgroup
          • Configure global CPU resource isolation for foreground and background tasks
          • Calibrate disk performance
          • Configure resource isolation within a tenant
          • Update a plan directive
          • Delete a plan directive
          • Delete a resource management plan
          • Delete a resource group
          • Clear cgroup configurations
          • Resource isolation configuration examples for background tasks
        • View tenant and resource information
        • View and set the tenant allowlist
        • View tenant system variables
        • Modify tenant system variables
        • Scale in/out
          • Introduction to tenant scaling
          • Resource planning for tenant scaling
          • Tenant pre-scaling
          • Scale tenants by adjusting resource specifications
          • Scale tenants by adjusting the unit number
          • Scale tenants by adjusting the primary zone
          • Smooth scaling application scenarios
        • Modify attributes of a resource pool
        • Modify tenant attributes
        • Lock and unlock a tenant
        • Drop a tenant
        • Restore a tenant
        • Rename a tenant
        • Manage resource pools
          • View resource pools
          • Allocate a resource pool to a tenant
          • Remove resource pools from a tenant
          • Merge and split a resource pool
          • Drop a resource pool
        • Manage resource specifications
          • View resource specifications
          • Modify a unit config
          • Drop a unit config
    • Manage log streams
      • Create a log stream
      • Modify a log stream
    • Manage replicas
      • Replicas
      • Replica distribution
        • Locality
        • Common locality operations
          • View locality
          • Modify locality
          • Add a replica
          • Reduce replicas
          • Adjust the distribution of replicas
          • View the locality change history
          • Replica migration
          • Modify the quorum size of a log stream
          • Cancel a replica task
      • Traffic distribution
      • Data distribution
    • High availability
      • High availability overview
      • Multi-replica disaster recovery
        • Data link introduction
        • High availability at the proxy layer
        • High availability at the database layer
        • Disaster recovery deployment solutions
      • Manage recycle bin
        • Overview of the recycle bin
        • Enable or disable the recycle bin
        • View recycle bin objects
        • Restore objects from the recycle bin
        • Clean up the recycle bin
      • Flashback query
    • Security and permissions
      • Overview of security permissions
      • Identification and authentication
        • Identity authentication
          • Identity authentication
          • Password complexity
          • Handle login failures
      • Access control
        • Overview of access control
        • Users and permissions
          • User and permission overview
          • Permissions
            • Permission classification
            • Create a user
            • Grant privileges directly
            • Privilege delegation
            • Role management
              • Role management overview
              • Create a role
              • Add privileges to a role
              • Grant roles to users or other roles
              • Activate a role
              • View roles
              • Revoke privileges from a role
              • Revoke roles from a user or role
              • Drop a role
            • Indirect authorization
            • View user privileges
            • Revoke privileges
            • Lock or unlock a user
            • Drop a user
        • Row-level security
          • Row-level security
        • Network security access control
        • RPC connection authentication
      • Data encryption
        • Data encryption overview
        • Data transmission encryption
          • Overview of data transmission encryption
          • Transport encryption for OBServer
          • ODP transmission encryption
        • Tenant master key management
          • Overview of tenant master keys
          • Generate tenant master key
        • Data storage encryption
          • Overview of database transparent encryption
          • Set up transparent data encryption for a newly created table
          • Enable transparent data encryption for an existing table
          • Decrypt a table
        • Column encryption
          • Column encryption overview
          • Create a column encryption rule
          • Column encryption privilege management
          • FAQ on column encryption
      • Security audit
        • Security audit overview
        • Security audit
          • Enable security auditing
          • Set an auditing rule
          • View auditing records
          • Disable security auditing
    • Backup and restore
      • Overview of physical backup and restore
      • Physical backup and restore with a minimal experience
      • Log archive
        • Overview of log archiving
        • Prepare for log archiving
        • Enable archiving mode
        • Suspend archiving
        • Disable archiving mode
        • View piece information
        • View archiving progress
        • View the archiving history
        • View archive parameters
        • Change the archive destination
        • Clear the archive path configuration
        • Introduction to log archiving views
      • Data backup
        • Data backup overview
        • Prepare for backup
        • Initiate a full data backup
        • Back up parameters
        • Stop a backup
        • View the data backup progress
        • View data backup results
        • View data backup parameters
        • Change the backup destination
        • Introduction to data backup-related views
      • Update object storage key information
      • Clear backup data
        • Automatic backup cleanup
          • Automatically clean up expired backups
          • Delete a cleanup policy
        • Manual backup cleanup
          • Manually trigger expired backup cleanup
          • Manually clean up specified backup or archive data
          • Manually clear a backup or archive path
        • Cancel a cleanup task
        • View backup cleanup progress
        • View backup cleanup results
        • Introduction to backup cleanup parameters
        • Introduction to cleanup-related views
      • Restore data
        • Preparations before restore
        • Perform physical restore
        • Restore from a specified path
        • Cancel physical restore
        • View the physical restore progress
        • View the result of physical restore
        • Segment-based log replay for a standby tenant
        • Convert a standby tenant into a primary tenant
        • Upgrade a tenant after restore is complete
        • Introduction to physical restore parameters
        • Introduction to views related to physical restore
      • Backup and restore performance tuning
      • Appendix: S3 path format
    • Monitor
      • Monitoring overview
      • Metrics
        • System monitoring
          • Overview of system monitoring metrics
          • SYSSTAT metrics
          • Wait events
          • Lock events
        • SQL monitoring
          • Overview of SQL monitoring
          • SQL audit
          • Execution plans
      • Root service events
      • Cases
    • Logs
      • Log overview
      • Log levels
      • Log interpretation
      • Log stability
      • Log control methods
      • Log compression and decompression
      • Log monitoring metrics
      • Alert logs
      • View logs
        • Search for the logs of a specific SQL request
        • Query the log of a previous SQL request by using the SQL Trace feature
  • Performance Test
    • TPC-DS
      • OceanBase AI Database TPC-DS test
      • OceanBase AI Database TPC-DS test report
    • TPC-H
      • OceanBase AI Database TPC-H test
      • OceanBase AI Database TPC-H test report
  • Reference
    • System management
      • Configuration management
        • Introduction to Configuration Management
        • Set parameters
        • Set variables
      • Storage management
        • Minor compaction management
          • Overview of minor compaction
          • Automatic minor compaction
          • Manually trigger a minor compaction
          • View minor compaction information
          • Modify minor compaction settings
        • Major compaction management
          • Overview of major compaction management
          • Automatically trigger a major compaction
          • Schedule daily tenant major compactions
          • Window compaction
          • Adaptive compaction
          • Manually trigger a major compaction
          • View major compaction information
          • Manually control a major compaction
          • Modify major compaction configuration
        • Data compression
          • Data compression overview
          • Use data encoding and compression
        • Use the TTL feature
        • Custom hot and cold data storage policies
          • Overview of custom hot/cold storage policies
          • Create a table-level hot/cold storage policy
          • Create a partition-level hot/cold storage policy
          • Modify a table-level hot/cold storage policy
          • Modify a partition-level hot/cold storage policy
          • O&M guide for custom hot/cold storage policies
      • Memory management
        • Memory management overview
        • Memory structure
        • Set the maximum memory for a database
        • Internal system memory management
        • Memory management within a tenant
        • Plan cache memory management
        • Memleak-based regular memory leak diagnostics mechanism
        • View memory usage information
        • Common memory issues
      • Process management
        • Overview of OceanBase AI Database threads
        • Multi-tenant threads
        • View thread status
        • Background threads of OceanBase AI Database
        • FAQ about multi-tenant threads
      • Disk management
        • Configure dynamic expansion of disk data files
        • View disk space usage of a tenant or table
    • Database object management
      • Overview of database object management
      • Create and manage databases
        • Create a database
        • View databases
        • Modify a database
        • Drop a database
      • Create and manage tables
        • About tables
        • Create a table
        • Column Skip Index attribute
        • Define an auto-increment column
        • Define column constraints
        • View tables
        • Modify a table
        • Change the attribute of a replicated table
        • Truncate a table
        • Drop a table
        • Lock a table
        • Create and manage external tables
          • External tables and external files
          • Create and query external tables
          • Create a partitioned external table
          • Manage external files
          • Data type mappings
      • Create and manage partitions
        • Partitioning overview
        • Create a partitioned table
        • Partition splitting
          • Overview of partition splitting
          • Manually split a partition
          • Automatic partition splitting
          • Recommended configurations for automatic partitioning
        • Dynamic partitioning
          • Overview of dynamic partitioning
          • Create a dynamic partitioned table
          • View a dynamic partitioned table
          • Modify a dynamic partitioned table
          • Dynamic partition management tasks
        • Modify partitioning rules
        • Add a partition
        • Drop a partition
        • Truncate partitions
        • Partition pruning
        • Query data from a specified partition
        • Create indexes on partitioned tables
          • Index overview
          • Local index
          • Global index
        • Partition exchange
      • Create and manage table groups
        • About table groups
        • Create a table group
        • View table group information
        • Add tables to a table group
        • Modify the SHARDING attribute of a table group
        • Manage tables within a table group
        • Delete a table group
      • Create and manage indexes
        • About indexes
        • Create an index
        • View indexes
        • Monitor indexes
        • Drop an index
        • List of system functions supported for function-based indexes
        • List of system functions not supported for function-based indexes
      • Manage views
        • Manage regular views
        • Manage materialized views
          • Overview of materialized views
          • Materialized view logs
          • Create a materialized view
          • Refresh a materialized view
          • Query rewrite using materialized views
          • Query materialized views
          • Modify materialized view attributes
          • Drop a materialized view
          • Materialized view resource isolation
      • Create and manage sequences
        • Create a sequence
        • View sequences
        • Reference a sequence
        • Modify a sequence
        • Drop a sequence
      • Create and manage triggers
        • Overview
        • Create a DML trigger
        • View trigger information
        • Drop a trigger
      • Create and manage DBLinks
        • Create a DBLink
        • View created DBLinks
        • Manage DBLinks
        • Access data in a remote database through DBLink
        • Drop a DBLink
      • Create and manage catalogs
        • Overview of Catalog
        • Create a catalog
        • View catalogs
        • Drop a catalog
    • Write and read data
      • Write data
        • Insert data
        • Update data
        • Delete data
        • Replace data
        • Generate test data in batches
      • Read data
        • Single-table query
        • Join tables
          • INNER JOIN
          • FULL JOIN
          • LEFT JOIN
          • RIGHT JOIN
          • Subqueries
          • Lateral derived table
        • Use operators and functions in queries
          • Use arithmetic operators in queries
          • Use numeric functions in queries
          • Use string concatenation operators in queries
          • Use string functions in queries
          • Use time functions in queries
          • Use type conversion functions in queries
          • Use aggregate functions in queries
          • Use NULL-related functions in queries
          • Use the CASE conditional operator in queries
          • Lock query results with SELECT FOR UPDATE
          • Lock in share mode
          • Use regular expressions in queries
        • Query using DBLink
        • Set operations
    • Transaction management
      • Transaction management overview
      • Start a transaction
      • Savepoints
        • Mark a savepoint
        • Roll back a transaction to a savepoint
        • Release a savepoint
      • Commit a transaction
      • Roll back a transaction
    • AI Function service
      • Overview of AI Function Service
      • Get started with AI Function Service
      • AI Function Service Permissions
      • Register an AI model
      • Interaction with AI models (Batch File)
      • Syntax and examples of AI functions
      • View AI model information
    • SQL reference
      • SQL syntax
        • System tenants
          • Overview of management commands
          • ALTER SYSTEM
            • ACTIVATE STANDBY
            • ADD REPLICA
            • ADD RESTORE SOURCE
            • ARCHIVELOG
            • BOOTSTRAP
            • BACKUP KEY
            • BACKUP
            • BACKUP CLUSTER PARAMETERS
            • BALANCE TASK
            • BALANCE JOB
            • CANCEL BACKUP
            • CANCEL DELETE BACKUP
            • CANCEL MIGRATE UNIT
            • CANCEL REPLICA TASK
            • CANCEL RESTORE
            • CANCEL RECOVER TABLE
            • CANCEL TRANSFER PARTITION
            • CREATE LS
            • CLEAR RESTORE SOURCE
            • DELETE BACKUP POLICY
            • DELETE BACKUP ALL
            • DELETE BACKUPSET/ARCHIVELOG_PIECE
            • DELETE OBSOLETE BACKUP
            • LOAD MODULE DATA
            • MAJOR AND MINOR
            • MIGRATE REPLICA
            • MIGRATE UNIT
            • MODIFY LS
            • MODIFY PAXOS_REPLICA_NUM
            • MODIFY REPLICA
            • NOARCHIVELOG
            • FLUSH PLAN CACHE
            • FLUSH SEQUENCE CACHE
            • FLUSH LOCAL_CACHE
            • FLASHBACK STANDBY LOG
            • JOB
            • SET LOG_RESTORE_SOURCE
            • PARAMETER
            • RECOVER STANDBY
            • RECOVER STANDBY CANCEL
            • REMOVE REPLICA
            • REFRESH
            • RESTORE
            • RESTORE PREVIEW
            • SET DATA_BACKUP_DEST
            • SERVER
            • SERVICE_NAME
            • SWITCHOVER
            • SET LOG_ARCHIVE_DEST
            • SET LOG_ARCHIVE_DEST_STATE
            • THROTTLE
            • TRANSFER PARTITION
            • TTL
            • WASH MEMORY FRAGMENTATION
            • ZONE
          • ALTER RESOURCE POOL
          • ALTER RESOURCE TENANT
          • ALTER RESOURCE UNIT
          • ALTER TENANT
          • CREATE RESOURCE POOL
          • CREATE RESOURCE UNIT
          • CREATE TENANT
          • DROP RESOURCE POOL
          • DROP RESOURCE UNIT
          • DROP TENANT
          • SET DECRYPTION
          • SET ENCRYPTION
          • SHOW RESTORE PREVIEW
        • User tenants
          • Basic elements
            • ROWID Pseudo-Column
            • Data types
              • Overview of data types
              • Numeric types
                • Overview of numeric types
                • Integer types
                • Fixed-point types
                • Floating-point types
                • BIT-Value type
              • Datetime types
                • Overview of date and time types
                • DATE, DATETIME and TIMESTAMP types
                • TIME type
                • YEAR type
              • String types
                • Character type overview
                • CHAR and VARCHAR
                • BINARY and VARBINARY
              • Large objects and text types
                • Overview of LOB and text types
                • BLOB type
                • TEXT type
                • STRING type
                • LOB types
                • LOB_WRITEAPPEND
              • Enumeration types
              • Collection types
              • JSON data types
                • Overview of the JSON data type
                • Create a JSON value
                • Query and modify JSON values
                • JSON data type conversion
                • Update partial data in a JSON document
                • Semi-structured encoding
              • Spatial data types
                • Overview of spatial data types
                • Spatial Reference System (SRS)
                • Create a spatial column
                • Create a spatial index
                • Spatial data formats
              • Roaring bitmap types
                • Overview of Efficient Compression for Bitmap Data Types
                • Create an efficient compressed bitmap column
              • Array data types
                • Overview of Array Element Types
                • Create an array column
              • Map data types
                • Overview of mapped data types
                • Create a mapped column
            • Expressions
              • Overview of Expressions
              • Syntax of Expressions
              • Simple Expressions
              • Compound Expressions
              • Conditional Expressions
              • Column Expressions
              • Date and time expressions
              • Function Expressions
              • Interval Expressions
              • Scalar subquery expressions
              • List of Expressions
              • Data type conversion rules
            • Character set and collation
              • Overview
              • Character sets
              • Collation
              • Database-level character set and collation
              • Table-level character set and collation
              • Column-level character set and collation
              • Character expression character sets and collations
              • Character set and collation of client connections
            • Literals
              • Overview of Literals
              • String text
              • Numbers
              • Date and time values
              • Bit value
              • Boolean values
              • NULL values
            • Schema object name
            • User-defined variables
            • Annotations
              • Hints
                • Overview of hints
                • Control query optimization using the Query Block Name and QB_NAME hint
                • Hint list
                  • Global hints
                    • Optimizer Stats Hint under Global Hint Types
                    • Transform hint under global hints
                    • Other hints under global hints
                  • Optimizer hints
                    • Access path hints under the Optimized hint type
                    • Join Order Hint under Optimized Hint Type
                    • Join Operation Hint under Optimized Hint Type
                    • Subquery hint under Optimized hint type
                    • Group by hint under optimized hint type
                    • DISTINCT hint under Optimized hint type
                    • Set hint under Optimized hint type
                    • Distributed DML Hints under Optimized Hint Type
                    • Vector Index Hint under Optimized Hint Type
                  • Transform hints
                    • Stmt Transform Hint under the Transform Hint Type
                    • Cost Based Transform Hint under the Transform Hint Type
                    • Transform Hints of the Heuristics Type
                    • Other hints under the Transform hint type
                  • Outline-related hint
            • Comments
          • Operators
            • Operator overview
            • Operator precedence
            • Arithmetic operators
            • Bitwise operators
            • Comparison operators
            • Logical operators
            • Assignment operators
            • Date and time operators
            • Character concatenation operators
            • BINARY conversion operator
            • CASE Conditional Operator
          • Functions
            • Function overview
            • Single-row functions
              • Datetime functions
                • ADDDATE
                • CONVERT_TZ
                • CURDATE
                • CURRENT_DATE
                • CURRENT_TIME
                • CURRENT_TIMESTAMP
                • CURTIME
                • DATE
                • DATE_ADD
                • DATE_FORMAT
                • DATE_SUB
                • DATEDIFF
                • DAYOFMONTH
                • DAYOFWEEK
                • DAYOFYEAR
                • EXTRACT
                • FROM_DAYS
                • FROM_UNIXTIME
                • GET_FORMAT
                • HOUR
                • LAST_DAY
                • LOCALTIME
                • LOCALTIMESTAMP
                • MAKEDATE
                • MAKETIME
                • MICROSECOND
                • MINUTE
                • MONTH
                • MONTHNAME
                • NOW
                • PERIOD_ADD
                • PERIOD_DIFF
                • QUARTER
                • SEC_TO_TIME
                • SECOND
                • STR_TO_DATE
                • SUBDATE
                • SUBTIME
                • SYSDATE
                • TIME
                • TIME_FORMAT
                • TIME_TO_SEC
                • TIME_TO_USEC
                • TIMEDIFF
                • TIMESTAMP
                • TIMESTAMPADD
                • TIMESTAMPDIFF
                • TO_DAYS
                • TO_SECONDS
                • UNIX_TIMESTAMP
                • USEC_TO_TIME
                • UTC_DATE
                • UTC_TIME
                • UTC_TIMESTAMP
                • WEEK
                • WEEKDAY
                • WEEKOFYEAR
                • YEARWEEK
                • YEAR
                • ADDTIME
                • DAYNAME
                • DAY
                • DATE_TRUNC
                • MONTHS_ADD
                • FORMATDATETIME
                • TOUNIXTIMESTAMP
                • parseDateTime
              • String functions
                • ASCII
                • BIN
                • BIT_LENGTH
                • CHAR
                • CHAR_LENGTH
                • CHARACTER_LENGTH
                • CONCAT
                • CONCAT_WS
                • ELT
                • EXPORT_SET
                • FIELD
                • FIND_IN_SET
                • FORMAT
                • HEX
                • INSERT
                • INSTR
                • INT2IP
                • IP2INT
                • KEYVALUE
                • LCASE
                • LEFT
                • LENGTH
                • LOCATE
                • LOWER
                • LPAD
                • LTRIM
                • MAKE_SET
                • MAX_PT
                • MD5_CONCAT_WS
                • MID
                • OCT
                • OCTET_LENGTH
                • ORD
                • POSITION
                • QUOTE
                • REGEXP
                • REGEXP_INSTR
                • REGEXP_LIKE
                • REGEXP_REPLACE
                • REGEXP_SUBSTR
                • REPEAT
                • REPLACE
                • REVERSE
                • RIGHT
                • RLIKE
                • RPAD
                • RTRIM
                • SPACE
                • SPLIT_PART
                • STRCMP
                • SUBSTR
                • SUBSTRING
                • SUBSTRING_INDEX
                • TRIM
                • UCASE
                • UNHEX
                • UPPER
                • URL_DECODE
                • URL_ENCODE
                • WEIGHT_STRING
                • TO_BASE64
                • FROM_BASE64
                • SOUNDEX
                • EDITDISTANCE
              • Conversion functions
                • CAST
                • CONVERT
                • DECODE_TRACE_ID
                • SCN_TO_TIMESTAMP
                • TIMESTAMP_TO_SCN
                • TO_CHAR(character)
                • TO_CHAR(number)
                • TO_CHAR(datetime)
                • TO_DATE
              • Mathematical functions
                • ABS
                • ACOS
                • ASIN
                • ATAN
                • ATAN2
                • BIT_COUNT
                • CEIL
                • CEILING
                • CONV
                • COS
                • COT
                • CRC32
                • DEGREES
                • EXP
                • FLOOR
                • GENERATOR
                • LN
                • LOG
                • LOG10
                • LOG2
                • MOD
                • NEG
                • PI
                • NORMAL
                • POW
                • POWER
                • RADIANS
                • RAND
                • RANDOM
                • RANDSTR
                • ROUND
                • SIGN
                • SIN
                • SQRT
                • TAN
                • TRUNCATE
                • UNIFORM
                • ZIPF
              • Comparison functions
                • GREATEST
                • INTERVAL
                • ISNULL
                • LEAST
              • Process control functions
                • CASE
                • IF
                • IFNULL
                • NULLIF
                • ORA_DECODE
            • Aggregate functions
              • APPROX_COUNT_DISTINCT
              • AVG
              • ARG_MAX
              • ARG_MIN
              • BIT_AND
              • BIT_OR
              • BIT_XOR
              • COUNT
              • GROUP_CONCAT
              • GROUPING
              • MAX
              • MIN
              • STD
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
              • STRING_AGG
              • AVG_WEIGHTED
              • ARBITRARY
              • ANY
              • GROUPCONCAT
              • STDDEVSAMP
              • UNIQ
              • VARSAMP
            • Analysis functions
              • APPROX_COUNT_DISTINCT
              • AVG
              • BIT_AND
              • BIT_OR
              • BIT_XOR
              • COUNT
              • CUME_DIST
              • DENSE_RANK
              • FIRST_VALUE
              • LAG
              • LAST_VALUE
              • LEAD
              • MAX
              • MIN
              • NTH_VALUE
              • NTILE
              • PERCENT_RANK
              • PERCENTILE_CONT
              • RANK
              • ROW_NUMBER
              • STD
              • STDDEV
              • STDDEV_POP
              • STDDEV_SAMP
              • SUM
              • VAR_POP
              • VAR_SAMP
              • VARIANCE
              • LAGINFRAME
              • LEADINFRAME
            • Encryption functions
              • AES_DECRYPT
              • AES_ENCRYPT
              • COMPRESS
              • DECODE
              • DES_DECRYPT
              • DES_ENCRYPT
              • ENCODE
              • ENCRYPT
              • ENHANCED_AES_ENCRYPT
              • ENHANCED_AES_DECRYPT
              • MD5
              • PASSWORD
              • UNCOMPRESS
              • UNCOMPRESSED_LENGTH
              • RANDOM_BYTES
              • SHA
              • SHA1
              • SHA2
              • VALIDATE_PASSWORD_STRENGTH
              • SM3
              • SM4_ENCRYPT
              • SM4_DECRYPT
            • Information functions
              • BENCHMARK
              • CATALOG
              • CHARSET
              • COERCIBILITY
              • COLLATION
              • CONNECTION_ID
              • CURRENT_ROLE
              • CURRENT_USER
              • DATABASE
              • FOUND_ROWS
              • LAST_INSERT_ID
              • LAST_INSERT_ID Behavior Description
              • ICU_VERSION
              • OB_TRANSACTION_ID
              • ROW_COUNT
              • SCHEMA
              • SESSION_USER
              • SYSTEM_USER
              • USER
              • VERSION
              • OB_VERSION
            • JSON functions
              • Overview of JSON functions
              • Functions for creating JSON text
                • JSON_ARRAY
                • JSON_OBJECT
                • JSON_QUOTE
              • Functions for searching JSON text
                • JSON_CONTAINS
                • JSON_CONTAINS_PATH
                • JSON_EXTRACT
                • JSON_KEYS
                • JSON_OVERLAPS
                • JSON_SEARCH
                • JSON_VALUE
                • MEMBER OF
              • Functions for modifying JSON text
                • JSON_ARRAY_APPEND
                • JSON_APPEND
                • JSON_ARRAY_INSERT
                • JSON_INSERT
                • JSON_MERGE
                • JSON_MERGE_PATCH
                • JSON_MERGE_PRESERVE
                • JSON_REMOVE
                • JSON_REPLACE
                • JSON_SET
                • JSON_UNQUOTE
              • Functions for returning JSON text properties
                • JSON_DEPTH
                • JSON_LENGTH
                • JSON_TYPE
                • JSON_VALID
              • JSON_TABLE function
              • JSON utility functions
                • JSON_PRETTY
                • JSON_STORAGE_SIZE
              • JSON aggregate functions
                • JSON_ARRAYAGG
                • JSON_OBJECTAGG
              • JSON schema validation functions
                • JSON_SCHEMA_VALID
                • JSON_SCHEMA_VALIDATION_REPORT
            • XML functions
              • Overview of XML functions
              • Functions for querying XML data
                • EXTRACTVALUE
              • Functions for modifying XML data
                • UPDATEXML
            • Table functions
              • Overview of TABLE FUNCTIONS
              • FILES table function
            • Spatial functions
              • Overview of Spatial Functions
              • Create a geometric value function
              • Spatial operators
              • Spatial relationship functions
              • Geometric property functions
              • Geometric format conversion functions
              • Spatial analysis functions
              • Spatial Constructors
              • Spatial accessor functions
              • Spatial format conversion functions
              • Geometric Processing Functions
              • _ST_GeoHash
            • Performance schema functions
              • FORMAT_BYTES
              • FORMAT_PICO_TIME
            • Lock functions
              • Overview of Lock Functions
              • GET_LOCK
              • IS_FREE_LOCK
              • IS_USED_LOCK
              • RELEASE_ALL_LOCKS()
              • RELEASE_LOCK
            • Bitmap functions
              • Overview of bitmap functions
              • Bitmap Constructor
              • Bitmap cardinality functions
              • Bitmap arithmetic functions
              • Bitmap predicate functions
              • Bitmap output functions
              • Bitmap aggregate functions
            • Array functions
              • Overview of array functions
              • Array constructor
              • Array comparison functions
              • Array output functions
              • Array functions
            • Text processing functions
              • TOKENIZE
            • Audit functions
              • Overview of audit functions
              • AUDIT_LOG_FILTER_REMOVE_FILTER
              • AUDIT_LOG_FILTER_REMOVE_USER
              • AUDIT_LOG_FILTER_SET_FILTER
              • AUDIT_LOG_FILTER_SET_USER
            • Map functions
              • Overview of mapping functions
              • Constructor of Map
              • Mapping judgment function
              • Mapping functions
            • Other functions
              • ANY_VALUE
              • BIN_TO_UUID
              • COALESCE
              • DEFAULT
              • NAME_CONST
              • INET_ATON
              • INET_NTOA
              • INET6_ATON
              • INET6_NTOA
              • IS_IPV4
              • IS_IPV4_COMPAT
              • IS_IPV6
              • IS_UUID
              • MATCH AGAINST
              • NVL
              • UUID_TO_BIN
              • SLEEP
              • UUID
              • UUID_SHORT
              • VALUES
              • ISNAN
          • Queries and subqueries
            • Overview
            • Subquery
            • Connections
            • Full-text query
          • SQL statements
            • General syntax
            • Generalized Table Expressions
            • ALTER COMPILE
            • ALTER DATABASE
            • ALTER LOCATION
            • ALTER MATERIALIZED VIEW
            • ALTER MATERIALIZED VIEW LOG
            • ALTER OUTLINE
            • ALTER EXTERNAL TABLE
            • ALTER SENSITIVE RULE
            • ALTER POLICY
            • ALTER SEQUENCE
            • ALTER/CHANGE/MODIFY EXTERNAL_STORAGE_DEST
            • ALTER SYSTEM FLUSH SEQUENCE CACHE
            • MAJOR AND MINOR
            • STORAGE_CACHE_POLICY_EXECUTOR
            • ALTER TABLE
            • ALTER TABLEGROUP
            • ALTER TABLESPACE
            • ALTER USER
            • ALTER VIEW
            • ALTER INSTANCE ROTATE INNODB MASTER KEY
            • ALTER EVENT
            • ANALYZE
            • CACHE INDEX
            • CREATE CONCURRENT_LIMITING_RULE
            • CREATE DATABASE
            • CREATE DATABASE LINK
            • CREATE EXTERNAL CATALOG
            • CREATE EXTERNAL TABLE
            • CREATE INDEX
            • CREATE LOCATION
            • CREATE MATERIALIZED VIEW
            • CREATE MATERIALIZED VIEW LOG
            • CREATE OUTLINE
            • CREATE POLICY
            • CREATE FORMAT OUTLINE
            • CREATE ROLE
            • CREATE SENSITIVE RULE
            • CREATE SEQUENCE
            • CREATE TABLE
            • CREATE TABLEGROUP
            • CREATE TABLESPACE
            • CREATE USER
            • CREATE VIEW
            • CHECKSUM TABLE
            • CREATE EVENT
            • DEALLOCATE PREPARE
            • DROP DATABASE LINK
            • DELETE
            • DESCRIBE
            • DROP CATALOG
            • DROP CONCURRENT_LIMITING_RULE
            • DROP DATABASE
            • DROP EVENT
            • DROP INDEX
            • DROP LOCATION
            • DROP MATERIALIZED VIEW
            • DROP MATERIALIZED VIEW LOG
            • DROP OUTLINE
            • DROP ROLE
            • DROP SENSITIVE RULE
            • DROP POLICY
            • DROP TABLE
            • DROP TABLEGROUP
            • DROP TABLESPACE
            • DROP SEQUENCE
            • DROP USER
            • DROP VIEW
            • EXECUTE
            • EXPLAIN
            • FLASHBACK
            • FLUSH TABLE
            • GRANT
            • HELP
            • INSERT
            • KILL
            • LOAD DATA
            • LOAD_FILE
            • LOAD INDEX INTO CACHE
            • LOCK TABLES
            • OPTIMIZE
            • PREPARE
            • PURGE
            • PURGE RECYCLEBIN
            • RENAME USER
            • RENAME TABLE
            • REPLACE
            • REPAIR TABLE
            • REMOVE
            • REVOKE
            • SAVEPOINT
            • SCHEMA
            • SELECT INTO
            • SET DEFAULT ROLE
            • SELECT
              • SELECT
              • JOIN clause
              • WINDOW clause
              • UNION clause
              • HYBRID_SEARCH
              • PARTITION TIER
            • SET
            • SET CATALOG
            • SET CHARSET
            • SET NAMES
            • SET PASSWORD
            • SET ROLE
            • SET TRANSACTION
            • SHOW
            • SUBMIT JOB
            • SHOW JOB STATUS
            • CANCEL JOB
            • TRANSACTION
            • TRUNCATE TABLE
            • UNLOCK TABLES
            • UPDATE
            • USE
            • VALUES
            • XA TRANSACTION
          • DDL feature
            • Overview of DDL features
            • Online DDL and Offline DDL Operations
            • Index operations
            • Primary key operations
            • Column operations
            • Generate columns
            • Foreign key operations
            • Table operations
            • Partition operations
            • Column type change rules
            • Number type conversion rules
          • Pseudo columns
            • Overview of PseudoColumns
            • PARTITIONID Pseudo Column
            • Sequence Pseudocolumns
          • Conditions
            • Overview of SQL Conditions
            • Condition priorities
            • Comparison conditions
            • Logical conditions
            • Pattern matching conditions
            • Null value conditions
            • BETWEEN condition
            • EXISTS condition
            • IN Condition
            • JSON Member Conditions
            • Boolean test conditions
      • SQL specifications and practices
        • SQL Writing Restrictions
        • SQL writing specifications
          • SELECT statement writing specifications
          • DML statement writing guidelines
          • DDL statement writing guidelines
          • Multi-table association guidelines
          • Table scan method specifications
          • Transaction specifications
          • Usage guidelines for cache
          • Guidelines for Using HINTS
          • Other related specifications
        • SQL statement examples
          • Implicit type conversion related
          • Suggestions on using JOIN tables
          • Weak-consistency read
          • Paginated query
      • Reserved keywords
      • Data type conversion behavior in strict mode
    • PL reference
      • What is PL
        • PL Overview
        • Key features of PL
        • Architecture of PL
      • PL syntax structure
      • PL stored procedures
        • Overview of stored programs
        • Variables of stored programs
        • Stored procedure
        • Stored Procedures and Privilege Management
        • Stored functions
        • External storage functions
        • Trigger
        • EVENT
        • Limitations on stored programs
        • SQL Transpiler
        • PL asynchronous commit optimization
      • PL cursors
        • Cursor overview
        • Cursor execution process
        • Limitations on server-side cursors
      • PL conditional control statements
        • CASE
        • IF
        • ITERATE
        • LEAVE
        • LOOP
        • REPEAT
        • RETURN
        • WHILE
      • PL data manipulation statements
        • CALL
        • DO
      • PL data definition statements
        • ALTER FUNCTION
        • ALTER PROCEDURE
        • CREATE FUNCTION
        • CREATE PROCEDURE
        • CREATE TRIGGER
        • DROP FUNCTION
        • DROP PROCEDURE
        • DROP TRIGGER
      • PL database management statements
        • SHOW CREATE FUNCTION
        • SHOW CREATE PROCEDURE
        • SHOW CREATE TRIGGER
        • SHOW FUNCTION STATUS
        • SHOW PROCEDURE STATUS
        • SHOW TRIGGERS
      • PL related dictionary views
        • INFORMATION_SCHEMA PARAMETERS
        • INFORMATION_SCHEMA ROUTINES
        • INFORMATION_SCHEMA TRIGGERS
      • PL exception handling
        • Overview of exception handling
        • DECLARE ... CONDITION
        • DECLARE ... HANDLER
        • GET DIAGNOSTICS
        • RESIGNAL
        • SIGNAL
        • Scope of handlers
        • Diagnostic section
        • Exception Handling and OUT/INOUT Parameters
        • Limitations on exception handling
      • PL system packages
        • Overview of system packages
        • DBMS_AI_SERVICE
          • Overview of DBMS_AI_SERVICE
          • CREATE_AI_MODEL
          • DROP_AI_MODEL
          • CREATE_AI_MODEL_ENDPOINT
          • ALTER_AI_MODEL_ENDPOINT
          • DROP_AI_MODEL_ENDPOINT
          • REGISTER_PROVIDER
          • ALTER_PROVIDER
          • UNREGISTER_PROVIDER
          • ALTER_MODEL_PROFILE
          • DROP_MODEL_PROFILE
          • CREATE_AI_GATEWAY
          • ALTER_AI_GATEWAY
          • DROP_AI_GATEWAY
        • DBMS_ASYNC_INDEX
          • Overview of DBMS_ASYNC_INDEX
          • FORCEMERGE
        • DBMS_DAILY_MAINTENANCE
          • Overview of DBMS_DAILY_MAINTENANCE
          • TRIGGER_WINDOW_COMPACTION_PROC
          • SET_THREAD_COUNT
        • DBMS_HYBRID_SEARCH
          • Overview of DBMS_HYBRID_SEARCH
          • SEARCH
          • GET_SQL
        • DBMS_MVIEW
          • Overview of DBMS_MVIEW
          • PURGE_LOG
          • REFRESH
          • KILL_REFRESH
          • REFRESH_REPORT
        • DBMS_MVIEW_STATS
          • Overview of DBMS_MVIEW_STATS
          • PURGE_REFRESH_STATS
          • SET_MVREF_STATS_PARAMS
          • SET_SYSTEM_DEFAULT
        • DBMS_PARTITION
          • Overview of DBMS_PARTITION
          • MANAGE_DYNAMIC_PARTITION
        • DBMS_RESOURCE_MANAGER
          • Overview of DBMS_RESOURCE_MANAGER
          • CREATE_CONSUMER_GROUP
          • CREATE_PLAN
          • CREATE_PLAN_DIRECTIVE
          • COPY_PLAN
          • DELETE_CONSUMER_GROUP
          • DELETE_PLAN
          • DELETE_PLAN_DIRECTIVE
          • System Packages
          • UPDATE_PLAN_DIRECTIVE
        • DBMS_STATS
          • Overview of DBMS_STATS
          • ALTER_STATS_HISTORY_RETENTION
          • CREATE_STAT_TABLE
          • DELETE_CATALOG_GLOBAL_PREFS
          • DELETE_CATALOG_TABLE_PREFS
          • DELETE_COLUMN_STATS
          • DELETE_INDEX_STATS
          • DELETE_TABLE_STATS
          • DELETE_SCHEMA_STATS
          • DELETE_SCHEMA_PREFS
          • DELETE_SYSTEM_STATS
          • DELETE_TABLE_PREFS
          • DROP_STAT_TABLE
          • EXPORT_COLUMN_STATS
          • EXPORT_INDEX_STATS
          • EXPORT_TABLE_STATS
          • EXPORT_SCHEMA_STATS
          • FLUSH_DATABASE_MONITORING_INFO
          • GATHER_CATALOG_TABLE_STATS
          • GATHER_INDEX_STATS
          • GATHER_TABLE_STATS
          • GATHER_SCHEMA_STATS
          • GATHER_SYSTEM_STATS
          • GET_CATALOG_GLOBAL_PREFS
          • GET_CATALOG_PREFS
          • GET_STATS_HISTORY_AVAILABILITY
          • GET_STATS_HISTORY_RETENTION
          • GET_PARAM
          • GET_PREFS
          • IMPORT_INDEX_STATS
          • IMPORT_COLUMN_STATS
          • IMPORT_TABLE_STATS
          • IMPORT_SCHEMA_STATS
          • LOCK_CATALOG_PARTITION_STAT
          • LOCK_CATALOG_TABLE_STAT
          • LOCK_PARTITION_STATS
          • LOCK_SCHEMA_STATS
          • LOCK_TABLE_STATS
          • RESTORE_TABLE_STATS
          • RESTORE_SCHEMA_STATS
          • RESET_GLOBAL_PREF_DEFAULTS
          • RESET_PARAM_DEFAULTS
          • PURGE_STATS
          • SET_CATALOG_GLOBAL_PREFS
          • SET_CATALOG_TABLE_PREFS
          • SET_COLUMN_STATS
          • SET_INDEX_STATS
          • SET_TABLE_STATS
          • SET_GLOBAL_PREFS
          • SET_PARAM
          • SET_SCHEMA_PREFS
          • SET_SYSTEM_STATS
          • SET_TABLE_PREFS
          • UNLOCK_CATALOG_PARTITION_STAT
          • UNLOCK_CATALOG_TABLE_STAT
          • UNLOCK_PARTITION_STATS
          • UNLOCK_SCHEMA_STATS
          • UNLOCK_TABLE_STATS
          • CANCEL_GATHER_STATS
          • COPY_TABLE_STATS
        • DBMS_TRUSTED_CERTIFICATE_MANAGER
          • Overview of DBMS_TRUSTED_CERTIFICATE_MANAGER
          • ADD_TRUSTED_CERTIFICATE
          • DELETE_TRUSTED_CERTIFICATE
          • UPDATE_TRUSTED_CERTIFICATE
        • DBMS_UDR
          • Overview of DBMS_UDR
          • CREATE_RULE
          • DISABLE_RULE
          • ENABLE_RULE
          • REMOVE_RULE
        • DBMS_VECTOR
          • Overview of DBMS_VECTOR
          • REBUILD_INDEX
          • INDEX_VECTOR_MEMORY_ESTIMATE
          • INDEX_VECTOR_MEMORY_ADVISOR
          • FLUSH_INDEX
          • COMPACT_INDEX
          • TRIGGER_ASYNC_TASK
          • ALTER_INDEX_PARAMS
        • DBMS_WORKLOAD_REPOSITORY
          • Overview of DBMS_WORKLOAD_REPOSITORY
          • ASH_REPORT
          • CREATE_SNAPSHOT
          • DROP_SNAPSHOT_RANGE
          • MODIFY_SNAPSHOT_SETTINGS
        • DBMS_SESSION
          • Overview of DBMS_SESSION
          • SET_IDENTIFIER
          • CLEAR_IDENTIFIER
        • DBMS_APPLICATION_INFO
          • Overview of DBMS_APPLICATION_INFO
          • READ_CLIENT_INFO
          • READ_MODULE
          • SET_ACTION
          • SET_CLIENT_INFO
          • SET_MODULE
        • DBMS_XPLAN
          • Overview of DBMS_XPLAN
          • DISPLAY_ACTIVE_SESSION_PLAN
          • DISPLAY_CURSOR
          • DISPLAY
          • DISABLE_OPT_TRACE
          • DISPLAY_SQL_PLAN_BASELINE
          • ENABLE_OPT_TRACE
          • SET_OPT_TRACE_PARAMETER
        • DBMS_XPROFILE
          • Overview of DBMS_XPROFILE
          • DISPLAY_PROFILE
        • DBMS_BALANCE
          • Overview of DBMS_BALANCE
          • SET_BALANCE_WEIGHT
          • CLEAR_BALANCE_WEIGHT
          • TRIGGER_PARTITION_BALANCE
          • SET_TABLEGROUP_BALANCE_WEIGHT
          • CLEAR_TABLEGROUP_BALANCE_WEIGHT
        • DBMS_OB_LIMIT_CALCULATOR
          • Overview of DBMS_OB_LIMIT_CALCULATOR
          • CALCULATE_MIN_PHY_RES_NEEDED_BY_UNIT
          • CALCULATE_MIN_PHY_RES_NEEDED_BY_LOGIC_RES
          • CALCULATE_MIN_PHY_RES_NEEDED_BY_STANDBY_TENANT
        • DBMS_EXTERNAL_TABLE
          • Overview of DBMS_EXTERNAL_TABLE
          • AUTO_REFRESH_EXTERNAL_TABLE
        • DBMS_JAVA
          • Overview of DBMS_JAVA
          • LOADJAVA
          • DROPJAVA
          • GRANT_PERMISSION
          • RESTRICT_PERMISSION
          • REVOKE_PERMISSION
          • DISABLE_PERMISSION
          • ENABLE_PERMISSION
          • DELETE_PERMISSION
        • DBMS_PYTHON
          • Overview of DBMS_PYTHON
          • DROPPYTHON
          • LOADPYTHON
        • DBMS_DATA_DICT
          • DBMS_DATA_DICT
      • Reserved and Non-Reserved PL Keywords
    • System views
      • Overview of system views
      • Overview of system views
      • SYS tenant views
        • Dictionary views
          • information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
          • information_schema.CHARACTER_SETS
          • information_schema.CHECK_CONSTRAINTS
          • information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
          • information_schema.COLLATIONS
          • information_schema.COLUMN_PRIVILEGES
          • information_schema.COLUMNS
          • information_schema.ENGINES
          • information_schema.events
          • information_schema.GLOBAL_STATUS
          • information_schema.GLOBAL_VARIABLES
          • information_schema.KEY_COLUMN_USAGE
          • information_schema.PARAMETERS
          • information_schema.PARTITIONS
          • information_schema.PROCESSLIST
          • information_schema.QUERY_RESPONSE_TIME
          • information_schema.REFERENTIAL_CONSTRAINTS
          • information_schema.role_table_grants
          • information_schema.role_column_grants
          • information_schema.role_routine_grants
          • information_schema.ROUTINES
          • information_schema.SCHEMA_PRIVILEGES
          • information_schema.SCHEMATA
          • information_schema.SESSION_STATUS
          • information_schema.SESSION_VARIABLES
          • information_schema.STATISTICS
          • information_schema.TABLE_CONSTRAINTS
          • information_schema.TABLE_PRIVILEGES
          • information_schema.TABLES
          • information_schema.TRIGGERS
          • information_schema.USER_PRIVILEGES
          • information_schema.VIEW_TABLE_USAGE
          • information_schema.VIEWS
          • mysql.columns_priv
          • mysql.db
          • mysql.default_roles
          • mysql.help_category
          • mysql.help_keyword
          • mysql.help_relation
          • mysql.help_topic
          • mysql.proc
          • mysql.procs_priv
          • mysql.role_edges
          • mysql.time_zone
          • mysql.time_zone_name
          • mysql.time_zone_transition
          • mysql.time_zone_transition_type
          • mysql.user
          • oceanbase.ALL_OB_EXTERNAL_TABLE_FILES
          • oceanbase.CDB_OB_DATABASE_PRIVILEGE
          • oceanbase.CDB_OB_SHARED_MACRO_BLOCK_GC_STAT
          • oceanbase.CDB_IND_COLUMNS
          • oceanbase.CDB_IND_PARTITIONS
          • oceanbase.CDB_IND_SUBPARTITIONS
          • CDB_INDEX_USAGE
          • oceanbase.CDB_INDEXES
          • CDB_MVIEW_LOGS
          • oceanbase.CDB_MVIEW_RUNNING_JOBS
          • CDB_MVIEWS
          • CDB_MVREF_CHANGE_STATS
          • CDB_MVREF_RUN_STATS
          • CDB_MVREF_STATS
          • CDB_MVREF_STATS_PARAMS
          • CDB_MVREF_STATS_SYS_DEFAULTS
          • CDB_MVREF_STMT_STATS
          • oceanbase.CDB_OB_ACCESS_POINT
          • oceanbase.CDB_OB_AI_BATCH_TASK_HISTORY
          • oceanbase.CDB_OB_AI_BATCH_TASKS
          • oceanbase.CDB_OB_AI_GATEWAY_ENDPOINTS
          • oceanbase.CDB_OB_AI_GATEWAYS
          • oceanbase.CDB_OB_AI_MODEL_ENDPOINTS
          • oceanbase.CDB_OB_AI_MODEL_PROFILES
          • oceanbase.CDB_OB_AI_MODEL_PROVIDERS
          • oceanbase.CDB_OB_AI_MODELS
          • oceanbase.CDB_OB_AGENT_DB_BACKGROUND_TASKS
          • oceanbase.CDB_OB_AGENT_DB_BACKGROUND_TASK_HISTORY
          • oceanbase.CDB_OB_ARCHIVE_DEST
          • oceanbase.CDB_OB_ARCHIVELOG
          • oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.CDB_OB_ARCHIVELOG_SUMMARY
          • oceanbase.CDB_OB_AUTO_INCREMENT
          • CDB_OB_AUX_STATISTICS
          • oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_DELETE_JOBS
          • oceanbase.CDB_OB_BACKUP_DELETE_POLICY
          • oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.CDB_OB_BACKUP_DELETE_TASKS
          • oceanbase.CDB_OB_BACKUP_JOB_HISTORY
          • oceanbase.CDB_OB_BACKUP_JOBS
          • oceanbase.CDB_OB_BACKUP_PARAMETER
          • oceanbase.CDB_OB_BACKUP_SET_FILES
          • oceanbase.CDB_OB_BACKUP_STORAGE_INFO
          • oceanbase.CDB_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.CDB_OB_BACKUP_TASK_HISTORY
          • oceanbase.CDB_OB_BACKUP_TASKS
          • oceanbase.CDB_OB_BALANCE_JOB_HISTORY
          • oceanbase.CDB_OB_BALANCE_JOBS
          • oceanbase.CDB_OB_BALANCE_TASK_HISTORY
          • oceanbase.CDB_OB_BALANCE_TASKS
          • oceanbase.CDB_OB_COLUMN_CHECKSUM_ERROR_INFO
          • oceanbase.CDB_OB_CCL_RULES
          • oceanbase.CDB_OB_CS_REPLICA_STATS
          • oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.CDB_OB_DATABASES
          • oceanbase.CDB_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.CDB_OB_DYNAMIC_PARTITION_TABLES
          • oceanbase.CDB_OB_EXTERNAL_TABLE_FILES
          • oceanbase.CDB_OB_FREEZE_INFO
          • oceanbase.CDB_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.CDB_OB_IMPORT_TABLE_JOBS
          • oceanbase.CDB_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.CDB_OB_IMPORT_TABLE_TASKS
          • oceanbase.CDB_OB_KV_TTL_TASK_HISTORY
          • oceanbase.CDB_OB_KV_TTL_TASKS
          • oceanbase.CDB_OB_LOG_RESTORE_SOURCE
          • oceanbase.CDB_OB_LOB_CHECK_EXCEPTION_RESULT
          • oceanbase.CDB_OB_LOB_CHECK_TASKS
          • oceanbase.CDB_OB_LS
          • oceanbase.CDB_OB_LS_HISTORY
          • oceanbase.CDB_OB_LS_LOCATIONS
          • oceanbase.CDB_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.CDB_OB_LS_REPLICA_TASKS
          • oceanbase.CDB_OB_LS_REPLICA_TASK_HISTORY
          • oceanbase.CDB_OB_MAJOR_COMPACTION
          • oceanbase.CDB_OB_OBJECT_BALANCE_WEIGHT
          • oceanbase.CDB_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.CDB_OB_RECOVER_TABLE_JOBS
          • oceanbase.CDB_OB_SERVICES
          • oceanbase.CDB_OB_RESTORE_HISTORY
          • oceanbase.CDB_OB_RESTORE_PROGRESS
          • oceanbase.CDB_OB_RSRC_DIRECTIVES
          • oceanbase.CDB_OB_SENSITIVE_COLUMNS
          • oceanbase.CDB_OB_SENSITIVE_RULE_PLAINACCESS_USERS
          • oceanbase.CDB_OB_SENSITIVE_RULES
          • oceanbase.CDB_OB_SERVER_SPACE_USAGE
          • oceanbase.CDB_OB_SPACE_USAGE
          • oceanbase.CDB_OB_STORAGE_SPACE_USAGE
          • oceanbase.CDB_OB_SYS_VARIABLES
          • oceanbase.CDB_OB_STORAGE_IO_USAGE
          • oceanbase.CDB_OB_SPM_EVO_RESULT
          • oceanbase.CDB_OB_TABLE_LOCATIONS
          • oceanbase.CDB_OB_TABLEGROUP_PARTITIONS
          • oceanbase.CDB_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.CDB_OB_TABLEGROUP_TABLES
          • oceanbase.CDB_OB_TABLEGROUPS
          • oceanbase.CDB_OB_TABLET_CHECKSUM_ERROR_INFO
          • oceanbase.CDB_OB_TABLET_REPLICAS
          • oceanbase.CDB_OB_TABLET_TO_LS
          • oceanbase.CDB_OB_TABLE_SPACE_USAGE
          • oceanbase.CDB_OB_TEMP_FILES
          • oceanbase.CDB_OB_TENANT_EVENT_HISTORY
          • oceanbase.CDB_OB_TENANT_FLASHBACK_LOG_SCN
          • oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS
          • oceanbase.CDB_OB_TRANSFER_PARTITION_TASK_HISTORY
          • oceanbase.CDB_OB_TRANSFER_TASK_HISTORY
          • oceanbase.CDB_OB_TRANSFER_TASKS
          • oceanbase.CDB_OB_TTL_TASKS
          • oceanbase.CDB_OB_TTL_TASK_HISTORY
          • oceanbase.CDB_OB_USERS
          • oceanbase.CDB_OB_VECTOR_INDEX_TASKS
          • oceanbase.CDB_OB_VECTOR_INDEX_TASK_HISTORY
          • oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.CDB_OBJECTS
          • oceanbase.CDB_PART_INDEXES
          • oceanbase.CDB_PART_KEY_COLUMNS
          • oceanbase.CDB_PART_TABLES
          • oceanbase.CDB_SCHEDULER_JOB_RUN_DETAILS
          • oceanbase.CDB_SUBPART_KEY_COLUMNS
          • oceanbase.CDB_SUBPARTITION_TEMPLATES
          • oceanbase.CDB_TAB_COL_STATISTICS
          • oceanbase.CDB_TAB_COLS
          • oceanbase.CDB_TAB_COLS_V$
          • oceanbase.CDB_TAB_PARTITIONS
          • oceanbase.CDB_TAB_SUBPARTITIONS
          • oceanbase.CDB_TABLES
          • oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.CDB_WR_CONTROL
          • oceanbase.CDB_WR_EVENT_NAME
          • oceanbase.CDB_WR_RES_MGR_SYSSTAT
          • oceanbase.CDB_WR_SNAPSHOT
          • oceanbase.CDB_WR_SQL_PLAN
          • oceanbase.CDB_WR_SQLSTAT
          • oceanbase.CDB_WR_SQLTEXT
          • oceanbase.CDB_WR_STATNAME
          • oceanbase.CDB_WR_SYS_TIME_MODEL
          • oceanbase.CDB_WR_SYSSTAT
          • oceanbase.CDB_WR_SYSTEM_EVENT
          • oceanbase.CDB_OB_EXTERNAL_RESOURCES
          • oceanbase.DBA_DB_LINKS
          • oceanbase.DBA_IND_PARTITIONS
          • oceanbase.DBA_IND_STATISTICS
          • oceanbase.DBA_IND_SUBPARTITIONS
          • oceanbase.DBA_INDEX_USAGE
          • oceanbase.DBA_MVIEW_DEPS
          • oceanbase.DBA_MVIEW_LOGS
          • oceanbase.DBA_MVIEW_RUNNING_JOBS
          • oceanbase.DBA_MVIEWS
          • oceanbase.DBA_MVREF_CHANGE_STATS
          • oceanbase.DBA_MVREF_RUN_STATS
          • oceanbase.DBA_MVREF_STATS
          • oceanbase.DBA_MVREF_STATS_PARAMS
          • oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS
          • oceanbase.DBA_MVREF_STMT_STATS
          • oceanbase.DBA_OB_ACCESS_POINT
          • oceanbase.DBA_OB_AI_BATCH_TASK_HISTORY
          • oceanbase.DBA_OB_AI_BATCH_TASKS
          • oceanbase.DBA_OB_AI_GATEWAY_ENDPOINTS
          • oceanbase.DBA_OB_AI_GATEWAYS
          • oceanbase.DBA_OB_AI_MODEL_ENDPOINTS
          • oceanbase.DBA_OB_AI_MODEL_PROFILES
          • oceanbase.DBA_OB_AI_MODEL_PROVIDERS
          • oceanbase.DBA_OB_AI_MODELS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASKS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY
          • oceanbase.DBA_OB_ARCHIVE_DEST
          • oceanbase.DBA_OB_ARCHIVELOG
          • oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
          • oceanbase.DBA_OB_AUTO_INCREMENT
          • DBA_OB_AUX_STATISTICS
          • oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_JOBS
          • oceanbase.DBA_OB_BACKUP_DELETE_POLICY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASKS
          • oceanbase.DBA_OB_BACKUP_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_JOBS
          • oceanbase.DBA_OB_BACKUP_PARAMETER
          • oceanbase.DBA_OB_BACKUP_SET_FILES
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASKS
          • oceanbase.DBA_OB_BALANCE_JOB_HISTORY
          • oceanbase.DBA_OB_BALANCE_JOBS
          • oceanbase.DBA_OB_BALANCE_TASK_HISTORY
          • oceanbase.DBA_OB_BALANCE_TASKS
          • oceanbase.DBA_OB_CLUSTER_EVENT_HISTORY
          • oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
          • oceanbase.DBA_OB_CCL_RULES
          • oceanbase.DBA_OB_CS_REPLICA_STATS
          • oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.DBA_OB_DATABASE_PRIVILEGE
          • oceanbase.DBA_OB_DATABASES
          • oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES
          • oceanbase.DBA_OB_EXTERNAL_PART_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_OB_EXTERNAL_RESOURCES
          • DBA_OB_FORMAT_OUTLINES
          • oceanbase.DBA_OB_FREEZE_INFO
          • oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_JOBS
          • oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_TASKS
          • oceanbase.DBA_OB_KV_TTL_TASK_HISTORY
          • oceanbase.DBA_OB_KV_TTL_TASKS
          • oceanbase.DBA_OB_LOG_RESTORE_SOURCE
          • oceanbase.DBA_OB_LOB_CHECK_EXCEPTION_RESULT
          • oceanbase.DBA_OB_LOB_CHECK_TASKS
          • oceanbase.DBA_OB_LS
          • oceanbase.DBA_OB_LS_HISTORY
          • oceanbase.DBA_OB_LS_LOCATIONS
          • oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.DBA_OB_LS_REPLICA_TASKS
          • oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY
          • oceanbase.DBA_OB_MAJOR_COMPACTION
          • oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
          • oceanbase.DBA_OB_OUTLINES
          • oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_SERVICES
          • oceanbase.DBA_OB_RECOVER_TABLE_JOBS
          • oceanbase.DBA_OB_RESOURCE_POOLS
          • oceanbase.DBA_OB_RESTORE_HISTORY
          • oceanbase.DBA_OB_RESTORE_PROGRESS
          • oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY
          • oceanbase.DBA_OB_RSRC_IO_DIRECTIVES
          • oceanbase.DBA_OB_RSRC_DIRECTIVES
          • oceanbase.DBA_OB_SEQUENCE_OBJECTS
          • oceanbase.DBA_OB_SERVER_EVENT_HISTORY
          • oceanbase.DBA_OB_SERVER_JOBS
          • oceanbase.DBA_OB_SERVERS
          • oceanbase.DBA_OB_STORAGE_SPACE_USAGE
          • oceanbase.DBA_OB_STORAGE_IO_USAGE
          • oceanbase.DBA_OB_SHARED_MACRO_BLOCK_GC_STAT
          • oceanbase.DBA_OB_SYS_VARIABLES
          • oceanbase.DBA_OB_SPM_EVO_RESULT
          • oceanbase.DBA_OB_TABLE_LOCATIONS
          • oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TABLE_STAT_STALE_INFO
          • oceanbase.DBA_OB_TABLEGROUP_PARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_TABLES
          • oceanbase.DBA_OB_TABLEGROUPS
          • oceanbase.DBA_OB_TABLET_REPLICAS
          • oceanbase.DBA_OB_TABLET_TO_LS
          • oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TEMP_FILES
          • oceanbase.DBA_OB_TENANT_EVENT_HISTORY
          • oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN
          • oceanbase.DBA_OB_TENANT_JOBS
          • oceanbase.DBA_OB_TENANTS
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASKS
          • DBA_OB_TRUSTED_ROOT_CERTIFICATE
          • oceanbase.DBA_OB_TTL_TASKS
          • oceanbase.DBA_OB_TTL_TASK_HISTORY
          • oceanbase.DBA_OB_UNIT_CONFIGS
          • oceanbase.DBA_OB_UNIT_JOBS
          • oceanbase.DBA_OB_UNITS
          • oceanbase.DBA_OB_USER_DEFINED_RULES
          • oceanbase.DBA_OB_USERS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASKS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY
          • oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.DBA_OB_ZONES
          • oceanbase.DBA_OB_ZONE_STORAGE
          • oceanbase.DBA_OBJECTS
          • oceanbase.DBA_PART_COL_STATISTICS
          • oceanbase.DBA_PART_HISTOGRAMS
          • oceanbase.DBA_PART_INDEXES
          • oceanbase.DBA_PART_KEY_COLUMNS
          • oceanbase.DBA_PART_TABLES
          • oceanbase.DBA_RECYCLEBIN
          • oceanbase.DBA_RSRC_CONSUMER_GROUPS
          • oceanbase.DBA_RSRC_GROUP_MAPPINGS
          • oceanbase.DBA_RSRC_PLAN_DIRECTIVES
          • oceanbase.DBA_RSRC_PLANS
          • oceanbase.DBA_SCHEDULER_JOBS
          • oceanbase.DBA_SCHEDULER_JOB_RUN_DETAILS
          • oceanbase.DBA_SCHEDULER_WINDOWS
          • oceanbase.DBA_SEQUENCES
          • oceanbase.DBA_SQL_MANAGEMENT_CONFIG
          • oceanbase.DBA_SQL_PLAN_BASELINES
          • oceanbase.DBA_SUBPART_COL_STATISTICS
          • oceanbase.DBA_SUBPART_HISTOGRAMS
          • oceanbase.DBA_SUBPART_KEY_COLUMNS
          • oceanbase.DBA_SUBPARTITION_TEMPLATES
          • oceanbase.DBA_TAB_COL_STATISTICS
          • oceanbase.DBA_TAB_HISTOGRAMS
          • oceanbase.DBA_TAB_MODIFICATIONS
          • oceanbase.DBA_TAB_PARTITIONS
          • oceanbase.DBA_TAB_STATISTICS
          • oceanbase.DBA_TAB_STATS_HISTORY
          • oceanbase.DBA_TAB_SUBPARTITIONS
          • oceanbase.DBA_TABLES
          • oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.DBA_WR_CONTROL
          • oceanbase.DBA_WR_EVENT_NAME
          • oceanbase.DBA_WR_RES_MGR_SYSSTAT
          • oceanbase.DBA_WR_SNAPSHOT
          • oceanbase.DBA_WR_SQL_PLAN
          • oceanbase.DBA_WR_SQLSTAT
          • oceanbase.DBA_WR_SQLTEXT
          • oceanbase.DBA_WR_STATNAME
          • oceanbase.DBA_WR_SYS_TIME_MODEL
          • oceanbase.DBA_WR_SYSSTAT
          • oceanbase.DBA_WR_SYSTEM_EVENT
        • Performance views
          • GV$ACTIVE_SESSION_HISTORY
          • GV$DML_STATS
          • GV$LATCH
          • GV$OB_ACTIVE_SESSION_HISTORY
          • GV$OB_COMPACTION_DIAGNOSE_INFO
          • GV$OB_COMPACTION_PROGRESS
          • GV$OB_COMPACTION_SUGGESTIONS
          • GV$OB_CGROUP_CONFIG
          • GV$OB_DTL_INTERM_RESULT_MONITOR
          • GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • GV$OB_FLT_TRACE_CONFIG
          • GV$OB_FUNCTION_IO_STAT
          • GV$OB_GROUP_IO_STAT
          • GV$OB_HMS_CLIENT_POOL_STAT
          • GV$OB_HNSW_INDEX_INFO
          • GV$OB_HNSW_INDEX_SEGMENT_INFO
          • GV$OB_IO_BENCHMARK
          • GV$OB_IO_CALIBRATION_STATUS
          • GV$OB_IVF_INDEX_INFO
          • GV$OB_KVCACHE
          • GV$OB_KV_GROUP_COMMIT_STATUS
          • GV$OB_KV_CONNECTIONS
          • GV$OB_LOG_STAT
          • GV$OB_LOG_TRANSPORT_DEST_STAT
          • GV$OB_LS_SNAPSHOTS
          • GV$OB_MEMORY
          • GV$OB_MEMSTORE
          • GV$OB_MEMSTORE_INFO
          • GV$OB_MERGE_INFO
          • GV$OB_NIC_INFO
          • GV$OB_RPC_INCOMING
          • GV$OB_RPC_OUTGOING
          • GV$OB_PARAMETERS
          • GV$OB_PLAN_CACHE_PLAN_EXPLAIN
          • GV$OB_PLAN_CACHE_PLAN_STAT
          • GV$OB_PLAN_CACHE_STAT
          • GV$OB_PLUGINS
          • GV$OB_PROCESSLIST
          • GV$OB_PS_ITEM_INFO
          • GV$OB_PS_STAT
          • GV$OB_PX_P2P_DATAHUB
          • GV$OB_PX_TARGET_MONITOR
          • GV$OB_PX_WORKER_STAT
          • GV$OB_RES_MGR_SYSSTAT
          • GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • GV$OB_SERVER_SCHEMA_INFO
          • GV$OB_SERVERS
          • GV$OB_SERVER_STORAGE
          • GV$OB_SESS_TIME_MODEL
          • GV$OB_SESSION
          • GV$OB_SESSION_PS_INFO
          • GV$OB_SHARED_STORAGE_QUOTA
          • GV$OB_SINDI_INDEX_INFO
          • GV$OB_SQL_AUDIT
          • GV$OB_SQL_CCL_STATUS
          • GV$SQL_JOIN_FILTER
          • GV$OB_SQL_PLAN
          • GV$SQL_PLAN_MONITOR
          • GV$OB_SQL_WORKAREA_MEMORY_INFO
          • GV$OB_SQLSTAT
          • GV$OB_SSTABLES
          • GV$OB_LOCAL_CACHE
          • GV$OB_LOCAL_CACHE_DIAGNOSE
          • GV$OB_OBJECT_TYPE_IO_STAT
          • GV$OB_STORAGE_CACHE_TASKS
          • GV$OB_SYS_TIME_MODEL
          • GV$OB_TABLET_COMPACTION_HISTORY
          • GV$OB_TABLET_COMPACTION_PROGRESS
          • GV$OB_TABLET_LOCAL_CACHE
          • GV$OB_TABLET_REPLICA_INFO
          • GV$OB_TENANT_MEMORY
          • GV$OB_TENANT_RESOURCE_LIMIT
          • GV$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • GV$OB_TENANT_RUNTIME_INFO
          • GV$OB_TRANSACTION_PARTICIPANTS
          • GV$OB_TRANSACTION_SCHEDULERS
          • GV$OB_UNITS
          • GV$OB_VECTOR_MEMORY
          • GV$SESSION_EVENT
          • GV$SESSION_LONGOPS
          • GV$SESSION_WAIT
          • GV$SESSION_WAIT_HISTORY
          • GV$SESSTAT
          • GV$SQL_WORKAREA
          • GV$SQL_WORKAREA_ACTIVE
          • GV$SQL_WORKAREA_HISTOGRAM
          • GV$SYSSTAT
          • GV$SYSTEM_EVENT
          • GV$OB_KV_CLIENT_INFO
          • GV$OB_LOCKS
          • GV$OB_OPT_STAT_GATHER_MONITOR
          • GV$OB_THREAD
          • GV$OB_PL_CACHE_OBJECT
          • V$OB_PL_CACHE_OBJECT
          • V$ACTIVE_SESSION_HISTORY
          • V$DML_STATS
          • V$ENCRYPTED_TABLESPACES
          • V$EVENT_NAME
          • V$LATCH
          • V$OB_ACTIVE_SESSION_HISTORY
          • V$OB_ARCHIVE_DEST_STATUS
          • V$OB_COMPACTION_DIAGNOSE_INFO
          • V$OB_COMPACTION_PROGRESS
          • V$OB_COMPACTION_SUGGESTIONS
          • V$OB_COMPATIBILITY_CONTROL
          • V$OB_CGROUP_CONFIG
          • V$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_DYNAMIC_PARTITION_TABLES
          • V$OB_ENCRYPTED_TABLES
          • V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • V$OB_FUNCTION_IO_STAT
          • V$OB_GROUP_IO_STAT
          • V$OB_HMS_CLIENT_POOL_STAT
          • V$OB_IO_BENCHMARK
          • V$OB_HNSW_INDEX_SEGMENT_INFO
          • V$OB_HNSW_INDEX_INFO
          • V$OB_IO_CALIBRATION_STATUS
          • V$OB_IVF_INDEX_INFO
          • V$OB_KVCACHE
          • V$OB_KV_CLIENT_INFO
          • V$OB_KV_GROUP_COMMIT_STATUS
          • V$OB_KV_CONNECTIONS
          • V$OB_LOG_STAT
          • V$OB_LOG_TRANSPORT_DEST_STAT
          • V$OB_LS_LOG_RESTORE_STATUS
          • V$OB_LS_REPLICA_TASK_PLAN
          • V$OB_LS_SNAPSHOTS
          • V$OB_MEMORY
          • V$OB_MEMSTORE
          • V$OB_MEMSTORE_INFO
          • V$OB_MERGE_INFO
          • V$OB_NIC_INFO
          • V$OB_RPC_INCOMING
          • V$OB_RPC_OUTGOING
          • V$OB_PARAMETERS
          • V$OB_PLAN_CACHE_PLAN_EXPLAIN
          • V$OB_PLAN_CACHE_PLAN_STAT
          • V$OB_PLAN_CACHE_STAT
          • V$OB_PLUGINS
          • V$OB_PROCESSLIST
          • V$OB_PS_ITEM_INFO
          • V$OB_PS_STAT
          • V$OB_PX_P2P_DATAHUB
          • V$OB_PX_TARGET_MONITOR
          • V$OB_PX_WORKER_STAT
          • V$OB_RES_MGR_SYSSTAT
          • V$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • V$OB_SERVER_SCHEMA_INFO
          • V$OB_SERVERS
          • V$OB_SERVER_STORAGE
          • V$OB_SESS_TIME_MODEL
          • V$OB_SESSION
          • V$SESSION_EVENT
          • V$OB_SESSION_PS_INFO
          • V$OB_SHARED_STORAGE_QUOTA
          • V$OB_SINDI_INDEX_INFO
          • V$OB_SQL_AUDIT
          • V$OB_SQL_CCL_STATUS
          • V$SQL_JOIN_FILTER
          • V$OB_SQL_PLAN
          • V$OB_SQL_WORKAREA_MEMORY_INFO
          • V$OB_SQLSTAT
          • V$OB_SHARED_SSTABLES
          • V$OB_SSTABLES
          • V$OB_LOCAL_CACHE
          • V$OB_LOCAL_CACHE_DIAGNOSE
          • V$OB_OBJECT_TYPE_IO_STAT
          • V$OB_STORAGE_CACHE_TASKS
          • V$OB_SYS_TIME_MODEL
          • V$OB_TABLET_COMPACTION_HISTORY
          • V$OB_TABLET_COMPACTION_PROGRESS
          • V$OB_TABLET_LOCAL_CACHE
          • V$OB_TABLET_REPLICA_INFO
          • V$OB_TENANT_MEMORY
          • V$OB_TENANT_RESOURCE_LIMIT
          • V$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • V$OB_TENANT_RUNTIME_INFO
          • V$OB_TIMESTAMP_SERVICE
          • V$OB_TRANSACTION_PARTICIPANTS
          • V$OB_TRANSACTION_SCHEDULERS
          • V$OB_UNITS
          • V$RSRC_PLAN
          • V$SESSION_LONGOPS
          • V$SESSION_WAIT
          • V$SESSION_WAIT_HISTORY
          • V$SESSTAT
          • V$SQL_MONITOR_STATNAME
          • V$SQL_PLAN_MONITOR
          • V$SQL_WORKAREA
          • V$SQL_WORKAREA_ACTIVE
          • V$SQL_WORKAREA_HISTOGRAM
          • V$STATNAME
          • V$SYSSTAT
          • V$SYSTEM_EVENT
          • V$OB_LOCKS
          • V$OB_OPT_STAT_GATHER_MONITOR
          • V$OB_THREAD
          • V$OB_VECTOR_MEMORY
      • User tenant views
        • Dictionary views
          • information_schema.CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS
          • information_schema.CHARACTER_SETS
          • information_schema.CHECK_CONSTRAINTS
          • information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
          • information_schema.COLLATIONS
          • information_schema.COLUMN_PRIVILEGES
          • information_schema.COLUMNS
          • information_schema.ENGINES
          • information_schema.events
          • information_schema.GLOBAL_STATUS
          • information_schema.GLOBAL_VARIABLES
          • information_schema.KEY_COLUMN_USAGE
          • information_schema.PARAMETERS
          • information_schema.PARTITIONS
          • information_schema.PROCESSLIST
          • information_schema.QUERY_RESPONSE_TIME
          • information_schema.REFERENTIAL_CONSTRAINTS
          • information_schema.role_table_grants
          • information_schema.role_column_grants
          • information_schema.role_routine_grants
          • information_schema.ROUTINES
          • information_schema.SCHEMA_PRIVILEGES
          • information_schema.SCHEMATA
          • information_schema.SESSION_STATUS
          • information_schema.SESSION_VARIABLES
          • information_schema.ST_GEOMETRY_COLUMNS
          • information_schema.ST_SPATIAL_REFERENCE_SYSTEMS
          • information_schema.STATISTICS
          • information_schema.TABLE_CONSTRAINTS
          • information_schema.TABLE_PRIVILEGES
          • information_schema.TABLES
          • information_schema.TRIGGERS
          • information_schema.USER_PRIVILEGES
          • information_schema.VIEW_TABLE_USAGE
          • information_schema.VIEWS
          • mysql.audit_log_filter
          • mysql.audit_log_user
          • mysql.columns_priv
          • mysql.db
          • mysql.default_roles
          • mysql.help_category
          • mysql.help_keyword
          • mysql.help_relation
          • mysql.help_topic
          • mysql.proc
          • mysql.procs_priv
          • mysql.role_edges
          • mysql.time_zone
          • mysql.time_zone_name
          • mysql.time_zone_transition
          • mysql.time_zone_transition_type
          • mysql.user
          • oceanbase.ALL_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_DB_LINKS
          • oceanbase.DBA_IND_PARTITIONS
          • oceanbase.DBA_IND_STATISTICS
          • oceanbase.DBA_IND_SUBPARTITIONS
          • oceanbase.DBA_INDEX_USAGE
          • oceanbase.DBA_JAVA_POLICY
          • oceanbase.DBA_MVIEW_DEPS
          • oceanbase.DBA_MVIEW_LOGS
          • oceanbase.DBA_MVIEW_RUNNING_JOBS
          • oceanbase.DBA_MVIEWS
          • oceanbase.DBA_MVREF_CHANGE_STATS
          • oceanbase.DBA_MVREF_RUN_STATS
          • oceanbase.DBA_MVREF_STATS
          • oceanbase.DBA_MVREF_STATS_PARAMS
          • oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS
          • oceanbase.DBA_MVREF_STMT_STATS
          • oceanbase.DBA_OB_ACCESS_POINT
          • oceanbase.DBA_OB_AI_BATCH_TASK_HISTORY
          • oceanbase.DBA_OB_AI_BATCH_TASKS
          • oceanbase.DBA_OB_AI_GATEWAY_ENDPOINTS
          • oceanbase.DBA_OB_AI_GATEWAYS
          • oceanbase.DBA_OB_AI_MODEL_ENDPOINTS
          • oceanbase.DBA_OB_AI_MODEL_PROFILES
          • oceanbase.DBA_OB_AI_MODEL_PROVIDERS
          • oceanbase.DBA_OB_AI_MODELS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASKS
          • oceanbase.DBA_OB_AGENT_DB_BACKGROUND_TASK_HISTORY
          • oceanbase.DBA_OB_ARCHIVE_DEST
          • oceanbase.DBA_OB_ARCHIVELOG
          • oceanbase.DBA_OB_ARCHIVELOG_PIECE_FILES
          • oceanbase.DBA_OB_ARCHIVELOG_SUMMARY
          • oceanbase.DBA_OB_AUTO_INCREMENT
          • DBA_OB_AUX_STATISTICS
          • oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_JOBS
          • oceanbase.DBA_OB_BACKUP_DELETE_POLICY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_DELETE_TASKS
          • oceanbase.DBA_OB_BACKUP_JOB_HISTORY
          • oceanbase.DBA_OB_BACKUP_JOBS
          • oceanbase.DBA_OB_BACKUP_PARAMETER
          • oceanbase.DBA_OB_BACKUP_SET_FILES
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO
          • oceanbase.DBA_OB_BACKUP_STORAGE_INFO_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASK_HISTORY
          • oceanbase.DBA_OB_BACKUP_TASKS
          • oceanbase.DBA_OB_BALANCE_JOB_HISTORY
          • oceanbase.DBA_OB_BALANCE_JOBS
          • oceanbase.DBA_OB_BALANCE_TASK_HISTORY
          • oceanbase.DBA_OB_BALANCE_TASKS
          • oceanbase.DBA_OB_CONCURRENT_LIMIT_SQL
          • oceanbase.DBA_OB_CCL_RULES
          • oceanbase.DBA_OB_CS_REPLICA_STATS
          • oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG
          • oceanbase.DBA_OB_DATABASE_PRIVILEGE
          • oceanbase.DBA_OB_DATABASES
          • oceanbase.DBA_OB_DEADLOCK_EVENT_HISTORY
          • oceanbase.DBA_OB_DYNAMIC_PARTITION_TABLES
          • oceanbase.DBA_OB_EXTERNAL_PART_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_COL_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TAB_STATISTICS
          • oceanbase.DBA_OB_EXTERNAL_TABLE_FILES
          • oceanbase.DBA_OB_EXTERNAL_RESOURCES
          • DBA_OB_FORMAT_OUTLINES
          • oceanbase.DBA_OB_FREEZE_INFO
          • oceanbase.DBA_OB_IMPORT_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_JOBS
          • oceanbase.DBA_OB_IMPORT_TABLE_TASK_HISTORY
          • oceanbase.DBA_OB_IMPORT_TABLE_TASKS
          • oceanbase.DBA_OB_KV_TTL_TASK_HISTORY
          • oceanbase.DBA_OB_KV_TTL_TASKS
          • oceanbase.DBA_OB_LOG_RESTORE_SOURCE
          • oceanbase.DBA_OB_LOB_CHECK_EXCEPTION_RESULT
          • oceanbase.DBA_OB_LOB_CHECK_TASKS
          • oceanbase.DBA_OB_LS
          • oceanbase.DBA_OB_LS_HISTORY
          • oceanbase.DBA_OB_LS_LOCATIONS
          • oceanbase.DBA_OB_LS_LOG_ARCHIVE_PROGRESS
          • oceanbase.DBA_OB_LS_REPLICA_TASKS
          • oceanbase.DBA_OB_LS_REPLICA_TASK_HISTORY
          • oceanbase.DBA_OB_MAJOR_COMPACTION
          • oceanbase.DBA_OB_OBJECT_BALANCE_WEIGHT
          • oceanbase.DBA_OB_OUTLINE_CONCURRENT_HISTORY
          • oceanbase.DBA_OB_OUTLINES
          • oceanbase.DBA_OB_RECOVER_TABLE_JOB_HISTORY
          • oceanbase.DBA_OB_RECOVER_TABLE_JOBS
          • oceanbase.DBA_OB_SERVICES
          • oceanbase.DBA_OB_RESTORE_HISTORY
          • oceanbase.DBA_OB_RESTORE_PROGRESS
          • oceanbase.DBA_OB_RSRC_IO_DIRECTIVES
          • oceanbase.DBA_OB_RSRC_DIRECTIVES
          • oceanbase.DBA_OB_SENSITIVE_COLUMNS
          • oceanbase.DBA_OB_SENSITIVE_RULE_PLAINACCESS_USERS
          • oceanbase.DBA_OB_SENSITIVE_RULES
          • oceanbase.DBA_OB_SEQUENCE_OBJECTS
          • oceanbase.DBA_OB_SHARED_MACRO_BLOCK_GC_STAT
          • oceanbase.DBA_OB_STORAGE_SPACE_USAGE
          • oceanbase.DBA_OB_STORAGE_IO_USAGE
          • oceanbase.DBA_OB_SYS_VARIABLES
          • oceanbase.DBA_OB_SPM_EVO_RESULT
          • oceanbase.DBA_OB_TABLE_LOCATIONS
          • oceanbase.DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TABLE_STAT_STALE_INFO
          • oceanbase.DBA_OB_TABLEGROUP_PARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS
          • oceanbase.DBA_OB_TABLEGROUP_TABLES
          • oceanbase.DBA_OB_TABLEGROUPS
          • oceanbase.DBA_OB_TABLET_REPLICAS
          • oceanbase.DBA_OB_TABLE_SPACE_USAGE
          • oceanbase.DBA_OB_TABLET_TO_LS
          • oceanbase.DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
          • oceanbase.DBA_OB_TENANT_EVENT_HISTORY
          • oceanbase.DBA_OB_TENANTS
          • oceanbase.DBA_OB_TEMP_FILES
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASKS
          • oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASK_HISTORY
          • oceanbase.DBA_OB_TRANSFER_TASKS
          • oceanbase.DBA_OB_USER_DEFINED_RULES
          • oceanbase.DBA_OB_USERS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASKS
          • oceanbase.DBA_OB_VECTOR_INDEX_TASK_HISTORY
          • oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION
          • oceanbase.DBA_OBJECTS
          • oceanbase.DBA_PART_COL_STATISTICS
          • oceanbase.DBA_PART_HISTOGRAMS
          • oceanbase.DBA_PART_INDEXES
          • oceanbase.DBA_PART_KEY_COLUMNS
          • oceanbase.DBA_PART_TABLES
          • oceanbase.DBA_RECYCLEBIN
          • oceanbase.DBA_RLS_POLICIES
          • oceanbase.DBA_RSRC_CONSUMER_GROUPS
          • oceanbase.DBA_RSRC_GROUP_MAPPINGS
          • oceanbase.DBA_RSRC_PLAN_DIRECTIVES
          • oceanbase.DBA_RSRC_PLANS
          • oceanbase.DBA_SCHEDULER_JOBS
          • oceanbase.DBA_SCHEDULER_JOB_RUN_DETAILS
          • oceanbase.DBA_SCHEDULER_WINDOWS
          • oceanbase.DBA_SEQUENCES
          • oceanbase.DBA_SQL_MANAGEMENT_CONFIG
          • oceanbase.DBA_SQL_PLAN_BASELINES
          • oceanbase.DBA_SUBPART_COL_STATISTICS
          • oceanbase.DBA_SUBPART_HISTOGRAMS
          • oceanbase.DBA_SUBPART_KEY_COLUMNS
          • oceanbase.DBA_SUBPARTITION_TEMPLATES
          • oceanbase.DBA_TAB_COL_STATISTICS
          • oceanbase.DBA_TAB_HISTOGRAMS
          • oceanbase.DBA_TAB_MODIFICATIONS
          • oceanbase.DBA_TAB_PARTITIONS
          • oceanbase.DBA_TAB_STATISTICS
          • oceanbase.DBA_TAB_STATS_HISTORY
          • oceanbase.DBA_TAB_SUBPARTITIONS
          • oceanbase.DBA_TABLES
          • oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN
          • oceanbase.DBA_OB_TTL_TASKS
          • oceanbase.DBA_OB_TTL_TASK_HISTORY
          • oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY
          • oceanbase.DBA_WR_CONTROL
          • oceanbase.DBA_WR_EVENT_NAME
          • oceanbase.DBA_WR_RES_MGR_SYSSTAT
          • oceanbase.DBA_WR_SNAPSHOT
          • oceanbase.DBA_WR_SQL_PLAN
          • oceanbase.DBA_WR_SQLSTAT
          • oceanbase.DBA_WR_SQLTEXT
          • oceanbase.DBA_WR_STATNAME
          • oceanbase.DBA_WR_SYS_TIME_MODEL
          • oceanbase.DBA_WR_SYSSTAT
          • oceanbase.DBA_WR_SYSTEM_EVENT
          • oceanbase.USER_JAVA_POLICY
        • Performance views
          • GV$ACTIVE_SESSION_HISTORY
          • GV$DML_STATS
          • GV$LATCH
          • GV$OB_ACTIVE_SESSION_HISTORY
          • GV$OB_COMPACTION_DIAGNOSE_INFO
          • GV$OB_COMPACTION_PROGRESS
          • GV$OB_COMPACTION_SUGGESTIONS
          • GV$OB_CGROUP_CONFIG
          • GV$OB_DTL_INTERM_RESULT_MONITOR
          • GV$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • GV$OB_FLT_TRACE_CONFIG
          • GV$OB_FUNCTION_IO_STAT
          • GV$OB_GROUP_IO_STAT
          • GV$OB_HNSW_INDEX_INFO
          • GV$OB_HMS_CLIENT_POOL_STAT
          • GV$OB_IVF_INDEX_INFO
          • GV$OB_HNSW_INDEX_SEGMENT_INFO
          • GV$OB_KVCACHE
          • GV$OB_KV_CLIENT_INFO
          • GV$OB_KV_GROUP_COMMIT_STATUS
          • GV$OB_KV_CONNECTIONS
          • GV$OB_LOG_STAT
          • GV$OB_LOG_TRANSPORT_DEST_STAT
          • GV$OB_LS_SNAPSHOTS
          • GV$OB_MEMORY
          • GV$OB_MEMSTORE
          • GV$OB_MEMSTORE_INFO
          • GV$OB_MERGE_INFO
          • GV$OB_NIC_INFO
          • GV$OB_RPC_INCOMING
          • GV$OB_RPC_OUTGOING
          • GV$OB_PARAMETERS
          • GV$OB_PLAN_CACHE_PLAN_EXPLAIN
          • GV$OB_PLAN_CACHE_PLAN_STAT
          • GV$OB_PLAN_CACHE_STAT
          • GV$OB_PROCESSLIST
          • GV$OB_PS_ITEM_INFO
          • GV$OB_PS_STAT
          • GV$OB_PX_P2P_DATAHUB
          • GV$OB_PX_TARGET_MONITOR
          • GV$OB_PX_WORKER_STAT
          • GV$OB_RES_MGR_SYSSTAT
          • GV$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • GV$OB_SERVER_SCHEMA_INFO
          • GV$OB_SESS_TIME_MODEL
          • GV$OB_SESSION
          • GV$OB_SESSION_PS_INFO
          • GV$OB_SHARED_STORAGE_QUOTA
          • GV$OB_SINDI_INDEX_INFO
          • GV$OB_SQL_AUDIT
          • GV$OB_SQL_CCL_STATUS
          • GV$SQL_JOIN_FILTER
          • GV$OB_SQL_PLAN
          • GV$OB_SQL_WORKAREA_MEMORY_INFO
          • GV$OB_SQLSTAT
          • GV$OB_SSTABLES
          • GV$OB_LOCAL_CACHE
          • GV$OB_LOCAL_CACHE_DIAGNOSE
          • GV$OB_OBJECT_TYPE_IO_STAT
          • GV$OB_STORAGE_CACHE_TASKS
          • GV$OB_SYS_TIME_MODEL
          • GV$OB_TABLET_COMPACTION_HISTORY
          • GV$OB_TABLET_COMPACTION_PROGRESS
          • GV$OB_TABLET_LOCAL_CACHE
          • GV$OB_TABLET_MACRO_CACHE_STAT
          • GV$OB_TENANT_MEMORY
          • GV$OB_TENANT_RESOURCE_LIMIT
          • GV$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • GV$OB_TRANSACTION_PARTICIPANTS
          • GV$OB_TRANSACTION_SCHEDULERS
          • GV$OB_UNITS
          • GV$OB_VECTOR_MEMORY
          • GV$SESSION_EVENT
          • GV$SESSION_LONGOPS
          • GV$SESSION_WAIT
          • GV$SESSION_WAIT_HISTORY
          • GV$SESSTAT
          • GV$SQL_PLAN_MONITOR
          • GV$SQL_WORKAREA
          • GV$SQL_WORKAREA_ACTIVE
          • GV$SQL_WORKAREA_HISTOGRAM
          • GV$SYSSTAT
          • GV$SYSTEM_EVENT
          • GV$OB_LOCKS
          • GV$OB_OPT_STAT_GATHER_MONITOR
          • GV$OB_THREAD
          • GV$OB_PL_CACHE_OBJECT
          • V$OB_PL_CACHE_OBJECT
          • V$ACTIVE_SESSION_HISTORY
          • V$DML_STATS
          • V$EVENT_NAME
          • V$LATCH
          • V$OB_ACTIVE_SESSION_HISTORY
          • V$OB_ARCHIVE_DEST_STATUS
          • V$OB_COMPACTION_DIAGNOSE_INFO
          • V$OB_COMPACTION_PROGRESS
          • V$OB_COMPACTION_SUGGESTIONS
          • V$OB_COMPATIBILITY_CONTROL
          • V$OB_CGROUP_CONFIG
          • V$OB_DTL_INTERM_RESULT_MONITOR
          • V$OB_DYNAMIC_PARTITION_TABLES
          • V$OB_ENCRYPTED_TABLES
          • V$ENCRYPTED_TABLESPACES
          • V$OB_EXTERNAL_CATALOG_CLIENT_POOL_STAT
          • V$OB_FUNCTION_IO_STAT
          • V$OB_GROUP_IO_STAT
          • V$OB_HMS_CLIENT_POOL_STAT
          • V$OB_HNSW_INDEX_INFO
          • V$OB_HNSW_INDEX_SEGMENT_INFO
          • V$OB_IVF_INDEX_INFO
          • V$OB_KVCACHE
          • V$OB_KV_CLIENT_INFO
          • V$OB_KV_GROUP_COMMIT_STATUS
          • V$OB_KV_CONNECTIONS
          • V$OB_LOG_STAT
          • V$OB_LOG_TRANSPORT_DEST_STAT
          • V$OB_LS_LOG_RESTORE_STATUS
          • V$OB_LS_REPLICA_TASK_PLAN
          • V$OB_LS_SNAPSHOTS
          • V$OB_MEMORY
          • V$OB_MEMSTORE
          • V$OB_MEMSTORE_INFO
          • V$OB_MERGE_INFO
          • V$OB_NIC_INFO
          • V$OB_RPC_INCOMING
          • V$OB_RPC_OUTGOING
          • V$OB_PARAMETERS
          • V$OB_PLAN_CACHE_PLAN_EXPLAIN
          • V$OB_PLAN_CACHE_PLAN_STAT
          • V$OB_PLAN_CACHE_STAT
          • V$OB_PROCESSLIST
          • V$OB_PS_ITEM_INFO
          • V$OB_PS_STAT
          • V$OB_PX_P2P_DATAHUB
          • V$OB_PX_TARGET_MONITOR
          • V$OB_PX_WORKER_STAT
          • V$OB_RES_MGR_SYSSTAT
          • V$OB_QUERY_RESPONSE_TIME_HISTOGRAM
          • V$RSRC_PLAN
          • V$OB_SERVER_SCHEMA_INFO
          • V$OB_SESS_TIME_MODEL
          • V$OB_SESSION
          • V$SESSION_EVENT
          • V$OB_SESSION_PS_INFO
          • V$OB_SHARED_STORAGE_QUOTA
          • V$OB_SINDI_INDEX_INFO
          • V$OB_SQL_AUDIT
          • V$OB_SQL_CCL_STATUS
          • V$SQL_JOIN_FILTER
          • V$OB_SQL_PLAN
          • V$OB_SQL_WORKAREA_MEMORY_INFO
          • V$OB_SQLSTAT
          • V$OB_SHARED_SSTABLES
          • V$OB_SSTABLES
          • V$OB_LOCAL_CACHE
          • V$OB_LOCAL_CACHE_DIAGNOSE
          • V$OB_OBJECT_TYPE_IO_STAT
          • V$OB_STORAGE_CACHE_TASKS
          • V$OB_SYS_TIME_MODEL
          • V$OB_TABLET_COMPACTION_HISTORY
          • V$OB_TABLET_COMPACTION_PROGRESS
          • V$OB_TABLET_LOCAL_CACHE
          • V$OB_TABLET_MACRO_CACHE_STAT
          • V$OB_TENANT_MEMORY
          • V$OB_TENANT_RESOURCE_LIMIT
          • V$OB_TENANT_RESOURCE_LIMIT_DETAIL
          • V$OB_TIMESTAMP_SERVICE
          • V$OB_TRANSACTION_PARTICIPANTS
          • V$OB_TRANSACTION_SCHEDULERS
          • V$OB_UNITS
          • V$OB_VECTOR_MEMORY
          • V$RESTORE_POINT
          • V$SESSION_LONGOPS
          • V$SESSION_WAIT
          • V$SESSION_WAIT_HISTORY
          • V$SESSTAT
          • V$SQL_MONITOR_STATNAME
          • V$SQL_PLAN_MONITOR
          • V$SQL_WORKAREA
          • V$SQL_WORKAREA_ACTIVE
          • V$SQL_WORKAREA_HISTOGRAM
          • V$STATNAME
          • V$SYSSTAT
          • V$SYSTEM_EVENT
          • V$OB_LOCKS
          • V$OB_OPT_STAT_GATHER_MONITOR
          • V$OB_THREAD
      • Overview of Metrics
      • Common wait events
    • Parameters and system variables
      • Overview of parameters and system variables
      • Parameters
        • Parameter overview
        • Cluster-level parameters
          • alert_log_level
          • all_cluster_list
          • all_server_list
          • autoinc_cache_refresh_interval
          • async_ps_cursor_max_count
          • balancer_log_interval
          • balancer_task_timeout
          • system_protected_sys_variables
          • system-protected-tenant-parameters
          • balancer_tolerance_percentage
          • bf_cache_miss_count_threshold
          • bf_cache_priority
          • builtin_db_data_verify_cycle
          • cache_wash_threshold
          • clog_io_isolation_mode
          • clog_sync_time_warn_threshold
          • cluster
          • cluster_id
          • config_additional_dir
          • cpu_count
          • data_dir
          • data_disk_usage_limit_percentage
          • data_disk_write_limit_percentage
          • data_storage_error_tolerance_time
          • data_storage_warning_tolerance_time
          • datafile_disk_percentage
          • datafile_maxsize
          • datafile_next
          • datafile_size
          • dead_socket_detection_timeout
          • debug_sync_timeout
          • default_compress_func
          • default_row_format
          • devname
          • diag_syslog_per_error_limit
          • disk_io_thread_count
          • dtl_buffer_size
          • enable_asan_for_memory_context
          • enable_async_syslog
          • enable_cgroup
          • enable_dblink
          • enable_ddl
          • enable_global_background_resource_isolation
          • enable_logservice
          • enable_major_freeze
          • enable_ob_error_msg_style
          • enable_ob_ratelimit
          • enable_perf_event
          • enable_record_trace_id
          • enable_record_trace_log
          • enable_rereplication
          • enable_rich_error_msg
          • enable_rpc_authentication_bypass
          • enable_sql_audit
          • enable_sql_operator_dump
          • enable_sys_table_ddl
          • enable_sys_unit_standalone
          • enable_syslog_recycle
          • enable_syslog_wf
          • enable_tcp_keepalive
          • enable_upgrade_mode
          • ext_plugin_config
          • fuse_row_cache_priority
          • global_background_cpu_quota
          • high_priority_net_thread_count
          • ignore_replay_checksum_error
          • index_block_cache_priority
          • internal_sql_execute_timeout
          • io_scheduler_thread_count
          • large_query_threshold
          • large_query_worker_percentage
          • leak_mod_to_check
          • lease_time
          • local_ip
          • location_cache_cpu_quota
          • location_cache_expire_time
          • location_cache_refresh_min_interval
          • location_cache_refresh_rpc_timeout
          • location_cache_refresh_sql_timeout
          • location_fetch_concurrency
          • location_refresh_thread_count
          • log_disk_percentage
          • log_disk_size
          • logservice_access_point
          • log_storage_warning_trigger_percentage
          • log_storage_warning_tolerance_time
          • ls_meta_table_check_interval
          • max_string_print_length
          • max_syslog_file_count
          • memory_chunk_cache_size
          • memory_limit
          • memory_limit_percentage
          • memory_reserved
          • memstore_limit_percentage
          • micro_block_merge_verify_level
          • migration_disable_time
          • min_observer_version
          • mysql_port
          • net_thread_count
          • ob_event_history_recycle_interval
          • ob_ratelimit_stat_period
          • ob_startup_mode
          • ob_python_home
          • obconfig_url
          • observer_id
          • ob_storage_s3_url_encode_type
          • ob_enable_java_env
          • ob_java_home
          • ob_java_connector_path
          • ob_java_opts
          • ob_enable_java_udf_sandbox
          • ob_enable_utl_http
          • opt_tab_stat_cache_priority
          • plan_cache_evict_interval
          • px_task_size
          • plugins_load
          • recyclebin_object_expire_time
          • resource_hard_limit
          • rest_oauth2_credential_refresh_interval
          • rest_oauth2_credential_evict_time
          • rootservice_async_task_queue_size
          • rootservice_async_task_thread_count
          • rootservice_list
          • rootservice_ready_check_interval
          • row_compaction_update_limit
          • rpc_client_authentication_method
          • rpc_port
          • rpc_server_authentication_method
          • rpc_timeout
          • schema_history_expire_time
          • schema_history_recycle_interval
          • server_balance_cpu_mem_tolerance_percent
          • server_balance_critical_disk_waterlevel
          • server_balance_disk_tolerance_percent
          • server_check_interval
          • server_cpu_quota_max
          • server_cpu_quota_min
          • server_permanent_offline_time
          • sql_login_thread_count
          • sql_net_thread_count
          • sql_protocol_min_tls_version
          • ssl_client_authentication
          • ssl_external_kms_info
          • stack_size
          • standby_fetch_log_bandwidth_limit
          • storage_meta_cache_priority
          • strict_check_os_params
          • sync_io_thread_count
          • sys_bkgd_migration_change_member_list_timeout
          • sys_bkgd_migration_retry_num
          • sys_bkgd_net_percentage
          • sys_ckpt_thread_score
          • syslog_compress_func
          • syslog_disk_size
          • syslog_file_uncompressed_count
          • syslog_io_bandwidth_limit
          • syslog_level
          • system_memory
          • tablet_ls_cache_priority
          • tablet_meta_table_check_interval
          • tablet_meta_table_scan_batch_count
          • tablet_size
          • tcp_keepcnt
          • tcp_keepidle
          • tcp_keepintvl
          • tenant_task_queue_size
          • trace_log_slow_query_watermark
          • trx_2pc_retry_interval
          • unit_gc_wait_time
          • use_large_pages
          • user_block_cache_priority
          • user_row_cache_priority
          • virtual_table_location_cache_expire_time
          • weak_read_version_refresh_interval
          • workers_per_cpu_quota
          • zone
        • Tenant-level parameters
          • agent_db_background_delete_thread_score
          • agent_db_hot_namespace_ttl
          • arbitration_timeout
          • archive_lag_target
          • approx_count_distinct_precision
          • audit_log_buffer_size
          • audit_log_compression
          • attach_shared_sstable_thread_score
          • audit_log_enable
          • audit_log_format
          • audit_log_max_size
          • audit_log_path
          • audit_log_prune_seconds
          • audit_log_query_sql
          • audit_log_rotate_on_size
          • audit_log_strategy
          • audit_sys_operations
          • audit_trail
          • auto_split_tablet_size
          • backup_data_file_size
          • balancer_idle_time
          • catalog_sync_target
          • choose_migration_source_policy
          • compaction_dag_cnt_limit
          • compaction_high_thread_score
          • compaction_low_thread_score
          • compaction_mid_thread_score
          • compaction_schedule_tablet_batch_cnt
          • compatible
          • connection_control_failed_connections_threshold
          • connection_control_max_connection_delay
          • connection_control_min_connection_delay
          • cpu_quota_concurrency
          • ddl_thread_score
          • default_auto_increment_mode
          • default_delta_format
          • default_enable_extended_rowid
          • default_load_mode
          • default_micro_block_format_version
          • default_progressive_merge_num
          • default_skip_index_level
          • default_storage_cache_policy
          • default_table_merge_engine
          • default_table_organization
          • default_table_store_format
          • direct_load_allow_fallback
          • ddl_high_thread_score
          • document_ai_file_max_size
          • dtl_compress_func
          • dump_data_dictionary_to_log_interval
          • enable_agent_db_background_task
          • enable_adaptive_plan_cache
          • enable_auto_split
          • enable_database_sharding_none
          • enable_early_lock_release
          • enable_hbase_rowkey_ttl
          • enable_pl_rich_error_msg
          • enable_gts_standalone
          • enable_kv_group_commit
          • enable_kv_ttl
          • enable_lake_table_parallel_resolving
          • enable_lock_priority
          • enable_manual_storage_cache_policy
          • enable_mlog_auto_maintenance
          • enable_monotonic_weak_read
          • enable_mv_binlog_minimal_mode
          • enable_ls_leader_balance
          • enable_rebalance
          • enable_sql_extension
          • enable_transfer
          • enable_ttl
          • enable_user_defined_rewrite_rules
          • enable_window_compaction
          • enable_ps_parameterize
          • external_kms_info
          • external_table_io_hole_size
          • external_table_io_range_size
          • external_table_csv_max_buffer_size
          • ob_vector_search_strategy
          • freeze_trigger_percentage
          • global_index_auto_split_policy
          • ha_high_thread_score
          • ha_low_thread_score
          • ha_mid_thread_score
          • inc_sstable_upload_thread_score
          • shared_gc_executor_thread_score
          • shared_gc_generator_thread_score
          • json_document_max_depth
          • kv_ttl_duty_duration
          • kv_group_commit_batch_size
          • kv_group_commit_rw_mode
          • kv_hbase_client_scanner_timeout_period
          • kv_ttl_delete_max_ops
          • kv_ttl_history_recycle_interval
          • kv_transport_compress_threshold
          • lake_table_pruning_thread_count
          • load_data_diagnosis_log_compression
          • load_data_diagnosis_log_max_size
          • load_vector_index_on_follower
          • lob_enable_block_cache_threshold
          • log_archive_concurrency
          • log_disk_throttling_maximum_duration
          • log_disk_throttling_percentage
          • log_disk_utilization_limit_threshold
          • log_disk_utilization_threshold
          • log_restore_concurrency
          • log_storage_compress_all
          • log_storage_compress_func
          • log_transport_compress_all
          • log_transport_compress_func
          • ls_gc_delay_time
          • ls_scale_out_factor
          • major_compact_trigger
          • major_freeze_duty_time
          • max_partition_num
          • max_stale_time_for_weak_consistency
          • mds_compaction_high_thread_score
          • mds_compaction_mid_thread_score
          • mds_minor_compact_trigger
          • merger_check_interval
          • minor_compact_trigger
          • mlog_trim_interval
          • model_max_retries
          • model_request_timeout
          • mv_refresh_concurrency
          • ob_compaction_schedule_interval
          • ob_enable_batched_multi_statement
          • ob_encoding_granularity
          • ob_enable_java_udf
          • ob_enable_python_udf
          • ob_proxy_readonly_transaction_routing_policy
          • ob_query_switch_leader_retry_timeout
          • ob_ssl_invited_common_names
          • ob_vector_index_active_segment_max_size
          • ob_vector_index_merge_trigger_percentage
          • ob_vector_memory_limit_percentage
          • open_cursors
          • optimizer_index_cost_adj
          • partition_balance_schedule_interval
          • plsql_code_type
          • plsql_debug
          • px_node_policy
          • package_state_sync_max_size
          • px_target_high_watermark
          • px_target_low_watermark
          • px_target_workers_per_cpu
          • px_workers_per_cpu_quota
          • query_memory_limit_percentage
          • query_response_time_flush
          • query_response_time_range_base
          • query_response_time_stats
          • range_optimizer_max_mem_size
          • recover_table_concurrency
          • recover_table_dop
          • replica_parallel_migration_mode
          • result_cache_max_size
          • result_cache_max_result
          • ob_result_cache_evict_percentage
          • ob_deterministic_udf_cache_max_size
          • rpc_memory_limit_percentage
          • shared_log_retention
          • shared_storage_data_check_thread_score
          • spill_compression_codec
          • sql_func_extension_mode
          • sql_work_area
          • standby_db_fetch_log_rpc_timeout
          • standby_db_preferred_upstream_log_region
          • storage_rowsets_size
          • sts_credential
          • suspend_storage_cache_task
          • kv_transport_compress_func
          • tde_method
          • tenant_sql_login_thread_count
          • tenant_sql_net_thread_count
          • temporary_file_max_disk_size
          • ttl_duty_time
          • ttl_thread_score
          • undo_retention
          • vector_index_memory_saving_mode
          • vector_index_optimization_concurrency
          • vector_index_optimize_duty_time
          • vector_task_thread_limit_percent
          • workarea_size_policy
          • writing_throttling_maximum_duration
          • writing_throttling_trigger_percentage
          • zone_deploy_mode
      • System variables
        • Overview of system variables
        • Global variables
          • ap_query_cost_threshold
          • ap_query_route_policy
          • ap_query_replica_fallback
          • activate_all_roles_on_login
          • auto_increment_cache_size
          • auto_increment_increment
          • auto_increment_offset
          • autocommit
          • automatic_sp_privileges
          • binlog_row_image
          • block_encryption_mode
          • character_set_client
          • character_set_connection
          • cardinality_estimation_model
          • character_set_database
          • character_set_filesystem
          • character_set_results
          • character_set_server
          • character_set_system
          • collation_connection
          • collation_database
          • collation_server
          • connect_timeout
          • cte_max_recursion_depth
          • cursor_sharing
          • datadir
          • default_authentication_plugin
          • default_password_lifetime
          • default_storage_engine
          • div_precision_increment
          • error_on_overlap_time
          • event_scheduler
          • explicit_defaults_for_timestamp
          • enable_optimizer_rowgoal
          • foreign_key_checks
          • group_concat_max_len
          • init_connect
          • innodb_stats_persistent
          • innodb_strict_mode
          • interactive_timeout
          • license
          • lc_time_names
          • log_row_value_options
          • long_query_time
          • lower_case_table_names
          • max_allowed_packet
          • max_connections
          • max_sp_recursion_depth
          • max_user_connections
          • mview_refresh_dop
          • net_buffer_length
          • net_read_timeout
          • net_write_timeout
          • ob_bnl_join_cache_size
          • ob_compatibility_mode
          • ob_compatibility_control
          • ob_compatibility_version
          • ob_default_lob_inrow_threshold
          • ob_early_lock_release
          • ob_enable_ps_parameter_anonymous_block
          • ob_enable_pl_async_commit
          • ob_enable_aggregation_pushdown
          • ob_enable_index_direct_select
          • ob_enable_jit
          • ob_enable_pl_cache
          • ob_enable_plan_cache
          • ob_enable_rich_error_msg
          • ob_enable_sql_audit
          • ob_enable_transformation
          • ob_enable_transmission_checksum
          • ob_enable_truncate_flashback
          • ob_log_level
          • ob_max_read_stale_time
          • ob_pl_block_timeout
          • ob_plan_cache_evict_high_percentage
          • ob_plan_cache_evict_low_percentage
          • ob_plan_cache_percentage
          • ob_query_timeout
          • ob_read_consistency
          • ob_reserved_meta_memory_percentage
          • ob_route_policy
          • ob_sql_audit_percentage
          • ob_sql_work_area_percentage
          • ob_table_access_policy
          • ob_tcp_invited_nodes
          • ob_temp_tablespace_size_percentage
          • ob_trx_idle_timeout
          • ob_trx_lock_timeout
          • ob_trx_timeout
          • optimizer_capture_sql_plan_baselines
          • ob_security_version
          • optimizer_dynamic_sampling
          • optimizer_features_enable
          • optimizer_use_sql_plan_baselines
          • parallel_degree_limit
          • parallel_degree_policy
          • parallel_min_scan_time_threshold
          • parallel_servers_target
          • partition_index_dive_limit
          • performance_schema
          • plugin_dir
          • pid_file
          • query_cache_size
          • plsql_optimize_level
          • plsql_can_transform_sql_to_assign
          • port
          • query_cache_type
          • query_rewrite_enabled
          • query_rewrite_integrity
          • read_only
          • recyclebin
          • regexp_stack_limit
          • regexp_time_limit
          • resource_manager_plan
          • socket
          • range_index_dive_limit
          • runtime_bloom_filter_max_size
          • runtime_filter_max_in_num
          • runtime_filter_type
          • runtime_filter_wait_time_ms
          • secure_file_priv
          • server_uuid
          • sql_auto_is_null
          • sql_mode
          • sql_quote_show_create
          • sql_safe_updates
          • sql_select_limit
          • sql_throttle_current_priority
          • sql_throttle_network
          • sql_throttle_priority
          • sql_throttle_rt
          • sql_transpiler
          • sql_warnings
          • system_time_zone
          • time_zone
          • transaction_isolation
          • transaction_read_only
          • tx_isolation
          • tx_read_only
          • validate_password_check_user_name
          • validate_password_length
          • validate_password_mixed_case_count
          • validate_password_number_count
          • validate_password_policy
          • validate_password_special_char_count
          • version
          • version_comment
          • wait_timeout
        • Session variables
          • enable_sql_plan_monitor
          • is_result_accurate
          • identity
          • last_insert_id
          • ob_capability_flag
          • ob_enable_show_trace
          • ob_global_debug_sync
          • ob_hnsw_ef_search
          • ob_ivf_nprobes
          • ob_last_schema_version
          • ob_org_cluster_id
          • ob_proxy_global_variables_version
          • ob_sparse_drop_ratio_search
          • ob_proxy_partition_hit
          • ob_proxy_set_trx_executed
          • ob_trace_info
          • partition_index_dive_limit
          • range_index_dive_limit
          • timestamp
          • tracefile_identifier
    • Error codes
      • Overview of error messages
      • 0001 ~ 3999
      • 4000 ~ 4499
      • 4500 ~ 4999
      • 5000 ~ 5999
      • 6000 ~ 6999
      • 7000 ~ 7999
      • 8000 ~ 8999
      • 9000 ~ 9499
      • 9500 ~ 9999
      • 10000 ~ 12000
      • 22998, 30926, 38104, 38105
    • LogService reference
      • LogService commands
        • Overview of LS-CTRL
        • LS-CTRL commands
          • bootstrap
          • show az
          • show ln
          • show meta
          • show ap
          • show parameter
          • show v-table
          • add ln
          • delete ln
          • set param
          • check
          • upgrade
          • fetch
          • migrate replica
          • rotate-ak
          • param-version-status
      • LogService parameters
        • Overview of Log Service parameters
        • Cluster parameters
          • min_oblogservice_version
          • node_permanent_offline_time_sec
          • stream_replica_task_history_retention_sec
          • object_store_url
          • log_local_target_retention_sec
          • retained_remote_log_blocks
          • log_local_disk_utilization_threshold
          • max_syslog_file_count
          • enable_rebalance
          • load_balance_policy
          • rebalance_interval_sec
          • metric_sample_save_interval_sec
          • max_utilization_threshold
          • min_utilization_threshold
          • log_disk_throttling_percentage
          • log_disk_throttling_maximum_duration
          • rebuild_log_lag_threshold
        • Server parameters
          • cluster_id
          • region
          • az
          • local_ip
          • rpc_port
          • log_disk_size
          • io_worker_count
          • http_port
          • status_thread_pool_size
          • stack_size
          • net_thread_count
          • enable_heap_profile
          • log_disk_percentage
          • memory_limit
          • log_level
          • max_syslog_file_size
          • disk_max_iops
          • disk_max_bandwidth
          • upload_block_concurrency
          • log_cache_memory_percentage
          • log_cache_evict_scan_budget
          • log_cache_enable_write
          • log_cache_enable_read
          • log_cache_metrics_dump_interval_sec
          • ln_id
          • local_storage_dir
      • LogService views
        • Overview of LogService views
        • List of LogService views
        • Virtual views
          • node_load
          • az_load
          • stream_replica_io
        • Internal tables
          • t_stream_upload_mapping
          • t_resource_event
    • OBKV
      • OBKV overview
      • OBKV architecture
      • OBKV-Table
        • OBKV-Table overview
          • OBKV-Table overview
          • Core features of OBKV-Table
          • OBKV-Table deployment overview
        • Quick start with simple key-value storage (Java)
        • Use the OBKV-Table client
          • Java development guide for OBKV-Table
          • Prepare for development with OBKV-Table
          • Connect to a cluster by using the OBKV-Table Java client
          • OBKV-Table examples
            • Write data to OBKV-Table
            • Query data in OBKV-Table
            • Update data in OBKV-Table
            • Delete data from OBKV-Table
          • Set parameters for the OBKV-Table Java client
        • OBKV-Table management
          • OBKV-Table management overview
          • High availability of OBKV-Table
          • Security permissions of OBKV-Table
          • OBKV-Table monitoring metrics
        • OBKV-Table reference
          • Data model of OBKV-Table
          • OBKV-Table operations
          • Data types supported by OBKV-Table
          • Full-text indexes in OBKV-Table
          • Scope of use and examples of global indexes in OBKV-Table
          • Delete expired data from OBKV-Table
          • Group commit in OBKV-Table
          • Weak-consistency reads and near reads in OBKV-Table
          • OBKV-Table related views
        • OBKV-Table FAQ
      • OBKV-HBase
        • Overview of OBKV-HBase
        • Core features of OBKV-HBase
        • OBKV-HBase deployment
        • OBKV-HBase development
          • Overview of OBKV-HBase application development
          • Connect to a cluster by using the OBKV-HBase Java client
          • Migrate HBase business code to OBKV-HBase
          • Data operation examples
        • OBKV-HBase migration guide
        • OBKV-HBase management
          • Overview of OBKV-HBase management
          • High availability of OBKV-HBase
          • Security and permissions in OBKV-HBase
          • OBKV-HBase monitoring metrics
        • Query optimization in OBKV-HBase
        • Performance testing of OBKV-HBase
        • OBKV-HBase reference
          • OBKV-HBase data model
          • OBKV-HBase data model
          • HBase-compatible interfaces
          • HBase-compatible filters
          • Automatic partition splitting in OBKV-HBase
          • Delete expired data in OBKV-HBase
          • OBKV-HBase weak-consistency reads and near reads
          • OBKV-HBase views
        • OBKV-HBase integrations
          • Flink integration
            • Synchronize data to OBKV-HBase by using the Flink connector
            • Access OBKV-HBase by using native Flink
          • Access OBKV-HBase by using Hive
          • Access OBKV-HBase by using Spark
    • Performance tuning
      • Overview
      • Performance related tools
        • System tools
          • Top general purpose tool
          • CPU tools
          • Memory tools
          • Disk I/O tools
          • Network tools
        • Internal tables
          • GV$SYSSTAT
          • GV$OB_SQL_AUDIT
          • GV$OB_TRANSACTION_PARTICIPANTS
        • Logs
          • slow trans
          • tenant dump info
          • trace log
        • OCP
      • System tuning
        • Operating system parameter tuning
        • Database parameter tuning
          • CPU parameters
          • I/O parameters
          • Memory-related parameters
          • Network transmission parameters
        • ODP parameter tuning
          • CPU-related parameters
          • Network transmission parameters
          • Node routing parameters
      • Performance diagnosis
        • Monitor and diagnose cluster performance
        • Diagnose tenant performance
        • Monitor OBProxy performance
        • Monitor host performance
        • WR management
          • Overview of WR
          • Manage WR
          • Monitor historical session performance
          • Clean up WR data
        • Diagnostic practice: Use TRACE_ID to diagnose materialized view refresh performance issues
        • ASH report
          • Introduction to ASH
          • Generate an ASH report
          • Analyze an ASH report
          • ASH best practices
      • Business model tuning
        • Load balancing
        • SQL diagnostics
        • Distributed transactions
      • SQL tuning
        • SQL request execution process
        • SQL execution plans
          • Introduction to SQL execution plans
          • Execution plan operators
            • TABLE SCAN
            • JOIN
            • GROUP BY
            • WINDOW FUNCTION
            • SUBPLAN FILTER
            • DISTINCT
            • SEQUENCE
            • MATERIAL
            • SORT
            • LIMIT
            • FOR UPDATE
            • SELECT INTO
            • SUBPLAN SCAN
            • UNION
            • INTERSECT
            • EXCEPT/MINUS
            • INSERT
            • DELETE
            • UPDATE
            • EXCHANGE
            • GI
          • Plan cache
          • Fast parameterization
          • Real-time execution plan display
          • SQL optimization practice with EXPLAIN
        • Distributed execution plans
          • Distributed execution and parallel query
          • Distributed plan generation
          • Distributed execution plan scheduling
          • Distributed execution plan management
          • Parallel execution enabling methods and their priority
          • Auto DOP
          • Execution of parallel queries
          • Perform parameter tuning for a parallel query
          • Parallel DML
          • Parallel DDL
        • Parallel execution plans
          • Introduction to parallel execution
          • Classification and optimization of parallel execution
          • Set concurrent execution
            • Concurrency control and queuing
            • Set the degree of parallelism for parallel execution
            • Set parallel execution parameters
          • Diagnose parallel execution issues
          • Tips for parallel execution tuning
          • Quick start of parallel execution
        • SQL tuning
          • Overview of SQL tuning
          • Basic SQL tuning process
          • SQL execution performance monitoring
            • GV$OB_SQL_AUDIT
            • SQL Trace
            • Plan cache views
            • SQL performance analysis example
              • Analyze wait events in queries by using SQL Audit
              • Analyze SQL queries that cause an abrupt RT jitter
              • View and analyze the shape of an execution plan
              • Analyze slow SQL queries
              • Query SQL traffic distribution and QPS
              • Check whether SQL queries are balanced across servers in a cluster
              • Find the TOP N SQL queries
              • Analyze whether an unusually large number of remote execution requests exist in the system or the execution of an SQL statement
              • Find full table scan SQL statements in a tenant
              • Find the TOP N queries with the longest execution time within a certain period
              • Analyze queries related to distributed plans
              • Check whether the RPC execution count of a distributed subplan is balanced across servers in a cluster
          • Optimizer statistics
            • Overview of statistics
            • Statistics collection methods
              • Overview of statistics collection methods
              • Introduction to histograms
              • Collect statistics manually
              • Automatic statistics collection
              • Online statistics collection
              • Dynamic sampling by the optimizer
            • Statistics management
              • Overview of statistics management
              • Delete statistics
              • Set statistics
              • Import and export statistics
              • Lock and unlock statistics
              • Manage statistics history
              • Manage statistics collection strategies (Prefs)
            • Partitioned table statistics collection and update strategy
            • Monitoring and diagnostics for statistics collection
            • Comprehensive example
          • Query rewrite
            • Overview
            • Rule-based query rewriting
            • Cost-based query rewriting
          • Query optimization
            • Access path
              • Overview
              • Rule-based path selection
              • Cost-based path selection
            • Join algorithm
              • Overview
              • Join algorithms
              • Runtime filter
              • Join order
          • Manage execution plans
            • Optimizer hint
            • Plan binding
            • Execution plan management
        • Related terms
        • FAQ on SQL tuning
    • Database proxy
      • Database connection and routing overview
      • OceanBase Database Proxy (ODP)
      • ODP
        • ODP management overview
        • Manage ODP clusters
          • Create an OBProxy cluster
          • Manage parameters of an OBProxy cluster
          • Delete an OBProxy cluster
          • Upgrade all OBProxies in an OBProxy cluster
          • Restart all OBProxies in an OBProxy cluster
          • Manage OceanBase AI Database clusters connected to OBProxy
          • Monitor the performance of an OBProxy cluster
        • Manage ODP
          • Add an OBProxy
          • Start OBProxy
          • Refresh OBProxy configuration
          • Stop OBProxy
          • Restart OBProxy
          • Delete an OBProxy
          • Upgrade OBProxy
        • OBProxy parameters
      • Physical connections
      • Logical connection
        • Query all sessions
        • Query the details of a session
        • Query the statistics of a session
        • Query session variables
        • Terminate a server session
      • Route management
        • Table-based routing of ODP
        • LDC-based routing
        • ODP routing policy
          • Read/write splitting
          • Follower-first read
          • Blocklist mechanism
          • Transaction routing
      • View tenant sessions
      • Terminate a tenant session
      • Set the maximum number of connections for a tenant
    • Drivers
      • OceanBase Call Interface (OBCI)
      • OceanBase Connector/J
      • OceanBase Connector/C
      • OceanBase Connector/ODBC
    • Platforms
      • OceanBase Migration Assessment (OMA)
      • OceanBase Migration Service (OMS)
      • OceanBase Cloud Platform (OCP)
      • OceanBase Developer Center (ODC)
      • OceanBase Admin Toolkit (OAT)
    • Components & tools
      • ob_error
      • Data integration
        • obloader/obdumper
        • OceanBase Binlog Service
        • obcdc
          • Overview of obcdc
          • obcdc parameters
            • Sample configuration file
            • Common obcdc parameters
            • obcdc parameters
          • obcdc development instructions
          • obcdc_tailf
          • Throttling
          • obcdc allowlist and blocklist
          • obcdc supports incremental direct load
          • obcdc supports synchronizing from a standby database
          • Data dictionary support in obcdc
          • FAQ
    • OceanBase AI Database plugins
      • Overview of OceanBase AI Database plugins
      • Tokenizer plugin
      • MySQL external table plugin
  • Release Notes
    • Version number guidelines
    • OceanBase AI Database V4.6.3
    • OceanBase AI Database V4.6.2

Download PDF

Document Feedback
  1. Documentation Center
  2. OceanBase AI Database
  3. V4.6.3

Overview of Metrics

Last Updated:2026-11-19 02:51:02

Query metric items
Metric categories
Network
Request queue
Transactions
SQL
Caching
Storage
Resources
Logs
CLOG
Root Service
ASH
TableAPI
WR
References

Covers key monitoring metrics for all core components of OceanBase AI Database, including its clusters, tenants, and hosts.

Query metric items

You can query the definition information of all monitoring items by executing an SQL statement in the sys tenant. Example:

obclient> SELECT STAT_ID, CLASS, NAME FROM V$STATNAME;

Many monitoring items are related to the internal implementation and may be changed or deleted. The actual situation shall prevail. For details about specific monitoring item categories, see Monitoring Items.

Metric categories

OceanBase AI Database supports monitoring over 600 metrics across 15 major categories, covering all critical execution aspects such as network, request queue, transactions, SQL, caching, storage, resource quotas, and logs. The specific categories are as follows:

Monitoring Item Category ID
Metric Category
Monitoring Item Category Description
1 NETWORK Network
2 QUEUE request queue
4 TRANS Transaction
8 SQL SQL
16 CACHE cache
32 STORAGE Storage
64 RESOURCE Resource
128 DEBUG Log
256 CLOG CLOG
512 ELECT election
1024 OBSERVER system
2048 RS Root Service
3072 Time Model Time Model
4096 TABLEAPI TableAPI
8192 WR WR

Network

Metric ID
Type of the monitored item
Metric name
Description
10000 1 rpc packet in The cumulative number of RPC packets received by the tenant. The count increments by 1 whenever the tenant receives an RPC request or receives a response packet after sending an RPC request.
10001 1 rpc packet in bytes The cumulative number of bytes of RPC packets received by the tenant, in bytes. It is calculated by adding the byte size of each RPC request received by the tenant or the byte size of each response packet received after sending an RPC request.
10002 1 rpc packet out The cumulative number of RPC packets sent by the tenant. The count increments by 1 each time a tenant sends an RPC request or responds to an RPC request it receives.
10003 1 rpc packet out bytes The cumulative number of bytes of RPC packets sent by the tenant, in bytes. This value is calculated by adding the byte count of each RPC request sent by the tenant or each response packet sent in reply to an RPC request received by the tenant.
10004 1 rpc deliver fail The total number of failures in forwarding RPC requests to the tenant's work queue. This count is incremented when an RPC request fails to be forwarded to the tenant queue during RPC IO forwarding.
10005 1 rpc net delay The cumulative network transmission delay of RPC requests received by a tenant, in microseconds. After an RPC I/O thread parses an RPC request, it obtains the current timestamp, subtracts the send timestamp obtained from the packet header to get the difference, and adds this value to RPC_NET_DELAY.
10006 1 rpc net frame delay The cumulative network framework processing time received by a tenant for RPC requests, in microseconds. When an RPC IO forwards an RPC request to the tenant queue, it obtains the current timestamp, subtracts the timestamp recorded when the RPC packet was parsed, and adds the difference to RPC_NET_FRAME_DELAY.
10007 1 mysql packet in The cumulative number of SQL request packets received by the tenant. This value is incremented by 1 each time a network thread decodes a complete SQL request packet.
10008 1 mysql packet in bytes The cumulative size of SQL request packets received by the tenant, in bytes. The size of the original data packets received by the network thread, obtained according to protocol rules.
10009 1 mysql packet out The cumulative number of response packets returned by the tenant for SQL requests. When a network thread returns a packet, the counter increments by 1 for each fully encoded packet.
10010 1 mysql packet out bytes The cumulative value of the bytes returned in response to SQL requests for a tenant, in bytes. When encoding the result set, the encoding size is accumulated.
10011 1 mysql deliver fail The cumulative number of times a tenant's SQL login request fails to be placed into the login queue and other requests fail to be placed into the worker thread queue. For login requests, this value increments by 1 if the login request thread queue is full. For other requests, this value increments by 1 if the tenant's worker thread queue is full.
10012 1 rpc compress original packet cnt The cumulative number of RPC requests sent by the tenant that specify compression. This count increments by 1 whenever an RPC request is sent with the compressor_type parameter set.
10013 1 rpc compress compressed packet cnt The cumulative number of compressed RPC requests sent by tenants. When an RPC is sent, if the compressor_type is set and the compression succeeds (the compressed byte count is less than the original byte count), the counter increments by 1.
10014 1 rpc compress original size The RPC request sent by the tenant specifies the original byte size of the request to be compressed, in bytes. When an RPC is sent, if its compressor_type is set, the original byte size of the uncompressed RPC packet is accumulated in the RPC_COMPRESS_ORIGINAL_SIZE metric.
10015 1 rpc compress compressed size The cumulative size of compressed RPC requests sent by the tenant, in bytes. When an RPC is sent, if the compressor_type is set and compression succeeds, the compressed byte count is accumulated in the RPC_COMPRESS_COMPRESSED_SIZE metric.
10016 1 rpc stream compress original packet cnt Retained only in code, in occurrences.
10017 1 rpc stream compress compressed packet cnt Retained only in code, in occurrences.
10018 1 rpc stream compress original size Retained only in code, in bytes.
10019 1 rpc stream compress compressed size Retained only in code, in bytes.
110000 1 standby fetch log bytes The cumulative amount of data received via RPCs during network standby database synchronization on the OBServer node, in bytes. When data is received via RPCs during network standby database synchronization, the number of bytes received is accumulated in the STANDBY FETCH_LOG_BYTES metric.
110001 1 standby fetch log bandwidth limit The bandwidth allocated to an OBServer node when network throttling is enabled for standby database synchronization. The unit is bytes. After network throttling is enabled for standby databases, the RS node allocates bandwidth to nodes in the cluster according to the set policy. After receiving the bandwidth allocated by the RS node, the OBServer node records it in the STANDBY FETCH_LOG_BANDWIDTH_LIMIT metric.

Request queue

Metric ID
Type of the monitored item
Metric name
Description
20000 2 request enqueue count Indicates the total number of requests in the queue for a tenant. The count increments by 1 each time a request is placed into the worker thread queue.
20001 2 request dequeue count Indicates the total number of requests that have exited the queue for a tenant. The count increments by 1 each time a request exits the worker thread queue.
20002 2 request queue time The total time spent by all request queues of a tenant, in microseconds. When a tenant worker thread receives a request, it calculates the queue time by subtracting the time when the request entered the queue from the current time, and accumulates this value in the REQUEST_QUEUE_TIME metric.

Transactions

Metric ID
Type of the monitored item
Metric name
Description
30000 4 trans commit log sync time The cumulative time consumed by a transaction's clogs being successfully committed to a majority of replicas on this server, in microseconds. When the majority of replicas have successfully processed the clogs and the callback to the transaction layer is triggered, the current time is subtracted from the time when the clogs were successfully committed to calculate the time spent by the majority. This time is then accumulated to this statistic.
30001 4 trans commit log sync count The number of majorities of clogs successfully submitted by the tenant on this server. Each time a majority of clogs is successfully submitted, a callback is sent to the transaction layer, which increments the count upon receiving the callback.
30002 4 trans commit log submit count The number of clogs submitted by this tenant on this server. The count increases by 1 after each successful clog submission (not guaranteed to be a majority success).
30005 4 trans start count The number of transactions started by the tenant on this server. This statistic increases each time a transaction is successfully started on the OBServer node where the session is created.
30006 4 trans total used time The cumulative transaction time of the tenant on this server, in microseconds. After each transaction on the OBServer node where the session is created is completed, the cumulative transaction time is added to this statistic.
30007 4 trans commit count The number of successfully committed transactions for this tenant on the server. The count increases by 1 each time a transaction is successfully committed on the OBServer node where the session is connected.
30008 4 trans commit time The cumulative transaction commit time of the tenant on this server, in microseconds. After each successful transaction commit on the OBServer node where the session is created, the cumulative commit time is added to this statistic.
30009 4 trans rollback count The number of transactions successfully rolled back for this tenant on the server. This statistic is incremented each time a transaction is successfully rolled back on the OBServer node where the session was created.
30010 4 trans rollback time The transaction rollback time of the tenant on the server, in microseconds. This statistic accumulates the cumulative rollback time on the OBServer node where the session is created after each successful rollback.
30011 4 trans timeout count The number of transactions that time out for this tenant on the server. This statistic increases each time a transaction times out on the OBServer node where the session is created.
30012 4 trans local trans count The number of single-phase transactions terminated on this server for the tenant (including both commits and rollbacks). This count is incremented whenever the number of participants equals 1 after a transaction is terminated on the OBServer node where the session was created.
30013 4 trans distribute trans count The number of distributed transactions terminated on this server for the tenant (including both commits and rollbacks). Each time a transaction is terminated on the OBServer node where the session was created, the number of participants is checked. If the number of participants is greater than 1, this counter is incremented.
30017 4 trans without participant count The number of read-only transactions terminated on this server for the tenant (including both committed and rolled-back transactions). This count is incremented whenever the number of participants equals zero after a transaction is terminated on the OBServer node where the session was created.
30018 4 redo log replay count The number of redo logs replayed for a transaction within a tenant. This count increments by 1 each time the redo logs of that transaction are replayed.
30019 4 redo log replay time The cumulative time consumed for replaying redo logs of transactions within a tenant, in microseconds. Each time redo logs are replayed, the time consumed for that replay is recorded and added to this statistic.
30020 4 prepare log replay count The number of prepared logs rolled back within a tenant. The count increments by 1 each time a prepared log of a transaction is rolled back.
30021 4 prepare log replay time The cumulative time consumed in replaying prepare logs for transactions within a tenant, in microseconds. Each time prepare logs are replayed, the time spent on that replay is recorded and added to this statistic.
30022 4 commit log replay count The number of times a transaction's commit log has been rolled back within the tenant. This count increases by 1 each time the transaction's commit log is rolled back.
30023 4 commit log replay time The cumulative time consumed for replaying commit logs of transactions within a tenant. Each time commit logs are replayed, the time spent on that replay is recorded and added to this statistic.
30024 4 abort log replay count The number of aborted logs rolled back within a tenant. The count increments by 1 each time an aborted log is successfully rolled back.
30025 4 abort log replay time The cumulative time consumed in replaying abort logs for transactions within a tenant, in microseconds. Each time an abort log is replayed, the time consumed for that replay is recorded and added to this statistic.
30026 4 clear log replay count The number of cleared logs for transactions rolled back within the tenant. This count increments by 1 each time a transaction's cleared logs are rolled back.
30027 4 clear log replay time The cumulative time consumed in replaying clear logs for transactions within a tenant, in microseconds. Each time clear logs are replayed, the time consumed for that replay is recorded and added to this statistic.
30053 4 gts request total count The total number of GTS requests processed by the GTS server. The count is incremented when the GTS server finishes processing a GTS request.
30054 4 gts acquire total time For GTS acquisition in asynchronous scenarios, this metric indicates the total waiting time for obtaining GTS, in microseconds. The waiting time is incremented when GTS is acquired. This feature is not yet implemented, so this metric is currently meaningless.
30056 4 gts acquire total wait count For GTS acquisition in asynchronous scenarios, this metric indicates the total number of GTS acquisitions. The count increments by 1 whenever a GTS is acquired.
30063 4 gts wait elapse total time For GTS async scenarios, the total wait time for GTS to be pushed is in microseconds. The wait time increases when GTS is pushed.
30065 4 gts wait elapse total wait count Total number of times waiting for data pushed by GTS in GTS asynchronous scenarios. Unit: microseconds. The count increments by 1 when data is pushed by GTS.
30077 4 trans early lock release enable count The unit is times.
30078 4 trans early lock release unable count The unit is times.
30079 4 read elr row count Total number of rows for which the row lock is released early during write operations to the MemTable. The number of data rows for which the row lock is successfully released early during write operations to the MemTable.
30080 4 local trans total used time The cumulative duration of single-phase transactions ended on this server for the tenant, in microseconds. This statistic is accumulated on the OBServer node where the session is created, whenever the number of transaction participants equals 1 after a transaction is ended.
30081 4 distributed trans total used time The cumulative duration of distributed transactions ended on this server for the tenant, including both commit and rollback terminations. The unit is microseconds. After each transaction is terminated on the OBServer node where the session was created, the number of participants is checked. If the number of participants is greater than 1, the transaction duration is accumulated to this statistic.
30082 4 tx data hit mini cache count The number of times a transaction data table is hit in the MINI Cache. The MINI Cache is the highest-speed cache for TxData, and a higher hit rate indicates better performance. (The MINI Cache is a request-level cache, with one per Access Context.) The counter increments by 1 each time a TxData record is read from the MINI Cache.
30083 4 tx data hit kv cache count The number of times that a transaction's data is hit in the KVCache when reading. The performance of the KVCache is slightly weaker than that of the MiniCache. Most read requests are expected to hit the KV or MiniCache. The counter increments by 1 each time a TxData record is read from the KVCache.
30084 4 tx data read tx ctx count The number of times the transaction context table is hit when reading transaction data. The counter increments by 1 each time a TxData record is read from the transaction context table.
30085 4 tx data read tx data memtable count The number of times that a read from the transaction data table's MemTable fails to hit the cache. The counter increments by 1 each time a TxData record is read from the transaction data table's MemTable.
30086 4 tx data read tx data sstable count The number of times TxData is read from the SSTable of a transaction data table during transaction data reading. (Reading TxData from an SSTable is the least efficient operation, so this metric is not expected to be high.) The counter increments by 1 each time one TxData record is read from the SSTable of a transaction data table.
30200 4 xa start total count For XA transactions, the total number of XA_START statements, including both successful and failed ones. The count increments by 1 after the transaction-side logic of XA_START is executed.
30201 4 xa start total used time For XA transactions, the total execution time of the XA_START statement, including both successful and failed cases, in microseconds. After the transaction side completes the XA_START logic, it adds the consumption time for local processing.
30202 4 xa start with rpc total count The total number of XA_START statements executed remotely for XA transactions, including only successful ones. The count increments by 1 if an XA_START statement is executed remotely and successfully after the transaction-side logic completes.
30203 4 failed xa start total count The total number of failed executions of the XA_START statement for XA transactions. The count increments by 1 if the XA_START logic execution fails on the transaction side.
30204 4 xa end total count For XA transactions, the total number of times the XA_END statement is executed, including both successful and failed executions. The count increments by 1 after the transaction-side logic for XA_END is completed.
30205 4 xa end total used count For XA transactions, the total execution time of the XA_END statement, in microseconds. After the transaction side completes the XA_END logic, it adds the consumption time for local processing.
30206 4 xa end with rpc total count The total number of successfully executed XA_END statements remotely for XA transactions. The count increments by 1 if the XA_END logic is executed remotely and succeeds after the transaction-side execution is complete.
30207 4 failed xa end total count The total number of failed executions of the XA_END statement for XA transactions. The count increments by 1 when an error occurs during the execution of the XA_END statement on the transaction side.
30208 4 xa prepare total count For XA transactions, the total number of XA_PREPARE statements, including both successful and failed ones. The count increments after the transaction-side logic completes the XA_PREPARE statement.
30209 4 xa prepare total used time For XA transactions, the total execution time of XA_PREPARE statements, including both successful and failed ones, in microseconds. After the transaction side completes the XA_PREPARE logic, it adds the consumption time for local processing.
30210 4 xa prepare with rpc total count The total number of XA_PREPARE statements executed remotely for XA transactions, including only successful ones. The count increments by 1 if an XA_PREPARE statement is executed remotely and succeeds after the transaction-side XA_START logic is completed.
30211 4 failed xa prepare total count The total number of failures in executing the XA_PREPARE statement for XA transactions. This count is incremented when the XA_PREPARE logic fails to execute on the transaction side.
30212 4 xa commit total count For XA transactions, the total number of XA_COMMIT statements executed, including both successful and failed ones. The count increments by 1 after the transaction-side completes the XA_COMMIT logic.
30213 4 xa commit total used time For XA transactions, the total execution time of the XA_COMMIT statement, in microseconds. After the transaction side completes the XA_COMMIT logic, it adds the consumption time for local processing.
30214 4 xa commit with rpc total count For XA transactions, the total number of XA_COMMIT statements executed remotely, including only successful ones. The count increments by 1 if an XA_COMMIT operation is executed remotely and succeeds after the transaction-side logic completes.
30215 4 failed xa commit total count Total number of XA COMMIT statements that failed to execute for XA transactions. The count increments by 1 when an error occurs during the execution of an XA COMMIT statement on the transaction side.
30216 4 xa rollback total count For XA transactions, the total number of XA_ROLLBACK statements, including both successful and failed ones. The count increments by 1 after the transaction-side logic of XA_ROLLBACK is executed.
30217 4 xa rollback total used time For XA transactions, the total execution time of XA_ROLLBACK statements, including both successful and failed ones, in microseconds. After the transaction side completes the XA_ROLLBACK logic, it adds the consumption time for local processing.
30218 4 xa rollback with rpc total count The total number of XA_ROLLBACK statements executed remotely for XA transactions, including only successful ones. This value increments by 1 if an XA_ROLLBACK statement is executed remotely and succeeds after the transaction-side logic of XA_START is completed.
30219 4 failed xa rollback total count The total number of failed executions of the XA_ROLLBACK statement for XA transactions. This count is incremented when the XA_ROLLBACK logic fails to execute on the transaction side.
30220 4 started xa trans count For XA transactions, the total number of successfully started XA transactions. The count increments by 1 after an XA transaction is successfully started on the transaction side.
30221 4 read only xa trans total count Total number of read-only XA transactions. This count is incremented when a transaction is committed as a read-only XA transaction.
30222 4 xa trans with one phase commit total count The total number of XA transactions with one-phase commit. This count increments when an XA transaction is committed using the one-phase commit protocol on the transaction side.
30223 4 inner sql total count in xa statement For XA transactions, the total number of inner SQL statements executed during the XA logic execution. When the transaction side executes the XA logic, the count increments by 1 after each inner SQL statement is executed.
30224 4 total count of inner sql (latency >= 10ms) in xa statement For XA transactions, the total number of INNER SQL statements whose execution time exceeds 10 ms during the execution of XA logic. When the transaction side executes XA logic, if the execution time of an INNER SQL statement exceeds 10 ms, the count is incremented by 1.
30225 4 total count of inner sql (latency >= 20ms) in xa statement For XA transactions, the total number of INNER SQL statements whose execution time exceeds 20 ms during the execution of XA logic. When the transaction side executes XA logic, if the execution time of an INNER SQL statement exceeds 20 ms, the count is incremented by 1.
30226 4 inner sql total used time in xa statement For XA transactions, this is the total execution time of inner SQL statements in microseconds during the execution of XA logic. When the transaction side executes XA logic, the execution time of inner SQL statements is accumulated upon completion of each inner SQL statement.
30227 4 inner rpc total count in xa statement For an XA transaction, the total number of RPCs in the execution of XA logic. The count increments by 1 each time an RPC is called when executing XA logic on the transaction side.
30228 4 total count of inner rpc (latency >= 10ms) in xa statement For XA transactions, the total number of RPCs whose execution time exceeds 10 ms during the execution of XA logic. The count increments by 1 for each RPC that exceeds 10 ms when executing XA logic on the transaction side.
30229 4 total count of inner rpc (latency >= 20ms) in xa statement For XA transactions, the total number of RPCs whose execution time exceeds 20 ms in the XA logic. When executing XA logic on the transaction side, if an RPC takes more than 20 ms to execute, the count is incremented by 1.
30230 4 inner rpc total used time in xa statement For an XA transaction, this is the total time consumed by RPCs during the execution of the XA logic, in microseconds. When executing XA logic on the transaction side, the RPC consumption time increases after each RPC call.
30231 4 dblink trans total count Total number of DBlink transactions. The count increments by 1 when a DBlink transaction is started.
30232 4 failed dblink trans total count Total number of failed DBlink transactions. The count increments when a DBlink transaction is initiated and fails.
30233 4 dblink trans promotion total count The total number of times a regular transaction is upgraded to a DBlink transaction. The count increments by 1 when a regular transaction is upgraded to a DBlink transaction.
30234 4 dblink trans callback total count Total number of transaction calls for reverse link recovery. The count increments by 1 when a transaction is recovered via reverse link.
30235 4 dblink trans commit total count The total number of transactions committed by DBlink. The count is incremented when a DBlink transaction executes a COMMIT statement.
30236 4 dblink trans commit total used time For DBlink transactions, this is the total time consumed by a DBlink transaction in committing, in microseconds. When a DBlink transaction executes a commit statement, the time consumed for this commit is added.
30237 4 failed dblink trans commit total count The total number of failed DBlink transaction commits. The count increments when a DBlink transaction executes a commit statement and fails.
30238 4 dblink trans rollback total count Total number of rollbacks for DBlink transactions. The count increments by 1 when a DBlink transaction executes a Rollback statement.
30239 4 dblink trans rollback total used time For DBlink transactions, this is the total time consumed for rolling back a DBlink transaction, in microseconds. When a DBlink transaction executes a Rollback statement, the time consumed by this rollback is added.
30240 4 failed dblink trans rollback total count The total number of failed DBlink transaction rollbacks. This count increments when a DBlink transaction executes a Rollback statement and fails.

SQL

Metric ID
Type of the monitored item
Metric name
Description
40000 8 sql select count Number of SQL SELECT executions.
40001 8 sql select time Total SQL SELECT execution time, in microseconds.
40002 8 sql insert count Total number of INSERT statements issued by users.
40003 8 sql insert time Total time consumed by user INSERT statements.
40004 8 sql replace count Total number of REPLACE statements issued by the user.
40005 8 sql replace time Total time consumed by the REPLACE statements issued by the user.
40006 8 sql update count Total number of UPDATE statements issued by users.
40007 8 sql update time Total time consumed by user-initiated UPDATE statements, in microseconds.
40008 8 sql delete count The total number of DELETE statements issued by users.
40009 8 sql delete time Total time consumed by user-issued DELETE statements, in microseconds.
40010 8 sql local count Number of SQL LOCAL executions.
40011 8 sql remote count Number of SQL REMOTE executions.
40012 8 sql distributed count The number of distributed executions of the SQL statement.
40013 8 active sessions The number of active sessions. The number of active sessions increases by 1 for new connections and decreases by 1 for disconnected connections.
40014 8 single query count Total number of statements sent over a non-multiple query protocol.
40015 8 multiple query count Total number of statements sent over the multiple query protocol.
40016 8 multiple query with one stmt count The number of statements sent in the multiple query protocol but actually containing only one SQL statement. The number of statements sent in the multiple query protocol but actually containing only one SQL statement.
40018 8 sql other count The number of executions of SQL statements other than SELECT, INSERT, REPLACE, UPDATE, DELETE, COMMIT, and ROLLBACK.
40019 8 sql other time Total execution time of SQL statements other than SELECT, INSERT, REPLACE, UPDATE, DELETE, COMMIT, and ROLLBACK, in microseconds.
40020 8 ps prepare count Number of PREPARE statements executed by PREPARE STATEMENT.
40021 8 ps prepare time The total time taken to execute the PREPARE statement in microseconds.
40022 8 ps execute count Number of times PREPARE STATEMENT executes EXECUTE.
40023 8 ps close count Number of CLOSE operations performed during PREPARE STATEMENT execution.
40024 8 ps close time Total time taken to execute CLOSE for PREPARE STATEMENT, in microseconds.
40025 8 sql commit count The number of COMMIT operations performed during SQL statement execution.
40026 8 sql commit time Total time spent on executing COMMIT operations, in microseconds. Cumulative COMMIT execution time.
40027 8 sql rollback count Number of Rollback executions.
40028 8 sql rollback time Total time taken for the rollback, in microseconds.
40030 8 opened cursors current The number of currently open cursors. The count increases by 1 when a cursor is opened and decreases by 1 when a cursor is closed.
40031 8 opened cursors cumulative The cumulative number of open cursors. The cumulative number of open cursors increases by 1 for each cursor opened.
40102 8 sql inner insert count The total number of INSERT statements issued by the inner SQL is less than 1.
40103 8 sql inner insert time Total time consumed by INSERT statements issued by INNER SQL, in microseconds1.
40104 8 sql inner replace count The total number of REPLACE statements issued by the INNER SQL statement1.
40105 8 sql inner replace time Total time consumed by the REPLACE statement issued by the INNER SQL, in microseconds1.
40106 8 sql inner update count The total number of UPDATE statements issued by INNER SQL 1.
40107 8 sql inner update time The total time consumed by the update statements issued by INNER SQL, in microseconds1.
40108 8 sql inner delete count The total number of DELETE statements issued by the inner SQL 1.
40109 8 sql inner delete time The total time consumed by the DELETE statement issued by INNER SQL, in microseconds1.
40112 8 user logons cumulative The cumulative number of logins of the user.
40113 8 user logouts cumulative The cumulative number of times a user has logged out. This count increments by 1 each time the user disconnects from the session.
40114 8 user logons failed cumulative Cumulative number of login failures. The process of connecting to an OBServer node and establishing a session fails.
40115 8 user logons time cumulative Cumulative login time of the user, in microseconds. This is the cumulative time spent on logging in and creating a session.
40117 8 sql remote execute time Total SQL REMOTE execution time, in microseconds. Total SQL REMOTE execution time.
40118 8 sql distributed execute time Total time for distributed execution of SQL statements, in microseconds. The total time for distributed execution is the cumulative time spent on distributed execution.
40119 8 sql fail count The number of SQL execution failures.
40120 8 inner sql local count Number of times INNER SQL LOCAL is executed.
40121 8 inner sql remote count Number of times INNER SQL statements are executed remotely.
40122 8 inner sql distributed count Number of times INNER SQL statements are executed in distributed mode.

Note

Note 1: INNER SQL refers to SQL statements that are not sent by users but are internally generated by OceanBase AI Database, typically used to query or modify internal tables.

Caching

Metric ID
Type of the monitored item
Metric name
Description
50000 16 row cache hit The table_get operator counts the number of times a data row is hit in the cache during prefetching. In the lookup_in_cache function, it determines whether the data row is in the cache; if a hit occurs, this counter is incremented by 1.
50001 16 row cache miss The number of times the table get operator prefetches data rows without hitting the cache. In the lookup_in_cache function, this field is incremented if the data row is not in the cache.
50004 16 bloom filter cache hit The number of cache hits for the macroblock Bloom filter indicates that the SQL statement uses a pre-built macroblock Bloom filter2.
50005 16 bloom filter cache miss The number of cache misses for the macroblock Bloom filter indicates that the corresponding macroblock Bloom filter has not been constructed.2
50006 16 bloom filter filts The number of effective filter hits for the macroblock Bloom filter, where rows corresponding to each other do not exist2.
50007 16 bloom filter passes The number of times the macroblock Bloom filter did not filter the data, indicating that the corresponding row may contain 2.
50008 16 block cache hit The number of times a microblock hit the block cache when fetched. When fetching a microblock, it is checked whether the microblock is in the cache. If the cache is hit, this metric increments by 1.
50009 16 block cache miss The number of times a microblock is fetched without hitting the block cache. When fetching a microblock, it is checked whether the microblock is in the cache. If the cache is not hit, this counter increments by 1.
50010 16 location cache hit Number of location cache hits. This includes the number of cache hits for ls_location_cache and tablet_ls_cache. When querying the mapping between tablets and logstreams or the location information of a logstream, if valid data is successfully retrieved from the local cache, the statistic value is incremented by 1. This is triggered in the get method of ObTabletLSService and ObLSLocationService.
50011 16 location cache miss The number of location cache misses. This metric records the number of misses in the ls_location_cache and tablet_ls_cache caches. It increments when valid data cannot be obtained from the local cache (e.g., the cache does not exist, has expired, or is invalid) while querying the mapping between tablets and logstreams or the location information of a logstream. It also increments in the get methods of ObTabletLSService and ObLSLocationService when is_cache_hit is false.
50012 16 location cache wait The number of times a thread is blocked and waits when the concurrency for obtaining locations from the OceanBase Location Cache reaches the upper limit. When the Location Cache concurrently retrieves location information, if the current concurrency has reached the maximum limit (max_count), the thread must wait on the semaphore. The count increments by 1 each time a thread enters a waiting state in the ObLocationSem::acquire method. This event is triggered when has_wait is true, and it is used to control the concurrency level for acquiring location information, preventing excessive concurrent requests from putting pressure on the system.
50013 16 location cache get hit from proxy virtual table From __all_virtual_proxy_schema Gets the number of hits in the location cache. When querying tablet location information through a proxy virtual table (ObAllVirtualProxySchema), if the mapping between tablets and logstreams and the logstream location information can be successfully retrieved from the cache, this statistic value is incremented by 1.
50014 16 location cache get miss from proxy virtual table From __all_virtual_proxy_schema Gets the number of location cache misses. When querying tablet location information through a proxy virtual table (ObAllVirtualProxySchema), if the mapping between a tablet and its logstream or the logstream location information cannot be retrieved from the cache, this statistic increments by 1.
50017 16 location nonblock get hit Indicates the number of hits for non-blocking reads from the ls_location_cache and tablet_ls_cache. When using the nonblock_get method to query the mapping between a tablet and a logstream or the location information of a logstream, if valid data is successfully retrieved from the local cache, the statistic value is incremented by 1. In ObTabletLSService::nonblock_get and ObLSLocationService::nonblock_get In the method, it is triggered when OB_SUCC(ret) is true. Unlike the regular get method, nonblock_get does not wait for cache updates and returns the result immediately.
50028 16 kvcache sync wash time The time consumed by flushing the memory of the cache during synchronization when insufficient memory is available, in microseconds. This value is the sum of the time spent on flushing the cache when try_flush_washable_mb is called and executed.
50029 16 kvcache sync wash count The number of times the memory for flushing the cache is insufficient. This value increments when the try_flush_washable_mb function is called and cache flushing is performed.
50033 16 fuse row cache hit The table get operator counts the number of times a non-MEMTable row is hit in the cache. In the get_fuse_row_cache function, this counter increments if the row corresponding to the rowkey is found in the cache.
50034 16 fuse row cache miss The number of times the table get operator fails to hit the cache when reading non-MEMTable rows. In the get_fuse_row_cache function, this field increments by 1 if the row corresponding to the rowkey is not in the cache.
50035 16 schema cache hit The number of times a schema is successfully retrieved from the schema cache. When querying a schema, if the corresponding schema information is successfully obtained from the local cache, the statistic value is incremented by 1. In ObSchemaCache::get_schema In the method, when cache_.get() Triggered when the call is successful.
50036 16 schema cache miss The number of times that the schema could not be obtained from the schema cache. When querying a schema, if the corresponding schema information cannot be retrieved from the local cache (the cache does not exist, has expired, or is invalid), this statistic increments by 1. In ObSchemaCache::get_schema In the method, when cache_.get() Triggered when the call fails.
50037 16 tablet ls cache hit The number of times a cache hit occurs when reading a tablet. In the get_from_cache_ function, this field is incremented if the tablet is found in the cache.
50038 16 tablet ls cache miss The number of times that a tablet is not found in the cache when being read. In the get_from_cache function, this field increments by 1 if the tablet is not in the cache.
50045 16 opt table stat cache hit The hit rate of the table/partition-level statistics cache. If a hit occurs, the statistics are directly read from memory. The unit is percentage. KVCache records the hit rate of the table/partition-level statistics cache.
50046 16 opt table stat cache miss The miss rate of the table/partition-level statistics cache. If a cache miss occurs, statistics must be loaded from the internal table into memory. The unit is percentage. KVCache records the miss rate of the table/partition-level statistics cache.
50047 16 opt column stat cache hit The hit rate of the column-level statistics cache. If a hit occurs, the statistics are directly read from memory. The unit is percentage. KVCache measures the hit rate of the column-level statistics cache.
50048 16 opt column stat cache miss The miss rate of the column-level statistics cache. If a cache miss occurs, statistics must be loaded from the internal table into memory. The unit is percentage. KVCache records the miss rate of the column-level statistics cache.
50049 16 tmp page cache hit The number of cache hits for temporary files during page reads. Temporary files on shared storage do not use block caching; instead, they are organized in an 8KB page cache. Before reading data, the system first queries the KVCache. If a hit occurs, the data is read from the KVCache and the hit count is incremented by 1.
50050 16 tmp page cache miss The number of misses in the page cache for temporary files during read operations. Temporary files on shared storage do not use block caching; instead, they are cached as 8KB pages. Before reading data, a query is performed against the KVCache. If the cache miss, an I/O operation is initiated, and the miss count is incremented by 1.
50051 16 tmp block cache hit The number of hits when reading temporary files from a 2 MB block cache. Before reading data from disk, the system first checks if the data is cached in the KVCache. If a hit occurs, the data is read directly from the cache and the hit count is incremented by 1.
50052 16 tmp block cache miss The number of misses in the temporary file block cache when reading temporary files.
50055 16 opt ds stat cache hit The hit rate of the statistics cache collected by dynamic sampling. If a hit occurs, the result in memory is directly read. The unit is percentage. KVCache statistics record the hit rate of the dynamic sampling statistics cache.
50056 16 opt ds stat cache miss The cache miss rate of statistics collected by dynamic sampling. If a cache miss occurs, sampling SQL collection is required. The unit is percentage. KVCache records the cache hit rate of statistics collected by dynamic sampling.
50057 16 storage meta cache hit The number of hits in the secondary and tertiary metadata cache. Some larger metadata (over 1 KB), such as table schemas and multiple SSTables, is stored on data tablets. These metadata can be accessed on demand and do not need to reside in memory constantly. Therefore, we manage the memory lifecycle of these structures using a KVCache approach. These two metrics are the hit statistics for the metadata KVCache.
50058 16 storage meta cache miss The number of misses in the secondary and tertiary metadata cache. Some larger metadata (greater than 1 KB), such as table schemas and multiple SSTables, is stored on data tablets. These metadata can be accessed on demand and do not need to reside in memory constantly. Therefore, we manage the memory lifecycle of these structures using a KVCache approach. These two metrics are the hit statistics for the metadata KVCache.
50059 16 tablet cache hit The number of cache hits for storing tablet shards. A tablet, or data shard, is a common structure used in many processes. When a tenant supports a large number of partitions, limited memory cannot guarantee that all tablets are resident in memory. Therefore, we use KVCache to manage and maintain the memory lifecycle of tablets. These metrics relate to the cache hit rate of tablets.
50060 16 tablet cache miss The number of cache misses for storing tablet shards. A tablet, or data shard, is a common structure used in many processes. When a tenant supports a large number of partitions, limited memory cannot guarantee that all tablets are resident in memory. Therefore, we use KVCache to manage the memory lifecycle of tablets. These metrics are related to the cache hit rate of tablets.
50061 16 schema history cache hit Number of schema history cache hits. Schema history cache storage schema_type, tenant_id, schema_id, schema_version The mapping relationship from the current version number to the precise schema version number, so as to avoid repeatedly querying system tables for the exact version number. If the corresponding precise schema version number is successfully obtained from the history cache, the statistic value is incremented by 1.
50062 16 schema history cache miss Number of schema history cache misses. The schema history cache stores schema_type, tenant_id, schema_id, schema_version The mapping relationship from the current version to the precise schema version, avoiding repeated queries to system tables for the exact version number. If the corresponding precise schema version cannot be obtained from the history cache (the cache does not exist, has expired, or is invalid), the statistic value is incremented by 1.
50063 16 opt system stat cache hit The cache hit rate of the cost model system parameters. If a hit occurs, the cached result in memory is directly read. The unit is percentage. KVCache statistics for the cost model parameter cache hit rate.
50064 16 opt system stat cache miss The cache hit rate of cost model system parameters. If a cache miss occurs, the cost model-related parameters need to be loaded from the internal table. The unit is percentage. KVCache records the cost model parameter cache miss rate.
50065 16 log kv cache hit The number of hits in the cold cache. When reading logs from PALF, if the hot cache does not provide a hit, it attempts to read from the cold cache. If the requested log is found in the cold cache, this statistic increments by 1.
50066 16 log kv cache miss The number of misses in the cold cache. When reading logs from PALF, if the hot cache does not provide a hit, it attempts to read from the cold cache. If the requested log is not in the cold cache, this statistic increments by 1.
50067 16 data block cache miss The number of times that a data microblock was not found in the block cache when fetched. When fetching a data microblock, it is checked whether the microblock is in the cache. If the cache miss occurs, this counter increments by 1.
50068 16 index block cache miss The number of times that the block cache was not hit when retrieving intermediate index microblocks. When retrieving intermediate index microblocks, it is determined whether the data microblock is in the cache. If the cache is not hit, this counter increments by 1.
50069 16 multi version fuse row cache hit The number of times the table get operator hit the cache when reading rows from a materialized view. get_fuse_row_cache In the function, if the table is a materialized view, it checks whether the row corresponding to the rowkey is in the cache. If it hits the cache, this item is incremented by 1.
50070 16 multi version fuse row cache miss The number of times that the table GET operator failed to hit the cache when reading rows from a materialized view. get_fuse_row_cache In the function, if the table is a materialized view, it checks whether the row corresponding to the rowkey is in the cache. If the cache does not hit, this counter is incremented by 1.
50071 16 backup index cache hit Number of cache hits for backup index. Backup indexes are placed in the cache. During restore, the cache is read first; if not found, the backup media is read.
50072 16 backup index cache miss Number of backup index cache misses. Backup indexes are placed in the cache. During restore, the cache is read first; if not found, the backup media is read.
50073 16 backup meta cache hit Number of cache hits for backup metadata. Backup metadata is placed in the cache. During restore, the cache is read first; if not found, the backup media is read.
50074 16 backup meta cache miss Number of cache hits for backup metadata. Backup metadata is placed in the cache. During restore, the cache is read first; if not found, the backup media is read.
50075 16 truncate info cache hit The number of times the cache is hit when reading truncate info. In the get_truncate_info_array function, this field indicates whether the truncate info is in the cache. If the cache is hit, the value of this field is incremented by 1.
50076 16 truncate info cache miss The number of times that the cache was not hit when reading truncate info. In the get_truncate_info_array function, this field is incremented if the truncate info is not in the cache.
120001 16 tablet ls cache size The cache size of a tablet, in bytes. get_from_cache In the function, the cache of the tablet is used.
120002 16 table stat cache size The memory space occupied by the table/partition-level statistics cache, in bytes. This statistic is collected by the KVCache module.
120003 16 table col stat cache size The memory space occupied by the column-level statistics cache, in bytes. The KVCache module collects statistics on the memory space used by the column-level statistics cache.
120004 16 index block cache size The cache size used by the microblock of the intermediate layer index, in bytes. In the get_micro_block_handle function, the microblock of the intermediate layer index is used. index_block_cache_.
120006 16 user block cache size The cache size used by data microblocks, in bytes. In the get_micro_block_handle function, intermediate layer index microblocks are used. index_block_cache_.
120008 16 user row cache size The cache size in bytes used by the table get operator when prefetching data rows. This cache is utilized by the lookup_in_cache function.
120009 16 bloom filter cache size The total size of the macroblock Bloom filter cache, in bytes. User INSERT statements require checking for primary key conflicts. When the data to be checked resides on disk, a common performance optimization technique to avoid I/O is to build a Bloom filter for the involved data range. This series of metrics are related to the Bloom filter cache.
120010 16 log kv cache size The size of logs read from the cold cache, in bytes. When reading logs from PALF, if the hot cache does not provide a hit, it attempts to read from the cold cache. If the requested log is in the cold cache, the size of the successfully read log from the cold cache is accumulated.
245022 16 macro_cache max capacity of the META_FILE type In shared storage mode, the maximum disk cache capacity for Meta-type macroblocks in the macroblock cache, in Bytes3.
245023 16 macro_cache META_FILE used disk size In shared storage mode, the disk size used by meta-type macroblocks in the macroblock cache is in bytes. The total size of meta-type macroblocks in the cache is 3.
245024 16 macro_cache META_FILE hit count In shared storage mode, the number of hits for meta-type macroblocks in the macroblock cache. Each time a macroblock is attempted to be retrieved from the macroblock cache, the hit/miss count is incremented based on the macroblock type3.
245025 16 macro_cache META_FILE miss count The number of misses for meta-type macroblocks in the macroblock cache under shared storage mode. Each time a macroblock is attempted to be fetched from the macroblock cache, the hit/miss count is incremented based on the macroblock type3.
245026 16 macro_cache META_FILE hit bytes In shared storage mode, this is the total size of metadata macroblocks hit in the macroblock cache, in bytes. Each time a macroblock is attempted to be read from the macroblock cache, if the macroblock is hit and its type is Meta, this value is incremented by the size of the read data3.
245027 16 macro_cache META_FILE miss bytes In shared storage mode, the total size of metadata macroblocks that did not hit the macroblock cache, in bytes. Each time a macroblock is attempted to be read from the macroblock cache and the cache miss, and the macroblock type is Meta, this value increases by the size of the read3.
245028 16 macro_cache max capacity of the TMP_FILE type In shared storage mode, the maximum disk cache capacity for macroblocks of temporary file types in the macroblock cache, in bytes. The cache capacities of different types in the macroblock cache can be reclaimed from each other. Therefore, this value equals the disk size of the macroblock cache allocated to the tenant minus a reserved size3.
245029 16 macro_cache TMP_FILE used disk size In shared storage mode, this parameter specifies the disk size in bytes used for temporary macroblocks in the macroblock cache. The total size of temporary macroblocks in the macroblock cache3.
245030 16 macro_cache TMP_FILE hit count The number of macroblock cache hits for temporary file-type macroblocks in shared storage mode. Each time a macroblock is attempted to be retrieved from the macroblock cache, the hit/miss count is incremented based on the macroblock type3.
245031 16 macro_cache TMP_FILE miss count The number of misses for macroblocks that are temporary files in the macroblock cache in shared storage mode. Each time you attempt to retrieve a macroblock from the macroblock cache, the hit/miss count is incremented based on the macroblock type3.
245032 16 macro_cache TMP_FILE hit bytes In shared storage mode, this metric indicates the total size of macroblocks that are temporarily cached in the macroblock cache and hit. The unit is bytes. Each time a macroblock is read from the macroblock cache, if the macroblock is hit and the macroblock type is a temporary file type, this value increases by the size of the read data3.
245033 16 macro_cache TMP_FILE miss bytes In shared storage mode, the total size of temporary file-type macroblocks that did not hit the macroblock cache, in bytes. Each time a macroblock is attempted to be read from the macroblock cache and it does not hit, if the macroblock type is temporary file type, this value increases by the size of the read3.
245034 16 macro_cache max capacity of the MACRO_BLOCK type In shared storage mode, this parameter specifies the maximum disk cache capacity for macroblocks of the normal macroblock type in the macroblock cache, in bytes. The cache capacities of different types in the macroblock cache can be reclaimed from each other. Therefore, this value equals the disk size of the macroblock cache allocated to the tenant minus a reserved size3.
245035 16 macro_cache MACRO_BLOCK used disk size In shared storage mode, the disk size used by macroblocks of the normal type in the macroblock cache is in bytes. The total size of macroblocks of the normal type in the macroblock cache3.
245036 16 macro_cache MACRO_BLOCK hit count In shared storage mode, this metric records the number of hits for macroblocks of regular types in the macroblock cache. Each time a macroblock is attempted to be fetched from the macroblock cache, the hit/miss count is incremented based on the macroblock type3.
245037 16 macro_cache MACRO_BLOCK miss count The number of misses for macroblocks of the normal type in the macroblock cache under shared storage mode. Each time you attempt to retrieve a macroblock from the macroblock cache, the hit/miss count is incremented based on the macroblock type.3
245038 16 macro_cache MACRO_BLOCK hit bytes In shared storage mode, this is the total size of regular macroblocks hit in the macroblock cache, in bytes. Each time a macroblock is attempted to be read from the macroblock cache, if the cache is hit and the macroblock type is regular, this value increases by the size of the read data3.
245039 16 macro_cache MACRO_BLOCK miss bytes In shared storage mode, the total size of misses for normal macroblocks in the macroblock cache, in bytes. Each time a macroblock is attempted to be read from the macroblock cache and it misses, if the macroblock type is normal, this value increases by the size of the read3.
245040 16 macro_cache max capacity of the HOT_TABLET_MACRO_BLOCK type In shared storage mode, the maximum disk cache capacity for hot macroblocks in the macroblock cache, in bytes. The cache capacities of different types in the macroblock cache can be reclaimed from each other. Therefore, this value equals the disk size of the macroblock cache allocated to the tenant minus a reserved size3.
245041 16 macro_cache HOT_TABLET_MACRO_BLOCK used disk size In shared storage mode, the disk size used by hot macroblocks in the macroblock cache, in bytes. The total size of hot macroblocks in the macroblock cache is less than 3.
245042 16 macro_cache HOT_TABLET_MACRO_BLOCK hit count In shared storage mode, this metric records the number of hits for hot macroblock types in the macroblock cache. Each time a macroblock is attempted to be fetched from the macroblock cache, the hit/miss count is incremented based on the macroblock type.3
245043 16 macro_cache HOT_TABLET_MACRO_BLOCK miss count The number of misses for hot macroblock types in the macroblock cache under shared storage mode. Each time a macroblock is attempted to be fetched from the macroblock cache, the hit/miss count is incremented based on the macroblock type3.
245044 16 macro_cache HOT_TABLET_MACRO_BLOCK hit bytes In shared storage mode, the total size of hot macroblocks hit in the macroblock cache, in bytes. Each time a macroblock is attempted to be read from the macroblock cache, if the macroblock is hit and the macroblock type is hot, this value increases by the size of the read3.
245045 16 macro_cache HOT_TABLET_MACRO_BLOCK miss bytes In shared storage mode, this metric indicates the total size of hot macroblocks that were not found in the macroblock cache, in bytes. Each time a macroblock is attempted to be read from the macroblock cache and it is not found, if the macroblock type is a hot type, this value increases by the size of the read data3.
245046 16 macro_cache private macro hit count In shared storage mode, the number of private macroblock cache hits is less than 3.
245047 16 macro_cache private macro miss count The number of misses for private macroblocks in the macroblock cache under shared storage mode. Each time a macroblock is attempted to be fetched from the macroblock cache, the hit/miss count is incremented based on the macroblock type3.
245048 16 macro_cache private macro hit bytes In shared storage mode, the total size of private macroblocks hit in the macroblock cache, in bytes. Each time a macroblock is attempted to be read from the macroblock cache, if the cache is hit and the macroblock type is private, this value increases by the size of the read3.
245049 16 macro_cache private macro miss bytes In shared storage mode, the total size of private macroblocks that did not hit the macroblock cache, in bytes. Each time a macroblock is attempted to be read from the macroblock cache and it does not hit, if the macroblock type is private, this value increases by the size of the read3.
245050 16 macro_cache shared macro hit count In shared storage mode, this metric indicates the number of hits for macroblocks of the shared type in the macroblock cache. Each time a macroblock is attempted to be fetched from the macroblock cache, the hit/miss count is incremented based on the macroblock type.3
245051 16 macro_cache shared macro miss count The number of misses for shared macroblocks in the macroblock cache under shared storage mode. Each time a macroblock is attempted to be fetched from the macroblock cache, the hit/miss count is incremented based on the macroblock type3.
245052 16 macro_cache shared macro hit bytes In shared storage mode, this column indicates the total size of data successfully fetched from the macroblock cache for shared-type macroblocks, in bytes. Each time a macroblock is attempted to be read from the macroblock cache, if the macroblock is found and it is of a shared type, this value is incremented by the size of the read data3.
245053 16 macro_cache shared macro miss bytes In shared storage mode, this is the total size of misses for shared-type macroblocks in the macroblock cache, in bytes. Each time a macroblock is attempted to be read from the macroblock cache and the cache miss, and the macroblock type is shared, this value is incremented by the size of the read data3.
245054 16 external table disk cache hit count The number of hits in the external table data disk cache. This feature is supported in both SN and SS modes. Each time an external table is queried, if the disk caching feature (enabled by default) is enabled, this value increments by 1 for each macroblock hit. After enabling external table disk caching, external table data is split into chunks of macroblocks and stored on disk.
245055 16 external table disk cache miss count The number of misses in the external table data disk cache. This metric is supported in both SN and SS modes. Whenever an external table is queried, if the disk cache feature is enabled (which is the default), this value increments by 1 for each macroblock that is not hit.
245056 16 external table disk cache hit bytes The total size of data hits in the external table disk cache. This feature is supported in both SN and SS modes, and the unit is bytes. Each time an external table is queried, if the disk caching function (enabled by default) is enabled, this value increases by the size of each macroblock hit.
245057 16 external table disk cache miss bytes The total size of misses in the external table data disk cache. Supported in both SN and SS modes. Unit: Bytes. Each time an external table is queried, if the disk caching feature is enabled (which is the default), this value increases by the size read for each macroblock that is missed.
245058 16 macro_cache total alloc disk size The disk space allocated to the local macroblock cache in shared storage mode, in bytes. When initializing the tenant's local macroblock cache module, a disk space size is calculated and allocated to the local macroblock cache.

Note

  • Note 2: The user's insert statement needs to check for primary key conflicts. When the data to be checked resides on disk, a common performance optimization technique to avoid I/O is to build a Bloom filter for the involved data range. This series of metrics are related to the Bloom filter cache.
  • Note 3: Macroblock caches can be categorized by cache type into META, TMP_FILE, MACRO, and HOTMacro. The META type includes all Meta-type macroblocks, TMP_FILE includes temporary file-type macroblocks; if a tablet is designated as a hotspot tablet, all its corresponding macroblocks are of the HOT_macro type. Macroblocks that are not of these three types belong to the MACRO cache type. Caches of different types within the macroblock cache can coexist on the same storage space. Therefore, this value equals the disk size allocated for the tenant's macroblock cache minus a reserved portion.

Storage

Metric ID
Type of the monitored item
Metric name
Description
60000 32 io read count Indicates the total IOPS for read I/O operations. After each read I/O operation is completed, the IO_READ_COUNT counter is incremented by 1.
60001 32 io read delay Indicates the total latency of read I/O operations, in microseconds. The IO_READ_DELAY metric accumulates the hardware service latency for each read I/O operation. This latency is measured from the time the request is dispatched to the disk until the disk completes processing and returns the result.
60002 32 io read bytes Represents the total bandwidth for read I/O operations. This statistic counts the total amount of data read, in bytes. You can calculate the average read I/O per second by analyzing the change over a period of time. After each read I/O operation is completed, its read bandwidth is measured and cumulatively added to the IO_READ_BYTES metric.
60003 32 io write count Indicates the total IOPS for write I/O operations. After each write I/O operation is completed, IO_WRITE_COUNT is incremented by 1.
60004 32 io write delay Represents the total latency of write I/O operations, in microseconds. The IO_READ_DELAY metric accumulates the hardware service latency for each write I/O operation. This latency is measured from when the request is dispatched to the disk until the disk completes processing and returns a response.
60005 32 io write bytes Indicates the total bandwidth for write I/O operations. This statistic counts the total amount of data written, in bytes. You can calculate the average value based on the change over a period of time. After each write I/O operation is completed, its written bandwidth is measured and cumulatively added to the IO_WRITE_BYTES metric.
60006 32 memstore scan count The number of range queries on the MemTable. This value is incremented when a range query starts on the MemTable.
60007 32 memstore scan succ count The number of successful range queries on the MemTable. This value increments by 1 after a successful range query on the MemTable.
60008 32 memstore scan fail count The number of failed range queries on the MemTable. This value increments by 1 whenever a range query fails on the MemTable for any reason.
60009 32 memstore get count Number of point queries in the MemTable. This value is incremented when a point query starts in the MemTable.
60010 32 memstore get succ count The number of successful point queries in the MemTable. This value increments by 1 after a successful point query in the MemTable.
60011 32 memstore get fail count The number of point queries that failed in the MemTable. This value increments by 1 whenever a point query fails in the MemTable for any reason.
60012 32 memstore apply count The number of times the MemTable has been flushed to disk. This value increments by 1 when a flush to disk starts.
60013 32 memstore apply succ count The number of successful MemTable writes. This value increments by 1 after a MemTable write is successful.
60014 32 memstore apply fail count The number of MemTable write failures. This value increments by 1 whenever a MemTable fails during the write process for any reason.
60016 32 memstore get time The time consumed in a point query of the MemTable, in microseconds. Regardless of whether the point query succeeds or fails, this value increases by the time spent on the query.
60017 32 memstore scan time The time consumed in a range query on the MemTable, in microseconds. This value increases regardless of whether the range query succeeds or fails.
60018 32 memstore apply time The time consumed in writing to the MemTable, in microseconds. Regardless of whether the write to the MemTable succeeds or fails, this value records the time spent on the write operation.
60019 32 memstore read lock succ count The number of rows successfully read from the MemTable. This value increments by 1 after each row is successfully read from the MemTable.
60020 32 memstore read lock fail count The number of rows that failed to be read from the MemTable due to a read lock conflict timeout. During a read from the MemTable, if the data being read is in the process of being committed but its commit status and version number are not yet determined (for example, it is in a state where the commit logs are pending or the distributed transaction is pending, which lasts for a very short time), the read lock will be held. If the read fails due to this conflict timeout, this value is incremented by 1.
60021 32 memstore write lock succ count The number of rows successfully written to the MemTable. During the write process to the MemTable, lock conflicts, lost updates, and primary key conflicts are verified. If no such conflicts occur, this value is incremented by 1.

Note

Rows that pass verification in the MemTable may still fail verification when written to the SSTable.

60022 32 memstore write lock fail count The number of rows that failed to be written to the MemTable due to conflicts. During the write process to the MemTable, lock conflicts, lost updates, and primary key conflicts are detected. If any of these conflicts occur, this value is incremented by 1.

Note

This does not include verifications on SSTables.

60023 32 memstore wait write lock time The wait time in microseconds for a request awakened after a lock conflict during write to the MemTable. During the write process to the MemTable, if a lock conflict occurs, the request is placed into the lock conflict queue. This value is the time from when the request was placed in the lock conflict queue until it is awakened.
60024 32 memstore wait read lock time The wait time for a read lock conflict on the MemTable, in microseconds. During a read from the MemTable, if the data being read is committed but its commit status and version number are undetermined (for example, it is in a state where the commit log is pending or the distributed transaction is pending, which lasts only a short time), the read operation will wait on the lock. This value includes the wait time.
60027 32 io prefetch micro block count Total number of I/O operations for microblock cache. Query path optimization loads the microblocks required from disk into memory via prefetching, which is known as microblock caching. This metric indicates the total number of times the system loads disk microblocks. Combined with the microblock cache hit rate on internal tables, it can measure the effectiveness of query performance optimization in the system.
60028 32 io prefetch micro block bytes The total number of bytes of I/O for microblock cache, in bytes. Query path optimization loads the microblocks on disk that need to be accessed into memory through prefetching, that is, into the microblock cache. This metric represents the total number of bytes of disk microblocks loaded by the system. Combined with the microblock cache hit rate on internal tables, it can measure the effectiveness of query performance optimization in the system.
60031 32 storage read row count The number of times the rows after the fuse are processed in the non-pushdown path of the table scan operator, in rows. process_fuse_row The value is incremented by 1 each time the function is called.
60032 32 storage delete row count The DML statement affected row sub-item refers to the actual number of valid rows deleted. The statistic increments by 1 each time a row is deleted in the storage engine.
60033 32 storage insert row count The AFFECTED ROWS sub-item of DML statements refers to the actual number of valid rows inserted. The statistic increments by 1 each time a row is inserted into the storage engine.
60034 32 storage update row count The number of rows updated by the UPDATE operation. When the update_rows function is called, this value is incremented by the number of rows updated.
60037 32 memstore row purge count
60038 32 memstore row compaction count The number of times sparse multi-version compactions on a MemTable row are merged into a compact version. A sparse multi-version is stored in a MemTable row, recording only the changed columns. When the number of versions increases, the MemTable generates a compact single version to improve read performance. This value increments by 1 each time a compact single version is generated.
60056 32 memstore read row count The number of rows read from the MemTable before filtering. This value increments by 1 each time a row is read from the MemTable.
60057 32 ssstore read row count The number of rows of major SSTables, minor SSTables, and mini SSTables read from non-compaction paths; the number of rows in the range on compaction paths includes filtered rows, which is the total number of rows in SSTables within the range. Rowstore includes rows skipped by skip index pre-fetching, while columnstore does not. The number of rows in the range on non-compaction paths includes filtered rows but excludes uncommitted rows, rolled-back rows, and multi-version rows within microblocks.
60058 32 memstore write bytes The amount of data successfully written to the MemTable, in bytes. After data is successfully written to the MemTable, the size of the primary key and the data volume are tallied and incremented accordingly.
60068 32 memstore write lock wakenup count in lock_wait_mgr The number of times a request is awakened after a lock conflict occurs during a write to the MemTable. During a write to the MemTable, if a lock conflict arises, the request is placed into the lock conflict queue. The value is incremented by 1 when the request is awakened.
60077 32 get row effect read The table get operator returns the number of valid rows read from a microblock. ObMicroBlockRowGetter::get_block_row In the function, if the row flag of the read row is not DF_NOT_EXIST, this counter is incremented by 1.
60078 32 get row empty read The number of invalid rows read from the microblock by the TABLE GET operator, in rows. ObMicroBlockRowGetter::get_block_row In the function, if the row flag of the read row is DF_NOT_EXIST, this counter is incremented by 1.
60083 32 memstore write lock wait timeout count The number of times a lock conflict during MemTable write did not wake up the request and timed out. During the writing process to the MemTable, if a lock conflict occurs, the request is placed into the lock conflict queue. If the request times out before being awakened, this value is incremented by 1.
60084 32 accessed data micro block count by io The number of microblocks that require I/O operations because they were not found in the cache when fetched. This metric increments by 1 for each microblock that requires an I/O operation instead of being retrieved from the cache during data fetch.
60085 32 data micro block cache hit The number of data microblocks that hit the block cache when fetched. When fetching data microblocks, it checks whether the microblock is in the cache. If a hit occurs, this counter increments by 1.
60086 32 accessed index micro block count by io The number of microblocks that require I/O operations when fetching intermediate-layer index microblocks and no cache hit is detected. This item increments by 1 when fetching intermediate-layer index microblocks from I/O operations instead of the cache.
60087 32 index micro block cache hit The number of times a block cache hit occurs when fetching an intermediate index microblock. When fetching an intermediate index microblock, the system checks whether the microblock is in the cache. If a cache hit occurs, this metric increments by 1.
60088 32 blockscaned data micro block count The number of microblocks opened via the pushdown path, including both rowstore and columnstore microblocks that skip pre-fetching via the skip index mechanism. For columnstore tables with multiple CGs, the microblock counts must be accumulated. Unit: microblocks. Rowstore: When opening a microblock, check if the pushdown path is available; if so, increment this count by 1. Columnstore: When opening a microblock via the pushdown path, increment this count by 1.
60089 32 blockscaned row count The total number of rows within the specified range that are opened in microblocks under the pushdown path. This includes filtered rows (no uncommitted rows, rolled-back rows, or multi-version rows within a microblock exist for pushdown; no inter-microblock multi-version rows exist for rowstore, meaning no rowkey intersection, while columnstore may have inter-microblock multi-version rows). For rowstore, this includes rows skipped by skip index; for columnstore, it does not. The number of rows from multiple CGs in a columnstore table is not cumulative. Unit: number of rows.
  • Rowstore: When opening a microblock, it is determined whether the pushdown path can be used. If so, the total number of rows in this microblock is added to this field.
  • Columnstore: After filter completion or projection completion, the total number of processed rows is added to this field.
60090 32 storage filtered row count Total rows filtered by pushdown or non-pushdown filters. During filtering, this value is incremented by the number of rows skipped. For rowstore, this includes rows skipped via skip index pre-fetching; for columnstore, it does not.
60091 32 minor ssstore read row count The number of minor SSTables and mini SSTables read from the pushdown and non-pushdown paths, respectively. The pushdown path includes filtered rows, representing the total number of rows within the specified range in the minor/mini SSTables that follow the pushdown path. The non-pushdown path includes filtered rows but excludes uncommitted rows, rolled-back rows, and multi-version rows within microblocks.
60092 32 major ssstore read row count Number of major SSTables read from non-compaction paths; rows in the non-compaction path include filtered rows, which is equivalent to the total number of rows within the range in the major SSTables that follow the non-compaction path. Rowstore includes skipped rows by skip index, while columnstore does not. Rows in the non-compaction path also include filtered rows, but exclude uncommitted rows, rolled-back rows, and multi-version rows within microblocks.
60093 32 storage waiting throttle time To dynamically match the system's minor compaction speed, when the minor compaction rate cannot keep up with memory write speed, memory allocation for certain modules is throttled. This parameter records the total duration of these memory allocation throttles, in microseconds. When the memory usage of modules such as MemTable (TxData, Mds) exceeds a certain threshold, the thread sleeps for a period after each memory allocation. The total duration of these sleeps is accumulated in this statistic.
69000 32 backup io read count Please check this metric in the I/O Manager.
69001 32 backup io read bytes Please check this metric in the I/O Manager.
69002 32 backup io write count Please check this metric in the I/O Manager.
69003 32 backup io write bytes Please check this metric in the I/O Manager.
69010 32 backup delete count Please check this metric in the I/O Manager.
69012 32 backup io read delay Please check this metric in the I/O Manager.
69013 32 backup io write delay Please check this metric in the I/O Manager.
69017 32 backup delete delay Please check this metric in the I/O Manager.
69019 32 backup io list count Please check this metric in the I/O Manager.
69020 32 backup io read failed count Please check this metric in the I/O Manager.
69021 32 backup io write failed count Please check this metric in the I/O Manager.
69022 32 backup io delete failed count Please check this metric in the I/O Manager.
69023 32 backup io list failed count Please check this metric in the I/O Manager.
69024 32 backup io tagging count Please check this metric in the I/O Manager.
69025 32 backup io tagging failed count Please check this metric in the I/O Manager.
130000 32 active memstore used The size of the active memstore on a node, in bytes. Memstores are used for replay and write operations on a node. When the usage of a memstore reaches a certain threshold, a freeze is triggered. All unfrozen memstores are called active memstores.
130001 32 total memstore used Total memory used by the tenant's memstores on the node, in bytes. This memory usage includes both active and frozen memstores, that is, the total memory used by all memstores of the tenant on this node.
130002 32 major freeze trigger The size at which a memstore is frozen. Unit: bytes. In the get_tenant_memstore_cond function, this value is obtained by adding memstore_freeze_trigger to max_cached_memstore_size.
130004 32 memstore limit The maximum memory that can be used by the tenant's memstore on a node, in bytes. You specify the memory limit for a user tenant by using the memstore_limit_percentage and _memstore_limit_percentage Configure the maximum upper limit for the size of the memstore. Specifically, memstore_limit_percentage It is at the cluster level. _memstore_limit_percentage is at the tenant level. _memstore_limit_percentage has a higher priority than memstore_limit_percentage. If neither is specified, the memstore available ratio for tenants smaller than 8 GB is 40%, and for tenants larger than 8 GB, it is 50%.
240022 32 object storage io head count The number of HEAD operations on object storage. This count increments by 1 each time a HEAD request is made to object storage.
240023 32 object storage io head fail count The count of failed HEAD operations for object storage. This count increments by 1 when a HEAD request to object storage fails.

Resources

Metric ID
Type of the monitored item
Metric name
Description
140001 64 min memory size The memory specification of a tenant determines its maximum memory. The OmtNodeBalancer background thread periodically collects information from the DBA_OB_UNIT_CONFIGS The table retrieves the tenant's latest min_memory value and updates it to the Limit field of the ObTenantMemoryMgr object.
140002 64 max memory size The memory specification of a tenant determines its maximum memory size, in bytes. The OmtNodeBalancer background thread periodically checks the memory usage of each tenant and triggers a memory reclaim operation when the memory usage exceeds the specified threshold. DBA_OB_UNIT_CONFIGS The table retrieves the tenant's latest min_memory and updates it to the Limit of the ObTenantMemoryMgr.
140003 64 memory usage The memory occupied by the tenant, in bytes. ObTenantMemoryMgr maintains a real-time memory value that records the actual memory usage of the tenant.
140004 64 min cpus Represents the CPU specification of a tenant. It determines the number of worker threads that reside in the tenant and the number of threads for some background modules. The OmtNodeBalancer background thread periodically checks from DBA_OB_UNIT_CONFIGS The table obtains the latest max_cpu value and synchronizes it to all tenants. The OmtNodeBalancer background thread periodically adjusts the number of worker threads based on the synchronized max_cpu value.
140005 64 max cpus Represents the CPU specification of a tenant. It determines the number of worker threads that reside in the tenant and the number of threads for some background modules. When cgroup is enabled, it also determines the upper limit of CPU usage for tenant threads. The OmtNodeBalancer background thread periodically checks from DBA_OB_UNIT_CONFIGS The table fetches the latest max_cpu value and synchronizes it to the tenants. The OmtNodeBalancer background thread periodically adjusts the number of worker threads based on the synchronized max_cpu value.
140006 64 cpu usage Indicates the thread utilization of tenant worker threads, reflecting the busyness of the tenant worker threads. The unit is percentage. The OmtNodeBalancer background thread collects statistics every 10 seconds on the proportion of time tenant worker threads spend processing requests out of the total time, normalizes this value, and then multiplies it by the tenant's min_cpu to obtain the cpu_usage statistic.
140008 64 observer memory used size The actual memory used by the OBServer node, in bytes. AChunkMgr maintains a real-time memory value that records the actual memory usage of the OBServer node (less than or equal to the actual memory occupancy).
140009 64 observer memory free size The chunk cache of the OBServer node. AChunkMgr maintains a real-time memory value that records the cache size of the OBServer node. The cache represents the amount of memory allocated but not yet used by the OBServer node.
140010 64 is mini mode Whether the OBServer node process is in mini mode. An OBServer node is considered to be in mini mode if its memory is less than 12 GB.
140011 64 observer memory hold size The memory occupied by the OBServer node, including cache and all user data, in bytes. AChunkMgr maintains a real-time memory value that records the memory usage of the OBServer node.
140012 64 worker time Total time spent by tenant worker threads in a busy state, in microseconds. The OmtNodeBalancer background thread collects statistics on the total request-handling time of tenant worker threads every 10 seconds and accumulates it into the worker_time value.
140013 64 cpu time Indicates the total CPU time used by tenant worker threads and background threads, in microseconds.
  • With cgroup enabled: Read the cpuacct_usage file in the tenant's cgroup directory to obtain the total CPU time of the tenant's threads.
  • Without cgroup enabled: The OmtNodeBalancer background thread traverses all tenant threads every 10 seconds, calculates the difference between the contents of the /proc/[pid]/task/[tid]/stat file from two traversals, computes the incremental CPU time, and sums it up.
140014 64 effective observer memory limit The maximum memory for an OBServer node, in bytes. This value is available only to the sys tenant and is at the node level.
  • By default, if the parameter memory_limit_percentage is configured, the maximum memory for an OBServer node is calculated as memory_limit_percentage * the physical memory of the server.
  • You can set the parameter memory_limit to specify the maximum memory for an OBServer node.
140015 64 effective system memory Reserved memory and hidden sys memory for 500 tenants, in bytes. By default, an appropriate value is automatically determined based on the memory_limit parameter; you can also explicitly specify it using the system_memory parameter.
140016 64 effective hidden sys memory The memory cap for the sys tenant, in bytes. Each OBServer node allocates a portion of its memory for the sys tenant. By default, this value is dynamically determined based on the memory parameter system_memory; users can also explicitly specify it using the parameter _hidden_sys_tenant_memory.
140017 64 max session num The maximum number of sessions allowed for a tenant. The maximum number of sessions allowed for a tenant is calculated based on the tenant's memory size.
140018 64 kvcache hold The memory size occupied by the KVCache, in bytes. The memory manager collects statistics on the memory usage of the KVCache.
140019 64 unmanaged memory size The memory size directly read from the mmap by database functions, in bytes. It is a global memory value that records in real time the memory requested by database function calls to mmap/unmap. Specifically, it refers to the memory requested by third-party library functions called on the OBServer node through mmap.
140020 64 hidden sys data disk size In shared storage mode, the disk size configured for the hidden sys tenant is displayed in bytes.
  • For non-sys tenants, it is displayed as 0.
  • For the sys tenant, there are two scenarios:
    • If the value of the hidden parameter _ss_hidden_sys_tenant_data_disk_size is 0, then the value of HIDDEN_SYS_DATA_DISK_SIZE is twice the value of the hidden parameter _hidden_sys_tenant_memory when the OBServer node starts.
    • If the value of the hidden parameter _ss_hidden_sys_tenant_data_disk_size is not 0, then the value of HIDDEN_SYS_DATA_DISK_SIZE is equal to the value of the hidden parameter.

Logs

Metric ID
Type of the monitored item
Metric name
Description
70000 128 refresh schema count Number of successful schema refreshes. This value increases each time a schema refresh operation is successfully completed when the OceanBase AI Database needs to refresh the schema. In ObServerSchemaService::refresh_schema The method. This operation includes a complete refresh. refresh_full_schema and incremental refresh refresh_increment_schema The two modes are used to maintain consistency between the local metadata cache and system tables.
70001 128 refresh schema time The total time consumed for schema refreshes, in microseconds. When the OceanBase AI Database refreshes a schema, it calculates the total time spent on the entire refresh process. In ObServerSchemaService::refresh_schema In the method, when OB_SUCC(ret) is True, the time difference from the start to the end of the method is accumulated. This includes full refreshes. refresh_full_schema and incremental refresh refresh_increment_schema All overheads in both modes.
70002 128 inner sql connection execute count Number of inner SQL executions. The count increments by 1 for each executed inner SQL statement.
70003 128 inner sql connection execute time Total execution time of inner SQL statements, in microseconds. The total execution time is the cumulative sum of the execution times of inner SQL statements.
70006 128 log stream table operator get count From __all_ls_meta_table The number of times the table successfully reads the loaded LS information. When through ObLSTableOperator From __all_ls_meta_table When a table retrieves log stream information, each successful retrieval will ls_info The count value is incremented by 1. In ObLSTableOperator::get The method. The operator can obtain log stream information from memory, RPC, or persistent tables for location caching and metadata management.
70007 128 log stream table operator get time From __all_ls_meta_table The cumulative time consumed by the table in reading and loading LS information, in microseconds. When passing through ObLSTableOperator From __all_ls_meta_table When a table fetches log stream information, it calculates the total time consumed in the entire process. In ObLSTableOperator::get In this method, the time difference from the start to the end of the method is accumulated. This includes all overhead for obtaining log stream information from memory, RPC, or persistent tables.
160001 128 oblogger log bytes Cumulative total size of printed logs, in bytes. Refers to the output and printing process of system logs such as observer.log.
160002 128 election log bytes Cumulative size of printed election logs, in bytes. This refers to the cumulative size of the election.log files that have been printed.
160004 128 oblogger total log count Cumulative number of log prints. This refers to the output process of system logs such as observer.log.
160019 128 async error log dropped count The number of times an ERROR log failed to be printed (due to throttling or other reasons). This refers to the output process of system logs such as observer.log.
160020 128 async warn log dropped count The number of WARN logs that failed to be printed. This refers to the output process of system logs such as observer.log.
160021 128 async info log dropped count The number of INFO log print failures (due to throttling or other reasons). This refers to the output process of system logs such as observer.log.
160022 128 async trace log dropped count The number of failed TRACE log prints. This refers to the output process of system logs such as observer.log.
160023 128 async debug log dropped count The number of DEBUG log print failures (due to throttling or other reasons). This refers to the output process of system logs such as observer.log.
160024 128 async log flush speed Average number of logs written per second. This refers to the output and printing process of system logs such as observer.log.
160025 128 async generic log write count The default number of successful log prints. This refers to the output process of system logs such as observer.log.
160026 128 async user request log write count Deprecated, retained only in code. Refers to the output printing process for system logs such as observer.log.
160027 128 async data maintain log write count The number of successful minor compaction log prints. This refers to the output process of system logs such as observer.log.
160028 128 async root service log write count The number of successful RS log prints. This refers to the output process of system logs such as observer.log.
160029 128 async schema log write count The number of Schema log printing failures (due to throttling, etc.). This refers to the output printing process of system logs such as observer.log.
160030 128 async force allow log write count The number of successful forced log prints. This refers to the output process of system logs such as observer.log.
160031 128 async generic log dropped count The default number of times that log printing fails (due to throttling or other reasons). This refers to the output process of system logs such as observer.log.
160032 128 async user request log dropped count Deprecated, retained only in code. Refers to the output printing process for system logs such as observer.log.
160033 128 async data maintain log dropped count The number of times minor compaction logs failed to be printed due to throttling or other reasons. This refers to the process of outputting system logs such as observer.log.
160034 128 async root service log dropped count The number of times RS log printing failed (due to throttling or other reasons). This refers to the output process of system logs such as observer.log.
160035 128 async schema log dropped count The number of Schema log printing failures (due to throttling, etc.). This refers to the output printing process of system logs such as observer.log.
160036 128 async force allow log dropped count The number of forced log printing failures (due to rate limiting or other reasons). This refers to the output process of system logs such as observer.log.

CLOG

Metric ID
Type of the monitored item
Metric name
Description
80001 256 palf write io count to disk The number of times a clog is written to disk. This statistic increments when a clog is successfully written to disk.
80002 256 palf write size to disk The size of data written to disk by clogs, in bytes. When a clog is successfully written to disk, the size of the successfully written data is accumulated.
80003 256 palf write total time to disk The time consumed in writing a clog to disk, in microseconds. When a clog is successfully written to disk, the time consumed for this write is accumulated.
80004 256 palf read count from hot cache The number of hits for reading from the hot cache. When reading logs from PALF, it first attempts to read from the hot cache. If the requested log is found in the hot cache, this statistic increments by 1.
80005 256 palf read size from hot cache The size of logs read from the hot cache, in bytes. When reading logs from PALF, the system first attempts to retrieve them from the hot cache. If the requested log is found in the hot cache, the size of the log read from the hot cache is accumulated.
80006 256 palf read total time from hot cache The time consumed in reading a clog from the hot cache, in microseconds. When reading logs from PALF, it first attempts to retrieve them from the hot cache. If the requested log is found in the hot cache, the time spent on this read is accumulated.
80007 256 palf read io count from disk The number of disk I/Os for reading clogs. This statistic increments by 1 whenever a clog is successfully read from disk.
80008 256 palf read size from disk The size of the clogs read from disk, in bytes. When a clog is successfully read from disk, the size of that clog is accumulated.
80009 256 palf read total time from disk The time consumed in reading a clog from disk, in microseconds. When a clog is successfully read from disk, the time consumed in this read is accumulated.
80010 256 palf handle rpc request count The number of RPCs processed by the PALF layer. PALF increments this statistic by 1 after processing each RPC.
80011 256 archive read log size Total size of Clogs read from log archive, in bytes. This metric periodically measures the total amount of logs read by the log pulling module per unit time and then accumulates the data. The statistical period is 10 seconds, and the statistical unit is bytes.
80012 256 archive write log size Total amount of clogs written to the archive media for log archiving, in bytes. This metric periodically measures the total volume of logs written to the archive media by the log archiving module within a unit of time and then accumulates the data. The statistical period is 10 seconds, and the unit is bytes.
80013 256 restore read log size Total amount of clogs read by the log restore module, in bytes. The log restore module accumulates the amount of logs read each time it triggers a remote log read. The unit is bytes.
80014 256 restore write log size Total amount of clogs committed by the log restore module, in bytes. Each time the log restore module triggers log commit, it accumulates the volume of logs to be committed. The unit is bytes.
80057 256 clog trans log total size The amount of data committed to PALF in bytes. Transactions commit logs to PALF, and this value increases by the size of the committed logs after the log commit is complete.
80058 256 log storage compress original size The original size of the log before compression, in bytes, submitted by the upper layer to the PALF layer. When log compression is enabled, the log size is compressed each time the upper layer calls the APPEND interface of the PALF layer to submit a log, and the cumulative pre-compressed log size is recorded.
80059 256 log storage compress compressed size The cumulative size of compressed logs submitted by the upper layer to the PALF layer, in bytes. When log compression is enabled, each time the upper layer calls the APPEND interface of the PALF layer to submit logs, the logs are compressed and the compressed log size is accumulated.
81001 256 external log service fetch log size The size of logs pulled by log synchronization links (such as OBCDC and network standby databases) from this node, in bytes. Each time an RPC sent by a downstream synchronization link is processed, the size of the logs returned by this RPC is counted and added to the [G]V$SYSSTAT statistics.
81002 256 external log service fetch log count The number of logs pulled by log synchronization links (such as OBCDC and network standby databases) from this node. Each time an RPC sent by a downstream synchronization link is processed, the number of logs returned by this RPC is counted and added to the [G]V$SYSSTAT statistic.
81003 256 external log service fetch rpc count The number of RPCs sent by the log synchronization link (such as OBCDC or network standby databases) to pull logs from this node. Each time an RPC sent by a downstream synchronization link is processed, the count for this statistic increases by 1.

Root Service

Metric ID
Type of the monitored item
Metric name
Description
110015 2048 success rpc process The number of RPC requests successfully processed by the root service. This statistic increments by 1 each time the root service successfully processes an RPC request. It includes all RPC requests sent to the root service and executed successfully.
110016 2048 failed rpc process The number of times the Root Service fails to process an RPC request. This statistic increments by 1 each time the Root Service fails to process an RPC request. It includes all RPC requests sent to the Root Service but that fail to execute.
110017 2048 balancer succ execute count The number of successful RS unit load balancing operations. The counter increments each time the root service load balancer successfully performs a unit balancing operation.
110018 2048 balancer failed execute count The number of failed RS unit load balancing operations. This value increments each time the root service load balancer fails to perform a unit load balancing operation.

ASH

Metric ID
Type of the monitored item
Metric name
Description
200001 3072 DB time The total time spent by the foreground process on database operations, including the cumulative values of CPU time and non-idle wait time, in microseconds. OceanBase AI Database periodically updates Time Model-related statistics. When a thread is active, it must be in the ON_CPU state or waiting for an event. The Time Model-related statistics are accumulated based on the duration of each state.
200002 3072 DB CPU The CPU time consumed by the foreground process, in microseconds. OceanBase AI Database periodically updates the Time Model statistics. When a thread is active, it is either in the ON_CPU state or waiting for an event. The Time Model statistics are accumulated based on the duration of each state.
200005 3072 background elapsed time The total time spent by background processes, in microseconds. OceanBase AI Database periodically updates time model-related statistics. When a thread is active, it is either in the ON_CPU state or waiting for an event. The time model-related statistics are accumulated based on the duration of each state.
200006 3072 background cpu time The CPU time consumed by the background process, in microseconds. OceanBase AI Database periodically updates the Time Model-related statistics. When a thread is active, it is either in the ON_CPU state or waiting for an event. The Time Model-related statistics are accumulated based on the duration of each state.
200010 3072 non idle wait time The total time that the foreground process spends in a non-idle wait state, meaning the total time the session is in a wait state but not in an idle wait state, in microseconds. OceanBase AI Database periodically updates Time Model-related statistics internally. When a thread is active, it must be in the ON_CPU state or a wait-for-event state. The Time Model-related statistics are accumulated based on the duration of each state it occupies.
200011 3072 idle wait time The idle wait time of the foreground process, that is, the total time the session spends in an idle wait state, in microseconds. OceanBase AI Database periodically updates Time Model-related statistics internally. When a thread is active, it is either in the ON_CPU state or waiting for an event. The Time Model-related statistics are accumulated based on the duration of each state.
200012 3072 background database time The total time spent by background processes on database operations, in microseconds. OceanBase AI Database periodically updates Time Model-related statistics. When a thread is active, it must be in the ON_CPU state or waiting for an event. The Time Model-related statistics are accumulated based on the duration of each state.
200013 3072 background database non-idle wait time The time spent by a background process on database operations when it is not in the idle wait state, in microseconds. OceanBase AI Database periodically updates Time Model-related statistics. When a thread is active, it must be in the ON_CPU state or waiting for an event. The Time Model-related statistics are accumulated based on the duration of each state.
200014 3072 background database idle wait time The time spent by a background process in an idle wait state performing database operations, in microseconds. OceanBase AI Database periodically updates Time Model-related statistics. When a thread is active, it is either in the ON_CPU state or waiting for an event. The Time Model-related statistics are accumulated based on the duration of each state.
200015 3072 diagnostic info object allocated count Total number of diagnostic objects allocated. Diagnostic objects on OBServer nodes are used to store diagnostic statistics for database foreground and background tasks (including SQL, RPC, etc.). They are typically allocated at the start of a task and reclaimed at the end of the task.
200016 3072 diagnostic info object allocate failure count Total number of diagnostic object allocation failures. A diagnostic object on an OBServer node stores diagnostic statistics for database foreground and background tasks (including SQL and RPC). It is typically allocated at the start of a task and reclaimed at the end.
200017 3072 diagnostic info object returned count The total number of reclaimed diagnostic objects, in units of quantity. Diagnostic objects on OBServer nodes are used to store diagnostic statistics for database foreground and background tasks (including SQL and RPC). They are typically allocated at the start of a task and reclaimed at the end of the task.
200018 3072 diagnostic info object return failure count Total number of failed reclaims of diagnostic objects. Diagnostic objects on an OBServer node store diagnostic statistics for database foreground and background tasks, including SQL and RPC tasks. They are typically allocated at the start of a task and reclaimed at the end of the task.
220001 3072 concurrency wait total time The total wait time caused by wait events of the Concurrency category, such as wait time due to resource locking. The unit is microseconds. It is obtained by accumulating and summarizing the corresponding analog wait events in OceanBase AI Database.
220002 3072 user io wait total time The total time spent by user processes waiting for I/O operations (such as reading or writing data to disk) to complete, in microseconds. This metric is derived from the cumulative summary of corresponding wait events in OceanBase AI Database.
220003 3072 application wait total time The total amount of time spent waiting, in microseconds, that is generated by user application code (for example, lock waits caused by row-level locks or explicit lock commands). This metric is derived from the cumulative summary of corresponding wait events in OceanBase AI Database.
220004 3072 schedule wait total time Total time consumed by wait events of the SCHEDULER category, in microseconds. This value is obtained by accumulating and summarizing the corresponding analog wait events in OceanBase AI Database.
220005 3072 network wait total time The total time consumed by network-related wait events, in microseconds. This value is derived from the cumulative summary of corresponding analog wait events in OceanBase AI Database.

TableAPI

For more information about TableAPI monitoring metrics, see OBKV-Table monitoring metrics in the OBKV documentation.

WR

Metric ID
Type of the monitored item
Metric name
Description
210001 8192 wr snapshot task elapse time The total time consumed in collecting WR (Workload Repository) snapshots, in microseconds. WR periodically collects data from internal views of OceanBase AI Database to record the system status, and provides related views for user display and management operations through the DBMS_WORKLOAD_REPOSITORY package.
210002 8192 wr snapshot task cpu time Collects the total CPU time consumed by WR (Workload Repository) snapshots, in microseconds. WR periodically collects data from internal OceanBase AI Database views to record system status, and provides related views for user display and management operations through the DBMS_WORKLOAD_REPOSITORY package.
210003 8192 wr purge task elapse time WR (Workload Repository) The total time consumed by deleting a WR snapshot task, in microseconds. WR periodically collects data from internal views of OceanBase AI Database to record the system status, and provides related views for user display and management operations through the DBMS_WORKLOAD_REPOSITORY package.
210004 8192 wr purge task cpu time WR (Workload Repository) The total CPU time consumed by the WR snapshot deletion task, in microseconds. WR periodically collects data from internal views of OceanBase AI Database to record the system status, and provides related views for user display and management operations through the DBMS_WORKLOAD_REPOSITORY package.
210005 8192 wr schedular elapse time The total time consumed by WR (Workload Repository) scheduling tasks, in microseconds. WR periodically collects data from internal views of OceanBase AI Database to record the system status, and provides related views for user display and management operations through the DBMS_WORKLOAD_REPOSITORY package.
210006 8192 wr schedular cpu time The total CPU time consumed by a WR (Workload Repository) import task, in microseconds. WR periodically collects data from internal views of OceanBase AI Database to record system status, and provides related views for user display and management operations through the DBMS_WORKLOAD_REPOSITORY package.
210007 8192 wr user submit snapshot elapse time The total time consumed in collecting WR (Workload Repository) snapshots, in microseconds. WR periodically collects data from internal views of OceanBase AI Database to record the system's status, and provides related views for user display and management operations through the DBMS_WORKLOAD_REPOSITORY package.
210008 8192 wr user submit snapshot cpu time The total CPU time consumed by the user-initiated collection of Workload Repository (WR) snapshots, in microseconds. WR periodically collects data from internal OceanBase views to record system status and provides related views for user display and management operations through the DBMS_WORKLOAD_REPOSITORY package.
210009 8192 wr collected active session history row count Total number of ASH (ob_active_session_history) rows collected by WR, in rows. WR periodically collects data from internal OceanBase views to record system status and provides related views for user display and management operations through the DBMS_WORKLOAD_REPOSITORY package.
210010 8192 ash schedular elapse time Total time spent by ASH sampling threads, in microseconds. ASH is a diagnostic mechanism based on sampling records from all active sessions within OceanBase AI Database. It uses background threads to sample the runtime status of active sessions every second.
210011 8192 ash schedular cpu time The total CPU time consumed by the ASH sampling thread, in microseconds. ASH is a diagnostic mechanism based on sampling records from all active sessions within OceanBase AI Database. It uses background threads to sample the operational status of active sessions every second.

References

For an overview of specific monitoring metrics, see Overview of system monitoring metrics.

Previous topic

V$OB_THREAD
Last

Next topic

Common wait events
Next
on this page
Query metric items
Metric categories
Network
Request queue
Transactions
SQL
Caching
Storage
Resources
Logs
CLOG
Root Service
ASH
TableAPI
WR
References