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

Monitor historical session performance

Last Updated:2026-11-16 14:00:06

View historical session data
View historical session statistics
View time model statistics
View SQLSTAT data
View OBServer resource group information
References

WR periodically collects data from performance views and persists and displays the collected information, including ASH, statistics, wait events, and SQL execution details.

View historical session data

  • Query the oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY view for persistent ASH data of all tenants.

    obclient [oceanbase]> SELECT * FROM oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY limit 1\G
    

    The query result is as follows:

    *************************** 1. row ***************************
                    CLUSTER_ID: 10001
                      TENANT_ID: 1
                        SNAP_ID: 1
                        SVR_IP: xx.xx.xx.xx
                      SVR_PORT: 2882
                      SAMPLE_ID: 10
                    SESSION_ID: 4611686018427389188
                    SAMPLE_TIME: 2026-03-16 16:30:16.853022
                        USER_ID: 200001
                  SESSION_TYPE: 1
                  SESSION_STATE: ON CPU
                        SQL_ID: F9C0A3AB0A89EA2048B7A9F436596C68
                      TRACE_ID: xxxxxxxxx-xxxxxxxxx-0-0
                      EVENT_NO: 0
                      EVENT_ID: NULL
                    TIME_WAITED: 0
                            P1: 0
                            P2: 0
                            P3: 0
              SQL_PLAN_LINE_ID: 1
                      GROUP_ID: 0
                      PLAN_HASH: 3290318591324336132
                      THREAD_ID: 111169
                      STMT_TYPE: 2
                          TX_ID: 27
            BLOCKING_SESSION_ID: NULL
                    TIME_MODEL: 0
                      IN_PARSE: N
                    IN_PL_PARSE: N
                  IN_PLAN_CACHE: N
                IN_SQL_OPTIMIZE: N
              IN_SQL_EXECUTION: N
                IN_PX_EXECUTION: N
              IN_SEQUENCE_LOAD: N
                  IN_COMMITTING: N
                IN_STORAGE_READ: N
              IN_STORAGE_WRITE: N
        IN_REMOTE_DAS_EXECUTION: N
          IN_PLSQL_COMPILATION: N
            IN_PLSQL_EXECUTION: N
                IN_FILTER_ROWS: N
                  IN_RPC_ENCODE: N
                  IN_RPC_DECODE: N
              IN_CONNECTION_MGR: N
                        PROGRAM: T1_RPC_REQUEST
                        MODULE: LOCAL INNER SQL EXEC
                        ACTION: NULL_INNER_SQL
                      CLIENT_ID: NULL
                      BACKTRACE: NULL
                        PLAN_ID: 289
                  TM_DELTA_TIME: 37301
              TM_DELTA_CPU_TIME: 36278
              TM_DELTA_DB_TIME: 36295
              TOP_LEVEL_SQL_ID: NULL
          PLSQL_ENTRY_OBJECT_ID: NULL
      PLSQL_ENTRY_SUBPROGRAM_ID: NULL
    PLSQL_ENTRY_SUBPROGRAM_NAME: NULL
                PLSQL_OBJECT_ID: NULL
            PLSQL_SUBPROGRAM_ID: NULL
          PLSQL_SUBPROGRAM_NAME: NULL
        DELTA_READ_IO_REQUESTS: 0
            DELTA_READ_IO_BYTES: 0
        DELTA_WRITE_IO_REQUESTS: 0
          DELTA_WRITE_IO_BYTES: 0
                      TABLET_ID: NULL
                      PROXY_SID: 4611686018427389188
                        WEIGHT: 1
    

    The following table describes the fields.

    Field
    Description
    CLUSTER_ID The cluster ID.
    TENANT_ID The tenant ID.
    SNAP_ID The snapshot ID.
    SVR_IP The IP address of the node.
    SVR_PORT The port number of the node.
    SAMPLE_ID The sample ID.
    SESSION_ID The ID of the sampled session.
    SAMPLE_TIME The sampling time.
    USER_ID The user ID of the sampled session.
    SESSION_TYPE The session type.
    • N: FOREGROUND indicates a foreground session, that is, a user session.
    • Y: BACKGROUND indicates a background session.
    SESSION_STATE The state of the session at the time of sampling.
    • EVENT_NO == 0: "ON CPU" indicates no wait and SQL logic is being executed.
    • EVENT_NO ≠ 0: "WAITING" indicates a wait is in progress. For details, refer to the EVENT column.
    SQL_ID The SQL ID.
    TRACE_ID TRACE_ID
    EVENT_NO The internal number of the waiting event, used for cross-table queries.
    EVENT_ID The ID of the current waiting event.
    TIME_WAITED The total wait time for this waiting event, in microseconds (us).
    P1 The value of parameter 1 of the waiting event.
    P2 The value of parameter 2 of the waiting event.
    P3 The value of parameter 3 of the waiting event.
    SQL_PLAN_LINE_ID The ID of the corresponding SQL operator at the time of sampling. The value is NULL if no operator is found.
    GROUP_ID The group information at the sampling point.
    PLAN_HASH The plan hash of the SQL command being executed.
    THREAD_ID The thread ID of the current active session.
    STMT_TYPE The SQL type of the current active session.
    TIME_MODEL Information related to TIME MODEL.
    IN_PARSE Whether the current session is performing SQL parse at the time of sampling.
    IN_PL_PARSE Whether the current session is performing SQL PL parse at the time of sampling.
    IN_PLAN_CACHE Whether the current session is performing plan cache at the time of sampling.
    IN_SQL_OPTIMIZE Whether the current session is performing SQL optimization at the time of sampling.
    IN_SQL_EXECUTION Whether the current session is performing SQL execution at the time of sampling.
    IN_PX_EXECUTION Whether the current session is performing SQL parallel execution at the time of sampling. When the session is in this state, it must also be in the IN_SQL_EXECUTION state.
    IN_SEQUENCE_LOAD Whether the current session is retrieving values from an auto-increment column or a sequence at the time of sampling.
    IN_COMMITTING Whether the current sampling point is in the transaction commit phase.
    IN_STORAGE_READ Whether the current sampling point is in the storage read phase.
    IN_STORAGE_WRITE Whether the current sampling point is in the storage write phase.
    IN_REMOTE_DAS_EXECUTION Whether the current sampling point is in the DAS remote execution phase.
    IN_FILTER_ROWS Indicates whether the current sampling point is in the storage pushdown execution phase.
    IN_RPC_ENCODE Indicates whether the current SQL is undergoing serialization.
    IN_RPC_DECODE Indicates whether the current SQL is undergoing deserialization.
    IN_CONNECTION_MGR Indicates whether the current SQL is establishing a connection.
    PROGRAM The program name being executed at the current sampling point:
    • Background thread: refers to the thread name, for example, observer, WrTimer, etc.
    • Frontend thread:
      • For regular requests: user@client_ip (thread_name)
      • inner_sql remote execution: INNER SQL REMOTE EXEC (thread_name)
      • DAS remote execution: DAS REMOTE EXEC (thread_name)
    MODULE The MODULE value recorded for the current session at the sampling moment, set via the DBMS_APPLICATION_INFO.SET_MODULE package
    ACTION The ACTION value recorded for the current session at the sampling moment, set via the DBMS_APPLICATION_INFO.SET_ACTION package
    CLIENT_ID The CLIENT_ID value recorded for the current session at the sampling moment, set via the DBMS_APPLICATION_INFO.set_identifier package
    BACKTRACE An auxiliary debugging field used to record the code call stack when an event occurs
    PLAN_ID The plan ID of the sampled SQL in the PLAN CACHE, used to associate the sampling point with the plan
    TM_DELTA_TIME The time interval calculated for the time model, in microseconds
    TM_DELTA_CPU_TIME The amount of time spent on the CPU during the past TM_DELTA_TIME period
    TM_DELTA_DB_TIME The amount of time spent on database calls during the past TM_DELTA_TIME period
    TOP_LEVEL_SQL_ID The top-level SQL ID
    IN_PLSQL_COMPILATION The current PL compilation status: Y/N
    IN_PLSQL_EXECUTION The current PL execution status: Y/N
    PLSQL_ENTRY_OBJECT_ID The OBJECT ID of the top-level PL
    PLSQL_ENTRY_SUBPROGRAM_ID The Sub project ID of the top-level PL
    PLSQL_ENTRY_SUBPROGRAM_NAME The Sub project name of the top-level PL
    PLSQL_OBJECT_ID The ID of the PL object currently being executed
    PLSQL_SUBPROGRAM_ID The ID of the PL subprogram currently being executed
    PLSQL_SUBPROGRAM_NAME The name of the PL subprogram currently being executed
    BLOCKING_SESSION_ID If the current session is blocked, displays the session ID that blocked it. Currently only effective in lock conflict scenarios, showing the ID of the session holding the lock.
    TABLET_ID The ID of the tablet being processed by the current SQL
    PROXY_sid The proxy session ID
    TX_ID The current transaction ID
    DELTA_READ_IO_REQUESTS The number of reads between two samples
    DELTA_READ_IO_BYTES The cumulative size of files read between two samples
    DELTA_WRITE_IO_REQUESTS The number of writes between two samples
    DELTA_WRITE_IO_BYTES The cumulative size of files written between two samples
    WEIGHT The number of occurrences of the same tenant and action within the time range corresponding to this WR record

    For more information about the oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY view, see oceanbase.CDB_WR_ACTIVE_SESSION_HISTORY.

  • Use the oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY view to view ASH data of the current tenant after it is persisted.

    obclient [oceanbase]> SELECT * FROM oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY limit 1\G
    

    The query result is as follows:

    *************************** 1. row ***************************
                    CLUSTER_ID: 10001
                      TENANT_ID: 1
                        SNAP_ID: 1
                        SVR_IP: xx.xx.xx.xx
                      SVR_PORT: 2882
                      SAMPLE_ID: 10
                    SESSION_ID: 4611686018427389188
                    SAMPLE_TIME: 2026-03-16 16:30:16.853022
                        USER_ID: 200001
                  SESSION_TYPE: 1
                  SESSION_STATE: ON CPU
                        SQL_ID: F9C0A3AB0A89EA2048B7A9F436596C68
                      TRACE_ID: xx.xx.xx.xx-xx.xx.xx.xx-0-0
                      EVENT_NO: 0
                      EVENT_ID: NULL
                    TIME_WAITED: 0
                            P1: 0
                            P2: 0
                            P3: 0
              SQL_PLAN_LINE_ID: 1
                      GROUP_ID: 0
                      PLAN_HASH: 3290318591324336132
                      THREAD_ID: 111169
                      STMT_TYPE: 2
                          TX_ID: 27
            BLOCKING_SESSION_ID: NULL
                    TIME_MODEL: 0
                      IN_PARSE: N
                    IN_PL_PARSE: N
                  IN_PLAN_CACHE: N
                IN_SQL_OPTIMIZE: N
              IN_SQL_EXECUTION: N
                IN_PX_EXECUTION: N
              IN_SEQUENCE_LOAD: N
                  IN_COMMITTING: N
                IN_STORAGE_READ: N
              IN_STORAGE_WRITE: N
        IN_REMOTE_DAS_EXECUTION: N
          IN_PLSQL_COMPILATION: N
            IN_PLSQL_EXECUTION: N
                IN_FILTER_ROWS: N
                  IN_RPC_ENCODE: N
                  IN_RPC_DECODE: N
              IN_CONNECTION_MGR: N
                        PROGRAM: T1_RPC_REQUEST
                        MODULE: LOCAL INNER SQL EXEC
                        ACTION: NULL_INNER_SQL
                      CLIENT_ID: NULL
                      BACKTRACE: NULL
                        PLAN_ID: 289
                  TM_DELTA_TIME: 37301
              TM_DELTA_CPU_TIME: 36278
              TM_DELTA_DB_TIME: 36295
              TOP_LEVEL_SQL_ID: NULL
          PLSQL_ENTRY_OBJECT_ID: NULL
      PLSQL_ENTRY_SUBPROGRAM_ID: NULL
    PLSQL_ENTRY_SUBPROGRAM_NAME: NULL
                PLSQL_OBJECT_ID: NULL
            PLSQL_SUBPROGRAM_ID: NULL
          PLSQL_SUBPROGRAM_NAME: NULL
        DELTA_READ_IO_REQUESTS: 0
            DELTA_READ_IO_BYTES: 0
        DELTA_WRITE_IO_REQUESTS: 0
          DELTA_WRITE_IO_BYTES: 0
                      TABLET_ID: NULL
                      PROXY_SID: 4611686018427389188
                        WEIGHT: 1
    1 row in set (0.093 sec)
    

    The following table describes the fields.

    Field
    Description
    CLUSTER_ID The cluster ID.
    TENANT_ID The tenant ID.
    SNAP_ID The snapshot ID.
    SVR_IP The IP address of the node.
    SVR_PORT The port number of the node.
    SAMPLE_ID The sampling ID.
    SESSION_ID The ID of the sampled session.
    SAMPLE_TIME The sampling time.
    USER_ID The user ID of the sampled session.
    SESSION_TYPE The session type.
    • N: FOREGROUND indicates a foreground session, that is, a user session.
    • Y: BACKGROUND indicates a background session.
    SESSION_STATE The state of the session at the time of sampling.
    • EVENT_NO == 0: "ON CPU" indicates that the session is currently not waiting and is executing SQL logic.
    • EVENT_NO ≠ 0: "WAITING" indicates that the session is currently waiting. For details about the wait content, refer to the EVENT field.
    SQL_ID The SQL ID.
    TRACE_ID TRACE_ID
    EVENT_NO The internal number of the wait event, used for associated queries with other tables.
    EVENT_ID The ID of the current wait event.
    TIME_WAITED The total wait time of the wait event, in microseconds (us).
    P1 The value of parameter 1 of the wait event.
    P2 The value of parameter 2 of the wait event.
    P3 The value of parameter 3 of the wait event.
    SQL_PLAN_LINE_ID The ID of the corresponding SQL operator at the time of sampling. The value is NULL if no corresponding operator exists.
    GROUP_ID The group information at the sampling point.
    PLAN_HASH The plan hash corresponding to the currently executed SQL command.
    THREAD_ID The thread ID of the currently active session.
    STMT_TYPE The SQL type of the currently active session.
    TIME_MODEL Information related to TIME MODEL.
    IN_PARSE Whether the current session is performing SQL parse at the time of sampling.
    IN_PL_PARSE Whether the current session is performing SQL PL parse at the time of sampling.
    IN_PLAN_CACHE Whether the current session is performing plan cache at the time of sampling.
    IN_SQL_OPTIMIZE Whether the current session is performing SQL optimization at the time of sampling.
    IN_SQL_EXECUTION Whether the current session is performing SQL execution at the time of sampling.
    IN_PX_EXECUTION Whether the current session is performing SQL parallel execution at the time of sampling. When the session is in this state, it must also be in the IN_SQL_EXECUTION state.
    IN_SEQUENCE_LOAD Whether the current session is retrieving values from an auto-increment column or a sequence at the time of sampling.
    IN_COMMITTING Whether the current sampling point is in the transaction commit phase.
    IN_STORAGE_READ Whether the current sampling point is in the storage read phase.
    IN_STORAGE_WRITE Whether the current sampling point is in the storage write phase.
    IN_REMOTE_DAS_EXECUTION Whether the current sampling point is in the DAS remote execution phase.
    IN_FILTER_ROWS Whether the current sampling point is in the storage pushdown execution phase.
    IN_RPC_ENCODE The serialization operation currently being performed by the SQL statement.
    IN_RPC_DECODE The deserialization operation currently being performed by the SQL statement.
    IN_CONNECTION_MGR The connection establishment operation currently being performed by the SQL statement.
    PROGRAM The name of the program currently being executed at the sampling point:
    • Background thread: refers to the thread name, such as observer and WrTimer.
    • Foreground thread:
      • A regular request is represented as user@client_ip (thread_name).
      • inner_sql remote execution is represented as INNER SQL REMOTE EXEC (thread_name).
      • DAS remote execution is represented as DAS REMOTE EXEC (thread_name).
    MODULE The MODULE value recorded on the current session at the time of sampling. This value is set using the DBMS_APPLICATION_INFO.SET_MODULE package.
    ACTION The ACTION value recorded on the current session at the time of sampling. This value is set using the DBMS_APPLICATION_INFO.SET_ACTION package.
    CLIENT_ID The CLIENT_ID value recorded on the current session at the time of sampling. This value is set using the DBMS_APPLICATION_INFO.set_identifier package.
    BACKTRACE An auxiliary debugging field used to record the code call stack when the event occurred.
    PLAN_ID The plan ID of the sampled SQL statement in the PLAN CACHE, used to associate the sampling point with the plan.
    TM_DELTA_TIME The time interval for calculating the time model, in microseconds.
    TM_DELTA_CPU_TIME The amount of time spent on the CPU during the past TM_DELTA_TIME period.
    TM_DELTA_DB_TIME The amount of time spent on database calls during the past TM_DELTA_TIME period.
    TOP_LEVEL_SQL_ID The top-level SQL ID.
    IN_PLSQL_COMPILATION The current PL compilation status: Y/N
    IN_PLSQL_EXECUTION The current PL execution status: Y/N
    PLSQL_ENTRY_OBJECT_ID The OBJECT ID of the top-level PL.
    PLSQL_ENTRY_SUBPROGRAM_ID The Sub project ID of the top-level PL.
    PLSQL_ENTRY_SUBPROGRAM_NAME The Sub project name of the top-level PL.
    PLSQL_OBJECT_ID The ID of the PL object currently being executed.
    PLSQL_SUBPROGRAM_ID The ID of the PL subprogram currently being executed.
    PLSQL_SUBPROGRAM_NAME The name of the PL subprogram currently being executed.
    BLOCKING_SESSION_ID If the current session is blocked, displays the ID of the session that blocked it. Currently effective only in lock conflict scenarios, showing the ID of the session holding the lock.
    TABLET_ID The ID of the tablet being processed by the current SQL statement.
    PROXY_sid The proxy session ID.
    TX_ID The current transaction ID.
    DELTA_READ_IO_REQUESTS The number of reads between two samples.
    DELTA_READ_IO_BYTES The cumulative size of files read between two samples.
    DELTA_WRITE_IO_REQUESTS The number of writes between two samples.
    DELTA_WRITE_IO_BYTES The cumulative size of files written between two samples.
    WEIGHT The number of occurrences of the same tenant and action within the time range corresponding to this WR record.

    For more information about the DBA_WR_ACTIVE_SESSION_HISTORY view, see oceanbase.DBA_WR_ACTIVE_SESSION_HISTORY.

  • Query the GV$OB_ACTIVE_SESSION_HISTORY view for active session history.

    obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_ACTIVE_SESSION_HISTORY limit 1\G
    

    The query result is as follows:

      *************************** 1. row ***************************
                          SVR_IP: xx.xx.xx.xx
                        SVR_PORT: 2882
                        SAMPLE_ID: 589519
                      SAMPLE_TIME: 2026-03-17 15:36:38.029639
                          CON_ID: 1001
                          USER_ID: 0
                      SESSION_ID: 2305843009213712375
                    SESSION_TYPE: BACKGROUND
                    SESSION_STATE: WAITING
                          SQL_ID: NULL
                          PLAN_ID: 0
                        TRACE_ID: NULL
                            EVENT: remote log writer cond wait
                        EVENT_NO: 141
                        EVENT_ID: 18249
                          P1TEXT: address
                              P1: 139637653681328
                          P2TEXT:
                              P2: 0
                          P3TEXT:
                              P3: 0
                      WAIT_CLASS: CONCURRENCY
                    WAIT_CLASS_ID: 104
                      TIME_WAITED: 99812
                SQL_PLAN_LINE_ID: NULL
                        GROUP_ID: 0
                        PLAN_HASH: NULL
                        THREAD_ID: 111438
                        STMT_TYPE: NULL
                      TIME_MODEL: 0
                        IN_PARSE: N
                      IN_PL_PARSE: N
                    IN_PLAN_CACHE: N
                  IN_SQL_OPTIMIZE: N
                IN_SQL_EXECUTION: N
                  IN_PX_EXECUTION: N
                IN_SEQUENCE_LOAD: N
                    IN_COMMITTING: N
                  IN_STORAGE_READ: N
                IN_STORAGE_WRITE: N
          IN_REMOTE_DAS_EXECUTION: N
                  IN_FILTER_ROWS: N
                    IN_RPC_ENCODE: N
                    IN_RPC_DECODE: N
                IN_CONNECTION_MGR: N
                          PROGRAM: T1001_LogService
                          MODULE: LogRestoreService
                          ACTION: RemoteLogWriter
                        CLIENT_ID: NULL
                        BACKTRACE: NULL
                    TM_DELTA_TIME: 997367
                TM_DELTA_CPU_TIME: 250
                TM_DELTA_DB_TIME: 997367
                TOP_LEVEL_SQL_ID: NULL
            IN_PLSQL_COMPILATION: N
              IN_PLSQL_EXECUTION: N
            PLSQL_ENTRY_OBJECT_ID: NULL
        PLSQL_ENTRY_SUBPROGRAM_ID: NULL
      PLSQL_ENTRY_SUBPROGRAM_NAME: NULL
                  PLSQL_OBJECT_ID: NULL
              PLSQL_SUBPROGRAM_ID: NULL
            PLSQL_SUBPROGRAM_NAME: NULL
                            TX_ID: NULL
              BLOCKING_SESSION_ID: NULL
                        TABLET_ID: NULL
                        PROXY_SID: 2305843009213712375
          DELTA_READ_IO_REQUESTS: 0
              DELTA_READ_IO_BYTES: 0
          DELTA_WRITE_IO_REQUESTS: 0
            DELTA_WRITE_IO_BYTES: 0
                          WEIGHT: 1
              IS_WR_WEIGHT_SAMPLE: N
      1 row in set (0.015 sec)
    

    The following table describes the fields.

    Field
    Description
    SVR_IP The IP address of the server to which the sample belongs.
    SVR_PORT The port number of the server to which the sample belongs.
    SAMPLE_ID The unique local sample ID.
    SAMPLE_TIME The sampling time.
    CON_ID The tenant ID.
    USER_ID The user ID of the sampled session.
    SESSION_ID The ID of the sampled session.
    SESSION_TYPE The session type. Valid values:
    • FOREGROUND: The session is in the foreground, that is, it is a user session.
    • (Not supported.) BACKGROUND: The session is in the background.
    SESSION_STATE The session state. Valid values:
    • ON CPU: The session is not waiting and is currently executing SQL logic.
    • WAITING: The session is waiting. For details about the wait event, see the EVENT column.
    SQL_ID The SQL ID.
    PLAN_ID The plan ID of the sampled SQL statement in the PLAN CACHE, used to associate the sampling point with the plan.
    TRACE_ID The trace ID of the operator.
    EVENT The description of the wait event.
    EVENT_NO The internal number of the wait event, used to join queries with other tables.
    EVENT_ID The ID of the current wait event.
    P1TEXT The name of parameter 1 of the wait event. The name varies depending on the event.
    P1 The value of parameter 1 of the wait event.
    P2TEXT The name of parameter 2 of the wait event. The name varies depending on the event.
    P2 The value of parameter 2 of the wait event.
    P3TEXT The name of parameter 3 of the wait event. The name varies depending on the event.
    P3 The value of parameter 3 of the wait event.
    WAIT_CLASS The type of the wait event.
    WAIT_CLASS_ID The ID of the wait event type, used to join queries with other tables.
    TIME_WAITED The total wait time of the wait event, in microseconds (us).
    SQL_PLAN_LINE_ID The line number of the SQL operator in the SQL plan when the session was sampled.
    GROUP_ID The group information at the sampling point.
    PLAN_HASH The plan hash corresponding to the currently executed SQL command.
    THREAD_ID The thread ID of the currently active session.
    STMT_TYPE The SQL type of the currently active session.
    IN_PARSE Indicates whether the session is performing SQL parse at the time of sampling.
    IN_PL_PARSE Indicates whether the session is performing SQL PL parse at the time of sampling.
    IN_PLAN_CACHE Indicates whether the session is performing plan cache matching at the time of sampling.
    IN_SQL_OPTIMIZE Indicates whether the session is performing SQL parsing optimization at the time of sampling.
    IN_SQL_EXECUTION Indicates whether the session is performing SQL execution at the time of sampling.
    IN_PX_EXECUTION Indicates whether the session is performing SQL parallel execution at the time of sampling. When the session is in this state, it must also be in the IN_SQL_EXECUTION state.
    IN_SEQUENCE_LOAD Indicates whether the session is loading auto-increment columns or sequence values at the time of sampling.
    IN_COMMITTING Indicates whether the current sampling point is in the transaction commit phase.
    IN_STORAGE_READ Indicates whether the current sampling point is in the storage read phase.
    IN_STORAGE_WRITE Indicates whether the current sampling point is in the storage write phase.
    IN_REMOTE_DAS_EXECUTION Indicates whether the current sampling point is in the DAS remote execution phase.
    IN_FILTER_ROWS Indicates whether the current sampling point is in the storage pushdown execution phase.
    IN_RPC_ENCODE Indicates whether the current SQL statement is undergoing serialization.
    IN_RPC_DECODE Indicates whether the current SQL statement is undergoing deserialization.
    IN_CONNECTION_MGR Indicates whether the current SQL statement is establishing a connection.
    PROGRAM The name of the program being executed at the current sampling point. Valid values:
    • Background thread: The thread name, for example, observer, WrTimer, etc.
    • Foreground thread:
      • A regular request is user@client_ip (thread_name).
      • inner_sql remote execution is INNER SQL REMOTE EXEC (thread_name).
      • DAS remote execution is DAS REMOTE EXEC (thread_name).
    MODULE The MODULE value recorded during the session sampling. This value is set using the DBMS_APPLICATION_INFO.SET_MODULE package.
    ACTION The ACTION value recorded during the session sampling. This value is set using the DBMS_APPLICATION_INFO.SET_ACTION package.
    CLIENT_ID The CLIENT_ID value recorded during the session sampling. This value is set using the DBMS_APPLICATION_INFO.set_identifier package.
    BACKTRACE An auxiliary debugging field that records the code call stack at the time the event occurred. The value of this field is always NULL.
    TM_DELTA_TIME The time interval calculated for the time model, in microseconds.
    TM_DELTA_CPU_TIME The amount of time spent on the CPU during the past TM_DELTA_TIME period.
    TM_DELTA_DB_TIME The amount of time spent on database calls during the past TM_DELTA_TIME period.
    TOP_LEVEL_SQL_ID The top-level SQL ID.
    IN_PLSQL_COMPILATION The current PL compilation status: Y/N.
    IN_PLSQL_EXECUTION The current PL execution status: Y/N.
    PLSQL_ENTRY_OBJECT_ID The OBJECT ID of the top-level PL.
    PLSQL_ENTRY_SUBPROGRAM_ID The Sub project ID of the top-level PL.
    PLSQL_ENTRY_SUBPROGRAM_NAME The Sub project name of the top-level PL.
    PLSQL_OBJECT_ID The ID of the PL object currently being executed.
    PLSQL_SUBPROGRAM_ID The ID of the PL subprogram currently being executed.
    PLSQL_SUBPROGRAM_NAME The name of the PL subprogram currently being executed.
    BLOCKING_SESSION_ID If the current session is blocked, displays the session ID that blocked it. Currently effective only in lock conflict scenarios, showing the ID of the session holding the lock.
    TABLET_ID The ID of the tablet being processed by the current SQL statement.
    PROXY_sid The proxy session ID.
    TX_ID The current transaction ID.
    DELTA_READ_IO_REQUESTS The number of reads between two samples.
    DELTA_READ_IO_BYTES The cumulative size of files read between two samples.
    DELTA_WRITE_IO_REQUESTS The number of writes between two samples.
    DELTA_WRITE_IO_BYTES The cumulative size of files written between two samples.
    WEIGHT The number of occurrences of the same tenant and action within the time range corresponding to this WR record.
    IS_WR_WEIGHT_SAMPLE Indicates whether it is an "aggregated" column for queue backlog wait events.

    For more information about the GV$OB_ACTIVE_SESSION_HISTORY view, see GV$OB_ACTIVE_SESSION_HISTORY.

  • Query the V$OB_ACTIVE_SESSION_HISTORY view for the history of active sessions.

    obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_ACTIVE_SESSION_HISTORY limit 1\G
    

    The query result is as follows:

    *************************** 1. row ***************************
                        SVR_IP: xx.xx.xx.xx
                      SVR_PORT: 2882
                      SAMPLE_ID: 611098
                    SAMPLE_TIME: 2026-03-17 16:25:41.380291
                        CON_ID: 1001
                        USER_ID: 0
                    SESSION_ID: 2305843009213712375
                  SESSION_TYPE: BACKGROUND
                  SESSION_STATE: WAITING
                        SQL_ID: NULL
                        PLAN_ID: 0
                      TRACE_ID: NULL
                          EVENT: remote log writer cond wait
                      EVENT_NO: 141
                      EVENT_ID: 18249
                        P1TEXT: address
                            P1: 139637653681328
                        P2TEXT:
                            P2: 0
                        P3TEXT:
                            P3: 0
                    WAIT_CLASS: CONCURRENCY
                  WAIT_CLASS_ID: 104
                    TIME_WAITED: 99806
              SQL_PLAN_LINE_ID: NULL
                      GROUP_ID: 0
                      PLAN_HASH: NULL
                      THREAD_ID: 111438
                      STMT_TYPE: NULL
                    TIME_MODEL: 0
                      IN_PARSE: N
                    IN_PL_PARSE: N
                  IN_PLAN_CACHE: N
                IN_SQL_OPTIMIZE: N
              IN_SQL_EXECUTION: N
                IN_PX_EXECUTION: N
              IN_SEQUENCE_LOAD: N
                  IN_COMMITTING: N
                IN_STORAGE_READ: N
              IN_STORAGE_WRITE: N
        IN_REMOTE_DAS_EXECUTION: N
                IN_FILTER_ROWS: N
                  IN_RPC_ENCODE: N
                  IN_RPC_DECODE: N
              IN_CONNECTION_MGR: N
                        PROGRAM: T1001_LogService
                        MODULE: LogRestoreService
                        ACTION: RemoteLogWriter
                      CLIENT_ID: NULL
                      BACKTRACE: NULL
                  TM_DELTA_TIME: 997935
              TM_DELTA_CPU_TIME: 243
              TM_DELTA_DB_TIME: 997935
              TOP_LEVEL_SQL_ID: NULL
          IN_PLSQL_COMPILATION: N
            IN_PLSQL_EXECUTION: N
          PLSQL_ENTRY_OBJECT_ID: NULL
      PLSQL_ENTRY_SUBPROGRAM_ID: NULL
    PLSQL_ENTRY_SUBPROGRAM_NAME: NULL
                PLSQL_OBJECT_ID: NULL
            PLSQL_SUBPROGRAM_ID: NULL
          PLSQL_SUBPROGRAM_NAME: NULL
                          TX_ID: NULL
            BLOCKING_SESSION_ID: NULL
                      TABLET_ID: NULL
                      PROXY_SID: 2305843009213712375
        DELTA_READ_IO_REQUESTS: 0
            DELTA_READ_IO_BYTES: 0
        DELTA_WRITE_IO_REQUESTS: 0
          DELTA_WRITE_IO_BYTES: 0
                        WEIGHT: 1
            IS_WR_WEIGHT_SAMPLE: N
    1 row in set (0.015 sec)
    

    The following table describes the fields.

    Field
    Description
    SVR_IP The IP address of the server to which the sample belongs.
    SVR_PORT The port number of the server to which the sample belongs.
    SAMPLE_ID The unique local ID of the sample.
    SAMPLE_TIME The sampling time.
    CON_ID The tenant ID.
    USER_ID The user ID of the sampled session.
    SESSION_ID The ID of the sampled session.
    SESSION_TYPE The session type. Valid values:
    • FOREGROUND: The session is in the foreground, that is, it is a user session.
    • (Not supported.) BACKGROUND: The session is in the background.
    SESSION_STATE The session state. Valid values:
    • ON CPU: The session is not waiting and is currently executing SQL logic.
    • WAITING: The session is waiting. For details about the wait event, see the EVENT column.
    SQL_ID The SQL ID.
    PLAN_ID The plan ID of the sampled SQL statement in the PLAN CACHE, used to associate the sampling point with the plan.
    TRACE_ID The trace ID of the operator.
    EVENT The description of the wait event.
    EVENT_NO The internal number of the wait event, used to associate queries with other tables.
    EVENT_ID The ID of the current wait event.
    P1TEXT The name of parameter 1 of the wait event. The name varies depending on the value of the EVENT column.
    P1 The value of parameter 1 of the wait event.
    P2TEXT The name of parameter 2 of the wait event. The name varies depending on the value of the EVENT column.
    P2 The value of parameter 2 of the wait event.
    P3TEXT The name of parameter 3 of the wait event. The name varies depending on the value of the EVENT column.
    P3 The value of parameter 3 of the wait event.
    WAIT_CLASS The type of the wait event.
    WAIT_CLASS_ID The ID of the type of the wait event, used to associate queries with other tables.
    TIME_WAITED The total wait time of the wait event, in microseconds (us).
    SQL_PLAN_LINE_ID The line number of the SQL operator in the SQL plan when the session was sampled.
    GROUP_ID The group information at the sampling point.
    PLAN_HASH The plan hash corresponding to the currently executed SQL command.
    THREAD_ID The thread ID of the currently active session.
    STMT_TYPE The SQL type of the currently active session.
    IN_PARSE Indicates whether the session is performing SQL parse at the time of sampling.
    IN_PL_PARSE Indicates whether the session is performing SQL PL parse at the time of sampling.
    IN_PLAN_CACHE Indicates whether the session is performing plan cache matching at the time of sampling.
    IN_SQL_OPTIMIZE Indicates whether the session is performing SQL parsing optimization at the time of sampling.
    IN_SQL_EXECUTION Indicates whether the session is performing SQL execution at the time of sampling.
    IN_PX_EXECUTION Indicates whether the session is performing SQL parallel execution at the time of sampling. When the session is in this state, it must also be in the IN_SQL_EXECUTION state.
    IN_SEQUENCE_LOAD Indicates whether the session is fetching values from an auto-increment column or a sequence at the time of sampling.
    IN_COMMITTING Indicates whether the current sampling point is in the transaction commit phase.
    IN_STORAGE_READ Indicates whether the current sampling point is in the storage read phase.
    IN_STORAGE_WRITE Indicates whether the current sampling point is in the storage write phase.
    IN_REMOTE_DAS_EXECUTION Indicates whether the current sampling point is in the DAS remote execution phase.
    IN_FILTER_ROWS Indicates whether the current sampling point is in the storage pushdown execution phase.
    IN_RPC_ENCODE Indicates whether the current SQL statement is undergoing serialization.
    IN_RPC_DECODE Indicates whether the current SQL statement is undergoing deserialization.
    IN_CONNECTION_MGR Indicates whether the current SQL statement is establishing a connection.
    PROGRAM The name of the program being executed at the current sampling point. Valid values:
    • Background thread: The thread name, for example, observer, WrTimer, etc.
    • Foreground thread:
      • For regular requests: user@client_ip (thread_name)
      • inner_sql: INNER SQL REMOTE EXEC (thread_name)
      • DAS remote execution: DAS REMOTE EXEC (thread_name)
    MODULE The MODULE value recorded during sampling. This value is set by using the DBMS_APPLICATION_INFO.SET_MODULE package.
    ACTION The ACTION value recorded during sampling. This value is set by using the DBMS_APPLICATION_INFO.SET_ACTION package.
    CLIENT_ID The CLIENT_ID value recorded during sampling. This value is set by using the DBMS_APPLICATION_INFO.set_identifier package.
    BACKTRACE An auxiliary debugging field that records the code call stack at the time the event occurred. This field is always NULL.
    TM_DELTA_TIME The time interval for calculating the time model, in microseconds.
    TM_DELTA_CPU_TIME The amount of time spent on the CPU during the past TM_DELTA_TIME period.
    TM_DELTA_DB_TIME The amount of time spent on database calls during the past TM_DELTA_TIME period.
    TOP_LEVEL_SQL_ID The top-level SQL ID.
    IN_PLSQL_COMPILATION The current PL compilation status: Y/N.
    IN_PLSQL_EXECUTION The current PL execution status: Y/N.
    PLSQL_ENTRY_OBJECT_ID The OBJECT ID of the top-level PL.
    PLSQL_ENTRY_SUBPROGRAM_ID The Sub project ID of the top-level PL.
    PLSQL_ENTRY_SUBPROGRAM_NAME The Sub project name of the top-level PL.
    PLSQL_OBJECT_ID The ID of the PL object currently being executed.
    PLSQL_SUBPROGRAM_ID The ID of the PL subprogram currently being executed.
    PLSQL_SUBPROGRAM_NAME The name of the PL subprogram currently being executed.
    BLOCKING_SESSION_ID If the current session is blocked, displays the session ID that blocked it. Currently effective only in lock conflict scenarios, showing the session ID holding the lock.
    TABLET_ID The ID of the tablet being processed by the current SQL statement.
    PROXY_sid The proxy session ID.
    TX_ID The current transaction ID.
    DELTA_READ_IO_REQUESTS The number of reads between two samples.
    DELTA_READ_IO_BYTES The cumulative size of files read between two samples.
    DELTA_WRITE_IO_REQUESTS The number of writes between two samples.
    DELTA_WRITE_IO_BYTES The cumulative size of files written between two samples.
    WEIGHT The number of occurrences of the same tenant and action within the time range corresponding to this WR record.
    IS_WR_WEIGHT_SAMPLE Whether it is an "aggregated" column for queue backlog wait events.

    For more information about the V$OB_ACTIVE_SESSION_HISTORY view, see V$OB_ACTIVE_SESSION_HISTORY.

View historical session statistics

  • Query the oceanbase.CDB_WR_STATNAME view for the names of system statistics for all tenants.

    obclient [oceanbase]> SELECT * FROM oceanbase.CDB_WR_STATNAME limit 1;
    

    The query result is as follows:

      +------------+-----------+---------+---------------+
      | CLUSTER_ID | TENANT_ID | STAT_ID | STAT_NAME     |
      +------------+-----------+---------+---------------+
      |       4000 |         1 |   10000 | rpc packet in |
      +------------+-----------+---------+---------------+
      1 row in set (0.001 sec)
    

    The following table describes the fields.

    Field
    Description
    CLUSTER_ID The cluster ID.
    TENANT_ID The tenant ID.
    STAT_ID The statistics ID.
    STAT_NAME The statistics name.

    For more information about the oceanbase.CDB_WR_STATNAME view, see oceanbase.CDB_WR_STATNAME.

  • Use the oceanbase.DBA_WR_STATNAME view to view the names of the system statistics for the current tenant.

    obclient [oceanbase]> SELECT * FROM oceanbase.DBA_WR_STATNAME limit 1;
    

    The query result is as follows:

      +------------+-----------+---------+---------------+
      | CLUSTER_ID | TENANT_ID | STAT_ID | STAT_NAME     |
      +------------+-----------+---------+---------------+
      |       4000 |         1 |   10000 | rpc packet in |
      +------------+-----------+---------+---------------+
      1 row in set (0.004 sec)
    

    The following table describes the fields.

    Field
    Description
    CLUSTER_ID The cluster ID.
    TENANT_ID The tenant ID.
    STAT_ID The statistics ID.
    STAT_NAME The statistics name.

    For more information about the DBA_WR_STATNAME view, see oceanbase.DBA_WR_STATNAME.

  • Query the oceanbase.CDB_WR_SYSSTAT view for detailed information about system statistics for all tenants.

    obclient [oceanbase]> SELECT * FROM oceanbase.CDB_WR_SYSSTAT limit 1;
    

    The query result is as follows:

      +------------+-----------+---------+----------------+----------+---------+--------+
      | CLUSTER_ID | TENANT_ID | SNAP_ID | SVR_IP         | SVR_PORT | STAT_ID | VALUE  |
      +------------+-----------+---------+----------------+----------+---------+--------+
      |       4000 |         1 |     114 | xx.xx.xx.xx    |     2882 |   10000 | 228856 |
      +------------+-----------+---------+----------------+----------+---------+--------+
      1 row in set (0.036 sec)
    

    The following table describes the fields.

    Field
    Description
    CLUSTER_ID The cluster ID.
    TENANT_ID The tenant ID.
    SNAP_ID The snapshot ID.
    SVR_IP The IP address of the node.
    SVR_PORT The port number of the node.
    STAT_ID The ID of the statistic.
    VALUE The value of the statistic.

    For more information about the oceanbase.CDB_WR_SYSSTAT view, see oceanbase.CDB_WR_SYSSTAT.

  • Use the oceanbase.DBA_WR_SYSSTAT view to view detailed system statistics for the current tenant.

    obclient [oceanbase]> SELECT * FROM oceanbase.DBA_WR_SYSSTAT limit 1;
    

    The query result is as follows:

      +------------+-----------+---------+----------------+----------+---------+--------+
      | CLUSTER_ID | TENANT_ID | SNAP_ID | SVR_IP         | SVR_PORT | STAT_ID | VALUE  |
      +------------+-----------+---------+----------------+----------+---------+--------+
      |       4000 |         1 |     114 | xx.xx.xx.xx    |     2882 |   10000 | 228856 |
      +------------+-----------+---------+----------------+----------+---------+--------+
      1 row in set (0.026 sec)
    

    The following table describes the fields.

    Field
    Description
    CLUSTER_ID The cluster ID.
    TENANT_ID The tenant ID.
    SNAP_ID The snapshot ID.
    SVR_IP The IP address of the node.
    SVR_PORT The port number of the node.
    STAT_ID The ID of the statistic.
    VALUE The value of the statistic.

    For more information about the DBA_WR_SYSSTAT view, see oceanbase.DBA_WR_SYSSTAT.

View time model statistics

  • Query the GV$OB_SESS_TIME_MODEL view for session-level time model statistics in a cluster.

    obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_SESS_TIME_MODEL LIMIT 10;
    

    The query result is as follows:

    +---------------+-----------+----------------+----------+---------+--------------------+-------+
    | SID           | TENANT_ID | SVR_IP         | SVR_PORT | STAT_ID | STAT_NAME          | VALUE |
    +---------------+-----------+----------------+----------+---------+--------------------+-------+
    | 3298534883328 |      1002 | 172.xx.xxx.xxx |     2882 |  200010 | non idle wait time |     0 |
    | 3298534883328 |      1002 | 172.xx.xxx.xxx |     2882 |  200011 | idle wait time     |     0 |
    | 3848290697216 |      1001 | 172.xx.xxx.xxx |     2882 |  200010 | non idle wait time |     0 |
    | 3848290697216 |      1001 | 172.xx.xxx.xxx |     2882 |  200011 | idle wait time     |     0 |
    |    3221659555 |         1 | 172.xx.xxx.xxx |     2882 |  200010 | non idle wait time |     3 |
    |    3221659555 |         1 | 172.xx.xxx.xxx |     2882 |  200011 | idle wait time     |     0 |
    | 4398046511104 |      1001 | 172.xx.xxx.xxx |     2882 |  200010 | non idle wait time |     0 |
    | 4398046511104 |      1001 | 172.xx.xxx.xxx |     2882 |  200011 | idle wait time     |     0 |
    | 4947802324992 |      1004 | 172.xx.xxx.xxx |     2882 |  200010 | non idle wait time |     0 |
    | 4947802324992 |      1004 | 172.xx.xxx.xxx |     2882 |  200011 | idle wait time     |     0 |
    +---------------+-----------+----------------+----------+---------+--------------------+-------+
    10 rows in set
    

    The following table describes the fields.

    Field
    Description
    SID The session ID.
    TENANT_ID The tenant ID.
    SVR_IP The IP address of the node.
    SVR_PORT The port number of the node.
    STAT_ID The ID of the statistic.
    STAT_NAME The name of the statistic.
    VALUE The value of the statistic.

    For more information about the GV$OB_SESS_TIME_MODEL view, see GV$OB_SESS_TIME_MODEL.

  • Query the V$OB_SESS_TIME_MODEL view for session-level time model statistics on the current node.

    obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_SESS_TIME_MODEL LIMIT 10;
    

    The query result is as follows:

    +---------------+-----------+----------------+----------+---------+--------------------+-------+
    | SID           | TENANT_ID | SVR_IP         | SVR_PORT | STAT_ID | STAT_NAME          | VALUE |
    +---------------+-----------+----------------+----------+---------+--------------------+-------+
    | 3298534883328 |      1002 | 172.xx.xxx.xxx |     2882 |  200010 | non idle wait time |     0 |
    | 3298534883328 |      1002 | 172.xx.xxx.xxx |     2882 |  200011 | idle wait time     |     0 |
    | 3848290697216 |      1001 | 172.xx.xxx.xxx |     2882 |  200010 | non idle wait time |     0 |
    | 3848290697216 |      1001 | 172.xx.xxx.xxx |     2882 |  200011 | idle wait time     |     0 |
    | 4398046511104 |      1001 | 172.xx.xxx.xxx |     2882 |  200010 | non idle wait time |     0 |
    | 4398046511104 |      1001 | 172.xx.xxx.xxx |     2882 |  200011 | idle wait time     |     0 |
    |    3221667747 |         1 | 172.xx.xxx.xxx |     2882 |  200010 | non idle wait time |     0 |
    |    3221667747 |         1 | 172.xx.xxx.xxx |     2882 |  200011 | idle wait time     |     0 |
    | 4947802324992 |      1004 | 172.xx.xxx.xxx |     2882 |  200010 | non idle wait time |     0 |
    | 4947802324992 |      1004 | 172.xx.xxx.xxx |     2882 |  200011 | idle wait time     |     0 |
    +---------------+-----------+----------------+----------+---------+--------------------+-------+
    10 rows in set
    

    The following table describes the fields.

    Field
    Description
    SID The session ID.
    TENANT_ID The tenant ID.
    SVR_IP The IP address of the node.
    SVR_PORT The port number of the node.
    STAT_ID The ID of the statistic.
    STAT_NAME The name of the statistic.
    VALUE The value of the statistic.

    For more information about the V$OB_SESS_TIME_MODEL view, see V$OB_SESS_TIME_MODEL.

  • Query the GV$OB_SYS_TIME_MODEL view for tenant-level time model statistics in a cluster.

    obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_SYS_TIME_MODEL;
    

    The query result is as follows:

    +-----------+----------------+----------+---------+-------------------------+------------+
    | TENANT_ID | SVR_IP         | SVR_PORT | STAT_ID | STAT_NAME               | VALUE      |
    +-----------+----------------+----------+---------+-------------------------+------------+
    |      1002 | 172.xx.xxx.xxx |     2882 |  200001 | DB time                 |    6135115 |
    |      1002 | 172.xx.xxx.xxx |     2882 |  200002 | DB CPU                  |    5500079 |
    |      1002 | 172.xx.xxx.xxx |     2882 |  200005 | background elapsed time | 3398189713 |
    |      1002 | 172.xx.xxx.xxx |     2882 |  200006 | background cpu time     | 3088552955 |
    |      1002 | 172.xx.xxx.xxx |     2882 |  200010 | non idle wait time      |     635036 |
    |      1002 | 172.xx.xxx.xxx |     2882 |  200011 | idle wait time          |      80414 |
    +-----------+----------------+----------+---------+-------------------------+------------+
    6 rows in set
    

    The following table describes the fields.

    Field
    Description
    TENANT_ID The tenant ID.
    SVR_IP The IP address of the node.
    SVR_PORT The port number of the node.
    STAT_ID The ID of the statistic.
    STAT_NAME The name of the statistic.
    VALUE The value of the statistic.

    For more information about the GV$OB_SYS_TIME_MODEL view, see GV$OB_SYS_TIME_MODEL.

  • Query the tenant-level time model statistics on the current node by using the V$OB_SYS_TIME_MODEL view.

    obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_SYS_TIME_MODEL;
    

    The query result is as follows:

    +-----------+----------------+----------+---------+-------------------------+------------+
    | TENANT_ID | SVR_IP         | SVR_PORT | STAT_ID | STAT_NAME               | VALUE      |
    +-----------+----------------+----------+---------+-------------------------+------------+
    |      1002 | 172.xx.xxx.xxx |     2882 |  200001 | DB time                 |    6227784 |
    |      1002 | 172.xx.xxx.xxx |     2882 |  200002 | DB CPU                  |    5586418 |
    |      1002 | 172.xx.xxx.xxx |     2882 |  200005 | background elapsed time | 3399416601 |
    |      1002 | 172.xx.xxx.xxx |     2882 |  200006 | background cpu time     | 3089779843 |
    |      1002 | 172.xx.xxx.xxx |     2882 |  200010 | non idle wait time      |     641366 |
    |      1002 | 172.xx.xxx.xxx |     2882 |  200011 | idle wait time          |      80414 |
    +-----------+----------------+----------+---------+-------------------------+------------+
    6 rows in set
    

    The following table describes the fields.

    Field
    Description
    TENANT_ID The tenant ID.
    SVR_IP The IP address of the node.
    SVR_PORT The port number of the node.
    STAT_ID The ID of the statistic.
    STAT_NAME The name of the statistic.
    VALUE The value of the statistic.

    For more information about the V$OB_SYS_TIME_MODEL view, see V$OB_SYS_TIME_MODEL.

  • Query the time model statistics of all tenants by using the oceanbase.CDB_WR_SYS_TIME_MODEL view.

    obclient [oceanbase]> SELECT * FROM oceanbase.CDB_WR_SYS_TIME_MODEL LIMIT 10;
    

    The query result is as follows:

    +------------+-----------+---------+----------------+----------+---------+-------------------------+-----------+
    | CLUSTER_ID | TENANT_ID | SNAP_ID | SVR_IP         | SVR_PORT | STAT_ID | STAT_NAME               | VALUE     |
    +------------+-----------+---------+----------------+----------+---------+-------------------------+-----------+
    |      10001 |      1002 |       2 | 172.xx.xxx.xxx |     2882 |  200001 | DB time                 |     34505 |
    |      10001 |      1002 |       1 | 172.xx.xxx.xxx |     2882 |  200001 | DB time                 |     34505 |
    |      10001 |      1002 |       2 | 172.xx.xxx.xxx |     2882 |  200002 | DB CPU                  |      1966 |
    |      10001 |      1002 |       1 | 172.xx.xxx.xxx |     2882 |  200002 | DB CPU                  |      1966 |
    |      10001 |      1002 |       2 | 172.xx.xxx.xxx |     2882 |  200005 | background elapsed time | 233110335 |
    |      10001 |      1002 |       1 | 172.xx.xxx.xxx |     2882 |  200005 | background elapsed time | 116267272 |
    |      10001 |      1002 |       2 | 172.xx.xxx.xxx |     2882 |  200006 | background cpu time     | 209738761 |
    |      10001 |      1002 |       1 | 172.xx.xxx.xxx |     2882 |  200006 | background cpu time     | 104674501 |
    |      10001 |      1002 |       1 | 172.xx.xxx.xxx |     2882 |  200010 | non idle wait time      |     32539 |
    |      10001 |      1002 |       1 | 172.xx.xxx.xxx |     2882 |  200011 | idle wait time          |         0 |
    +------------+-----------+---------+----------------+----------+---------+-------------------------+-----------+
    10 rows in set
    

    The following table describes the fields.

    Field
    Description
    CLUSTER_ID Cluster ID
    TENANT_ID Tenant ID
    SNAP_ID Snapshot ID
    SVR_IP Node IP
    SVR_PORT Node port number
    STAT_ID Stat ID
    STAT_NAME Stat name
    VALUE Stat value

    For more information about the oceanbase.CDB_WR_SYSSTAT view, see oceanbase.CDB_WR_SYS_TIME_MODEL.

  • Use the oceanbase.DBA_WR_SYS_TIME_MODEL view to view WR data of time model statistics for the current tenant.

    obclient [oceanbase]> SELECT * FROM oceanbase.DBA_WR_SYS_TIME_MODEL LIMIT 10;
    

    The query result is as follows:

    +---------+----------------+----------+---------+-------------------------+-----------+
    | SNAP_ID | SVR_IP         | SVR_PORT | STAT_ID | STAT_NAME               | VALUE     |
    +---------+----------------+----------+---------+-------------------------+-----------+
    |       2 | 172.xx.xxx.xxx |     2882 |  200001 | DB time                 |     34505 |
    |       1 | 172.xx.xxx.xxx |     2882 |  200001 | DB time                 |     34505 |
    |       2 | 172.xx.xxx.xxx |     2882 |  200002 | DB CPU                  |      1966 |
    |       1 | 172.xx.xxx.xxx |     2882 |  200002 | DB CPU                  |      1966 |
    |       2 | 172.xx.xxx.xxx |     2882 |  200005 | background elapsed time | 233110335 |
    |       1 | 172.xx.xxx.xxx |     2882 |  200005 | background elapsed time | 116267272 |
    |       2 | 172.xx.xxx.xxx |     2882 |  200006 | background cpu time     | 209738761 |
    |       1 | 172.xx.xxx.xxx |     2882 |  200006 | background cpu time     | 104674501 |
    |       1 | 172.xx.xxx.xxx |     2882 |  200010 | non idle wait time      |     32539 |
    |       1 | 172.xx.xxx.xxx |     2882 |  200011 | idle wait time          |         0 |
    +---------+----------------+----------+---------+-------------------------+-----------+
    10 rows in set
    

    The following table describes the fields.

    Field
    Description
    SNAP_ID Snapshot ID
    SVR_IP Node IP
    SVR_PORT Node port number
    STAT_ID Stat ID
    STAT_NAME Stat name
    VALUE Stat value

    For more information about the DBA_WR_SYS_TIME_MODEL view, see oceanbase.DBA_WR_SYS_TIME_MODEL.

View SQLSTAT data

  • Query the GV$OB_SQLSTAT view for basic performance statistics of SQL statements in the cluster.

    Each SQL statement is represented by a row (i.e., each unique value of SQL_ID + Plan_Hash corresponds to one row). A row containing _DELTA indicates that the values are incremental from the last WR snapshot collection to the current time.

    obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_SQLSTAT LIMIT 1\G
    

    The query result is as follows:

    *************************** 1. row ***************************
                          SVR_IP: xx.xx.xx.xx
                        SVR_PORT: 2882
                        TENANT_ID: 1
                          SQL_ID: C37DC12BB691B517FEA330D030D920E2
                          PLAN_ID: 0
                        PLAN_HASH: 10981719669113383604
                        PLAN_TYPE: 0
                        QUERY_SQL:
                        SQL_TYPE: 0
                          MODULE: NULL
                          ACTION: NULL
                    PARSING_DB_ID: 0
                  PARSING_DB_NAME:
                  PARSING_USER_ID: 0
                EXECUTIONS_TOTAL: 1
                EXECUTIONS_DELTA: 0
                DISK_READS_TOTAL: 0
                DISK_READS_DELTA: 0
                BUFFER_GETS_TOTAL: 0
                BUFFER_GETS_DELTA: 0
              ELAPSED_TIME_TOTAL: 15885
              ELAPSED_TIME_DELTA: 0
                  CPU_TIME_TOTAL: 0
                  CPU_TIME_DELTA: 0
                    CCWAIT_TOTAL: 0
                    CCWAIT_DELTA: 0
                USERIO_WAIT_TOTAL: 0
                USERIO_WAIT_DELTA: 0
                    APWAIT_TOTAL: 0
                    APWAIT_DELTA: 0
    PHYSICAL_READ_REQUESTS_TOTAL: 0
    PHYSICAL_READ_REQUESTS_DELTA: 0
        PHYSICAL_READ_BYTES_TOTAL: 0
        PHYSICAL_READ_BYTES_DELTA: 0
            WRITE_THROTTLE_TOTAL: 0
            WRITE_THROTTLE_DELTA: 0
            ROWS_PROCESSED_TOTAL: 1
            ROWS_PROCESSED_DELTA: 0
        MEMSTORE_READ_ROWS_TOTAL: 0
        MEMSTORE_READ_ROWS_DELTA: 0
    MINOR_SSSTORE_READ_ROWS_TOTAL: 0
    MINOR_SSSTORE_READ_ROWS_DELTA: 0
    MAJOR_SSSTORE_READ_ROWS_TOTAL: 0
    MAJOR_SSSTORE_READ_ROWS_DELTA: 0
                        RPC_TOTAL: 0
                        RPC_DELTA: 0
                    FETCHES_TOTAL: 0
                    FETCHES_DELTA: 0
                      RETRY_TOTAL: 0
                      RETRY_DELTA: 0
                  PARTITION_TOTAL: 1
                  PARTITION_DELTA: 0
                NESTED_SQL_TOTAL: 0
                NESTED_SQL_DELTA: 0
                        SOURCE_IP: xx.xx.xx.xx
                      SOURCE_PORT: 2882
                ROUTE_MISS_TOTAL: 0
                ROUTE_MISS_DELTA: 0
                  FIRST_LOAD_TIME: 2026-03-16 22:00:29.029404
            PLAN_CACHE_HIT_TOTAL: 0
            PLAN_CACHE_HIT_DELTA: 0
                MUTI_QUERY_TOTAL: 0
                MUTI_QUERY_DELTA: 0
          MUTI_QUERY_BATCH_TOTAL: 0
          MUTI_QUERY_BATCH_DELTA: 0
            FULL_TABLE_SCAN_TOTAL: 1
            FULL_TABLE_SCAN_DELTA: 0
                ERROR_COUNT_TOTAL: 0
                ERROR_COUNT_DELTA: 0
              LATEST_ACTIVE_TIME: 1970-01-01 08:00:00.000000
    1 row in set (0.019 sec)
    

    The following table describes the fields.

    Field
    Description
    SVR_IP The IP address of the node.
    SVR_PORT The port number of the node.
    TENANT_ID The tenant ID.
    SQL_ID The ID of the SQL statement.
    PLAN_ID The ID of the execution plan.
    PLAN_HASH The hash value of the execution plan.
    PLAN_TYPE Indicates the type of the plan for an SQL plan:
    • 1: local plan.
    • 2: remote plan.
    • 3: distributed plan.

    For a PL object cache, this column indicates the type of the PL object:
    • 1: procedure.
    • 2: function.
    • 3: package.
    • 4: anonymous block.
    QUERY_SQL The full text of the SQL statement.
    SQL_TYPE The type of the statement.
    MODULE The application module when the statement was parsed for the first time. You can set this parameter by using the DBMS_APPLICATION_INFO.SET_MODULE package.
    ACTION The application action when the statement was parsed for the first time. You can set this parameter by using the DBMS_APPLICATION_INFO.SET_ACTION package.
    PARSING_DB_ID The database ID when the statement was parsed.
    PARSING_DB_NAME The name of the database when the statement was parsed.
    PARSING_USER_ID The user ID when the statement was parsed.
    EXECUTIONS_TOTAL The total number of executions of the plan in the plan cache.
    EXECUTIONS_DELTA The increment of the total number of executions of the plan in the plan cache.
    DISK_READS_TOTAL The total number of disk reads.
    DISK_READS_DELTA The increment of the number of disk reads.
    BUFFER_GETS_TOTAL The total number of logical reads from the cache.
    BUFFER_GETS_DELTA The increment of the number of logical reads from the cache.
    ELAPSED_TIME_TOTAL The total amount of time consumed by the statement. For parallel execution scenarios, this value is the cumulative value of each execution thread.
    ELAPSED_TIME_DELTA The increment of the time consumed by the statement.
    CPU_TIME_TOTAL The total CPU time consumed.
    CPU_TIME_DELTA The increment of the total CPU time consumed.
    CCWAIT_TOTAL The total time consumed by concurrency wait events.
    CCWAIT_DELTA The increment of the total time consumed by concurrency wait events.
    USERIO_WAIT_TOTAL The total time consumed by I/O waits.
    USERIO_WAIT_DELTA The increment of the total time consumed by I/O waits.
    APWAIT_TOTAL The total time consumed by application wait events.
    APWAIT_DELTA The increment of the total time consumed by application wait events.
    PHYSICAL_READ_REQUESTS_TOTAL The total number of physical read requests.
    PHYSICAL_READ_REQUESTS_DELTA The increment of the number of physical read requests.
    PHYSICAL_READ_BYTES_TOTAL The total number of bytes read during physical reads.
    PHYSICAL_READ_BYTES_DELTA The increment of the number of bytes read during physical reads.
    WRITE_THROTTLE_TOTAL Total time throttled during write to MemStore
    WRITE_THROTTLE_DELTA Incremental total time throttled during write to MemStore
    ROWS_PROCESSED_TOTAL Total number of rows processed by statements
    ROWS_PROCESSED_DELTA Incremental total number of rows processed by statements
    MEMSTORE_READ_ROWS_TOTAL Total number of rows read from MemStore
    MEMSTORE_READ_ROWS_DELTA Incremental total number of rows read from MemStore
    MINOR_SSSTORE_READ_ROWS_TOTAL Total number of rows read from MINOR SSStore
    MINOR_SSSTORE_READ_ROWS_DELTA Incremental total number of rows read from MINOR SSStore
    MAJOR_SSSTORE_READ_ROWS_TOTAL Total number of rows read from MAJOR SSStore
    MAJOR_SSSTORE_READ_ROWS_DELTA Incremental total number of rows read from MAJOR SSStore
    RPC_TOTAL Total number of RPCs
    RPC_DELTA Incremental number of RPCs
    FETCHES_TOTAL Total number of result set fetches
    FETCHES_DELTA Incremental number of result set fetches
    RETRY_TOTAL Total number of SQL retries
    RETRY_DELTA Incremental number of SQL retries
    PARTITION_TOTAL Total number of partitions scanned in SQL execution
    PARTITION_DELTA Incremental number of partitions scanned in SQL execution
    NESTED_SQL_TOTAL Total nested SQL executions. Increases by 1 for each additional executed sub-SQL
    NESTED_SQL_DELTA Incremental nested SQL executions
    SOURCE_IP Request source IP address
    SOURCE_PORT Request source port number
    ROUTE_MISS_TOTAL Total number of times the requested partition was not hit since OBServer startup
    ROUTE_MISS_DELTA Number of times the requested partition was not hit since the last WR snapshot collection
    FIRST_LOAD_TIME Plan generation time
    PLAN_CACHE_hit_TOTAL Total number of times the Plan Cache was hit since OBServer startup
    PLAN_CACHE_HIT_DELTA Number of times the Plan Cache was hit since the last WR snapshot collection
    MUTI_QUERY_TOTAL Number of times this SQL has been located in a multi-query since the plan was generated
    MUTI_QUERY_DELTA Number of times this SQL has been located in a multi-query since the last WR snapshot collection
    MUTI_QUERY_BATCH_TOTAL Number of times this SQL batch has been executed since the plan was generated
    MUTI_QUERY_BATCH_DELTA Number of times this SQL batch has been executed since the last WR snapshot collection
    FULL_TABLE_SCAN_TOTAL Number of full table scans performed by this SQL since the plan was generated
    FULL_TABLE_SCAN_DELTA Number of full table scans performed by this SQL since the last WR snapshot collection
    ERROR_COUNT_TOTAL Number of errors reported by this SQL since the plan was generated
    ERROR_COUNT_DELTA Number of errors reported by this SQL since the last WR snapshot collection
    LATEST_ACTIVE_TIME TIMESTAMP(6). The last active time of the plan corresponding to the SQL ID + Plan Hash on a node.

    For more information about the GV$OB_SQLSTAT view, see GV$OB_SQLSTAT.

  • Query the V$OB_SQLSTAT view for basic performance statistics of SQL statements on the current node.

    Each SQL statement is represented as one row (that is, each unique value of SQL_ID + Plan_Hash corresponds to one row). A row containing _DELTA indicates the incremental statistics from the last WR snapshot collection to the current time.

    obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_SQLSTAT LIMIT 1\G
    

    The query result is as follows:

    *************************** 1. row ***************************
                          SVR_IP: xx.xx.xx.xx
                        SVR_PORT: 2882
                        TENANT_ID: 1
                          SQL_ID: C37DC12BB691B517FEA330D030D920E2
                          PLAN_ID: 0
                        PLAN_HASH: 10981719669113383604
                        PLAN_TYPE: 0
                        QUERY_SQL:
                        SQL_TYPE: 0
                          MODULE: NULL
                          ACTION: NULL
                    PARSING_DB_ID: 0
                  PARSING_DB_NAME:
                  PARSING_USER_ID: 0
                EXECUTIONS_TOTAL: 1
                EXECUTIONS_DELTA: 0
                DISK_READS_TOTAL: 0
                DISK_READS_DELTA: 0
                BUFFER_GETS_TOTAL: 0
                BUFFER_GETS_DELTA: 0
              ELAPSED_TIME_TOTAL: 15885
              ELAPSED_TIME_DELTA: 0
                  CPU_TIME_TOTAL: 0
                  CPU_TIME_DELTA: 0
                    CCWAIT_TOTAL: 0
                    CCWAIT_DELTA: 0
                USERIO_WAIT_TOTAL: 0
                USERIO_WAIT_DELTA: 0
                    APWAIT_TOTAL: 0
                    APWAIT_DELTA: 0
    PHYSICAL_READ_REQUESTS_TOTAL: 0
    PHYSICAL_READ_REQUESTS_DELTA: 0
        PHYSICAL_READ_BYTES_TOTAL: 0
        PHYSICAL_READ_BYTES_DELTA: 0
            WRITE_THROTTLE_TOTAL: 0
            WRITE_THROTTLE_DELTA: 0
            ROWS_PROCESSED_TOTAL: 1
            ROWS_PROCESSED_DELTA: 0
        MEMSTORE_READ_ROWS_TOTAL: 0
        MEMSTORE_READ_ROWS_DELTA: 0
    MINOR_SSSTORE_READ_ROWS_TOTAL: 0
    MINOR_SSSTORE_READ_ROWS_DELTA: 0
    MAJOR_SSSTORE_READ_ROWS_TOTAL: 0
    MAJOR_SSSTORE_READ_ROWS_DELTA: 0
                        RPC_TOTAL: 0
                        RPC_DELTA: 0
                    FETCHES_TOTAL: 0
                    FETCHES_DELTA: 0
                      RETRY_TOTAL: 0
                      RETRY_DELTA: 0
                  PARTITION_TOTAL: 1
                  PARTITION_DELTA: 0
                NESTED_SQL_TOTAL: 0
                NESTED_SQL_DELTA: 0
                        SOURCE_IP: xx.xx.xx.xx
                      SOURCE_PORT: 2882
                ROUTE_MISS_TOTAL: 0
                ROUTE_MISS_DELTA: 0
                  FIRST_LOAD_TIME: 2026-03-16 22:00:29.029404
            PLAN_CACHE_HIT_TOTAL: 0
            PLAN_CACHE_HIT_DELTA: 0
                MUTI_QUERY_TOTAL: 0
                MUTI_QUERY_DELTA: 0
          MUTI_QUERY_BATCH_TOTAL: 0
          MUTI_QUERY_BATCH_DELTA: 0
            FULL_TABLE_SCAN_TOTAL: 1
            FULL_TABLE_SCAN_DELTA: 0
                ERROR_COUNT_TOTAL: 0
                ERROR_COUNT_DELTA: 0
              LATEST_ACTIVE_TIME: 1970-01-01 08:00:00.000000
    1 row in set (0.014 sec)
    

    The following table describes the fields.

    Field
    Description
    SVR_IP The IP address of the node.
    SVR_PORT The port number of the node.
    TENANT_ID The tenant ID.
    SQL_ID The ID of the SQL statement.
    PLAN_ID The ID of the execution plan.
    PLAN_HASH The hash value of the execution plan.
    PLAN_TYPE For an SQL plan cache entry, this column specifies the plan type:
    • 1: a local plan.
    • 2: a remote plan.
    • 3: a distributed plan.

    For a PL object cache entry, this column specifies the PL object type:
    • 1: a procedure.
    • 2: a function.
    • 3: a package.
    • 4: an anonymous block.
    QUERY_SQL The full text of the SQL statement.
    SQL_TYPE The statement type.
    MODULE The application module when the statement was parsed for the first time. This parameter is set by using the DBMS_APPLICATION_INFO.SET_MODULE package.
    ACTION The application action when the statement was parsed for the first time. This parameter is set by using the DBMS_APPLICATION_INFO.SET_ACTION package.
    PARSING_DB_ID The database ID when the statement was parsed.
    PARSING_DB_NAME The name of the database when the statement was parsed.
    PARSING_USER_ID The user ID when the statement was parsed.
    EXECUTIONS_TOTAL The total number of executions of the plan in the plan cache.
    EXECUTIONS_DELTA The increment of the total number of executions of the plan in the plan cache.
    DISK_READS_TOTAL The total number of disk reads.
    DISK_READS_DELTA The increment of the number of disk reads.
    BUFFER_GETS_TOTAL The total number of logical reads from the cache.
    BUFFER_GETS_DELTA The increment of the number of logical reads from the cache.
    ELAPSED_TIME_TOTAL The total amount of time consumed by the statement. In a parallel execution scenario, this value is the cumulative value of each execution thread.
    ELAPSED_TIME_DELTA The increment of the time consumed by the statement.
    CPU_TIME_TOTAL The total CPU time consumed.
    CPU_TIME_DELTA The increment of the total CPU time consumed.
    CCWAIT_TOTAL The total time consumed by concurrency-waiting events.
    CCWAIT_DELTA The increment of the total time consumed by concurrency-waiting events.
    USERIO_WAIT_TOTAL The total time consumed by I/O-waiting events.
    USERIO_WAIT_DELTA The increment of the total time consumed by I/O-waiting events.
    APWAIT_TOTAL The total time consumed by application-waiting events.
    APWAIT_DELTA The increment of the total time consumed by application-waiting events.
    PHYSICAL_READ_REQUESTS_TOTAL The total number of physical read requests.
    PHYSICAL_READ_REQUESTS_DELTA The increment of the number of physical read requests.
    PHYSICAL_READ_BYTES_TOTAL The total number of bytes read during physical reads.
    PHYSICAL_READ_BYTES_DELTA The increment of the number of bytes read during physical reads.
    WRITE_THROTTLE_TOTAL The total time throttled when writing to MemStore.
    WRITE_THROTTLE_DELTA The increment of the total time throttled when writing to MemStore.
    ROWS_PROCESSED_TOTAL The total number of rows processed by the statement.
    ROWS_PROCESSED_DELTA The increment of the total number of rows processed by the statement.
    MEMSTORE_READ_ROWS_TOTAL Total rows read from the MemStore
    MEMSTORE_READ_ROWS_DELTA Incremental total rows read from the MemStore
    MINOR_SSSTORE_READ_ROWS_TOTAL Total rows read from the MINOR SSStore
    MINOR_SSSTORE_READ_ROWS_DELTA Incremental total rows read from the MINOR SSStore
    MAJOR_SSSTORE_READ_ROWS_TOTAL Total rows read from the MAJOR SSStore
    MAJOR_SSSTORE_READ_ROWS_DELTA Incremental total rows read from the MAJOR SSStore
    RPC_TOTAL Total number of RPCs
    RPC_DELTA Incremental number of RPCs
    FETCHES_TOTAL Total number of result set fetches
    FETCHES_DELTA Incremental number of result set fetches
    RETRY_TOTAL Total number of SQL retries
    RETRY_DELTA Incremental number of SQL retries
    PARTITION_TOTAL Total number of partitions scanned in SQL execution
    PARTITION_DELTA Incremental number of partitions scanned in SQL execution
    NESTED_SQL_TOTAL Total number of nested SQL executions. Increases by 1 for each additional executed sub-SQL
    NESTED_SQL_DELTA Incremental number of nested SQL executions
    SOURCE_IP Request source IP
    SOURCE_PORT Request source port number
    ROUTE_MISS_TOTAL Total number of times the requested partition was not hit since OBServer startup
    ROUTE_MISS_DELTA Number of times the requested partition was not hit since the last WR snapshot collection
    FIRST_LOAD_TIME Plan generation time
    PLAN_CACHE_hit_TOTAL Total number of times the Plan Cache was hit since OBServer startup
    PLAN_CACHE_HIT_DELTA Number of times the Plan Cache was hit since the last WR snapshot collection
    MUTI_QUERY_TOTAL Number of times this SQL has been located in a multi-query since the plan was generated
    MUTI_QUERY_DELTA Number of times this SQL has been located in a multi-query since the last WR snapshot collection
    MUTI_QUERY_BATCH_TOTAL Number of times this SQL batch has been executed since the plan was generated
    MUTI_QUERY_BATCH_DELTA Number of times this SQL batch has been executed since the last WR snapshot collection
    FULL_TABLE_SCAN_TOTAL Number of full-table scans performed by this SQL since the plan was generated
    FULL_TABLE_SCAN_DELTA Number of full-table scans performed by this SQL since the last WR snapshot collection
    ERROR_COUNT_TOTAL Number of errors reported by this SQL since the plan was generated
    ERROR_COUNT_DELTA Number of errors reported by this SQL since the last WR snapshot collection
    LATEST_ACTIVE_TIME TIMESTAMP(6). The last active time of the plan corresponding to the SQL ID + Plan Hash on a node.

    For more information about the V$OB_SQLSTAT view, see V$OB_SQLSTAT.

  • Query the oceanbase.CDB_WR_SQLSTAT view for basic performance statistics of all SQL statements executed by all tenants.

    Each SQL statement is represented as one row (i.e., each unique value of SQL_ID + Plan_Hash corresponds to one row). A row containing _DELTA indicates the incremental statistics from the last WR snapshot collection to the current time.

    obclient [oceanbase]> SELECT * FROM oceanbase.CDB_WR_SQLSTAT LIMIT 1\G
    

    The query result is as follows:

    *************************** 1. row ***************************
                        TENANT_ID: 1
                          SNAP_ID: 1
                          SVR_IP: xx.xx.xx.xx
                        SVR_PORT: 2882
                          SQL_ID: 02AAEF3D6A4A939843FE958984B6EA51
                        PLAN_HASH: 8470076267874576774
                        PLAN_TYPE: 1
                          MODULE: NULL
                          ACTION: NULL
                    PARSING_DB_ID: 201001
                  PARSING_DB_NAME: oceanbase
                  PARSING_USER_ID: 200001
                EXECUTIONS_TOTAL: 345
                EXECUTIONS_DELTA: 345
                DISK_READS_TOTAL: 0
                DISK_READS_DELTA: 0
                BUFFER_GETS_TOTAL: 0
                BUFFER_GETS_DELTA: 0
              ELAPSED_TIME_TOTAL: 36311
              ELAPSED_TIME_DELTA: 36311
                  CPU_TIME_TOTAL: 0
                  CPU_TIME_DELTA: 0
                    CCWAIT_TOTAL: 0
                    CCWAIT_DELTA: 0
                USERIO_WAIT_TOTAL: 0
                USERIO_WAIT_DELTA: 0
                    APWAIT_TOTAL: 0
                    APWAIT_DELTA: 0
    PHYSICAL_READ_REQUESTS_TOTAL: 0
    PHYSICAL_READ_REQUESTS_DELTA: 0
        PHYSICAL_READ_BYTES_TOTAL: 0
        PHYSICAL_READ_BYTES_DELTA: 0
            WRITE_THROTTLE_TOTAL: 0
            WRITE_THROTTLE_DELTA: 0
            ROWS_PROCESSED_TOTAL: 344
            ROWS_PROCESSED_DELTA: 344
        MEMSTORE_READ_ROWS_TOTAL: 0
        MEMSTORE_READ_ROWS_DELTA: 0
    MINOR_SSSTORE_READ_ROWS_TOTAL: 0
    MINOR_SSSTORE_READ_ROWS_DELTA: 0
    MAJOR_SSSTORE_READ_ROWS_TOTAL: 0
    MAJOR_SSSTORE_READ_ROWS_DELTA: 0
                        RPC_TOTAL: 0
                        RPC_DELTA: 0
                    FETCHES_TOTAL: 0
                    FETCHES_DELTA: 0
                      RETRY_TOTAL: 0
                      RETRY_DELTA: 0
                  PARTITION_TOTAL: 345
                  PARTITION_DELTA: 345
                NESTED_SQL_TOTAL: 0
                NESTED_SQL_DELTA: 0
                        SOURCE_IP: xx.xx.xx.xx
                      SOURCE_PORT: 2882
                ROUTE_MISS_TOTAL: 0
                ROUTE_MISS_DELTA: 0
                  FIRST_LOAD_TIME: 2026-03-16 16:30:26.782836
            PLAN_CACHE_HIT_TOTAL: 343
            PLAN_CACHE_HIT_DELTA: 343
                MUTI_QUERY_TOTAL: 0
                MUTI_QUERY_DELTA: 0
          MUTI_QUERY_BATCH_TOTAL: 0
          MUTI_QUERY_BATCH_DELTA: 0
            FULL_TABLE_SCAN_TOTAL: 0
            FULL_TABLE_SCAN_DELTA: 0
                ERROR_COUNT_TOTAL: 0
                ERROR_COUNT_DELTA: 0
                      SAMPLE_TIME: 2026-03-16 16:40:15.000000
              LATEST_ACTIVE_TIME: 2026-03-16 16:40:15.526231
    1 row in set (0.026 sec)
    

    The following table describes the fields.

    Field
    Description
    TENANT_ID The tenant ID.
    SNAP_ID The snapshot ID.
    SVR_IP The IP address of the node.
    SVR_PORT The port number of the node.
    SQL_ID The ID of the SQL statement.
    PLAN_HASH The hash value of the execution plan.
    PLAN_ID The ID of the execution plan.
    PLAN_TYPE For cached SQL plans, this column indicates the plan type:
    • 1: a local plan.
    • 2: a remote plan.
    • 3: a distributed plan.

    For cached PL objects, this column indicates the PL object type:
    • 1: a procedure.
    • 2: a function.
    • 3: a package.
    • 4: an anonymous block.
    MODULE The application module when the statement was first parsed. This can be set using the DBMS_APPLICATION_INFO.SET_MODULE package.
    ACTION The application action when the statement was first parsed. This can be set using the DBMS_APPLICATION_INFO.SET_ACTION package.
    PARSING_DB_ID The database ID during statement parsing.
    PARSING_DB_NAME The database name during statement parsing.
    PARSING_USER_ID The user ID during statement parsing.
    EXECUTIONS_TOTAL The total number of executions for this plan in the plan cache.
    EXECUTIONS_DELTA The increment in the total number of executions for this plan in the plan cache.
    DISK_READS_TOTAL The total number of disk reads.
    DISK_READS_DELTA The increment in the number of disk reads.
    BUFFER_GETS_TOTAL The total number of logical reads from the cache.
    BUFFER_GETS_DELTA The increment in the number of logical reads from the cache.
    ELAPSED_TIME_TOTAL The total time consumed by the statement. For parallel execution scenarios, this value is the cumulative time for each execution thread.
    ELAPSED_TIME_DELTA The increment in the time consumed by the statement.
    CPU_TIME_TOTAL The total CPU time consumed.
    CPU_TIME_DELTA The increment in the total CPU time consumed.
    CCWAIT_TOTAL The total time spent on concurrency-waiting events.
    CCWAIT_DELTA The increment in the total time spent on concurrency-waiting events.
    USERIO_WAIT_TOTAL The total time spent on I/O waits.
    USERIO_WAIT_DELTA The increment in the total time spent on I/O waits.
    APWAIT_TOTAL The total time spent on application-waiting events.
    APWAIT_DELTA The increment in the total time spent on application-waiting events.
    PHYSICAL_READ_REQUESTS_TOTAL The total number of physical read requests.
    PHYSICAL_READ_REQUESTS_DELTA The increment in the number of physical read requests.
    PHYSICAL_READ_BYTES_TOTAL The total number of bytes read physically.
    PHYSICAL_READ_BYTES_DELTA The increment in the number of bytes read physically.
    WRITE_THROTTLE_TOTAL The total time throttled when writing to MemStore.
    WRITE_THROTTLE_DELTA The increment in the total time throttled when writing to MemStore.
    ROWS_PROCESSED_TOTAL The total number of rows processed by the statement.
    ROWS_PROCESSED_DELTA The increment in the total number of rows processed by the statement.
    MEMSTORE_READ_ROWS_TOTAL The total number of rows read from MemStore.
    MEMSTORE_READ_ROWS_DELTA Increment of the total number of rows read from the MemStore
    MINOR_SSSTORE_READ_ROWS_TOTAL Total number of rows read from the MINOR SSStore
    MINOR_SSSTORE_READ_ROWS_DELTA Increment of the total number of rows read from the MINOR SSStore
    MAJOR_SSSTORE_READ_ROWS_TOTAL Total number of rows read from the MAJOR SSStore
    MAJOR_SSSTORE_READ_ROWS_DELTA Increment of the total number of rows read from the MAJOR SSStore
    RPC_TOTAL Total number of RPCs
    RPC_DELTA Increment of the number of RPCs
    FETCHES_TOTAL Total number of result set fetches
    FETCHES_DELTA Increment of the number of result set fetches
    RETRY_TOTAL Total number of SQL retries
    RETRY_DELTA Increment of the number of SQL retries
    PARTITION_TOTAL Total number of partitions scanned in SQL execution
    PARTITION_DELTA Increment of the number of partitions scanned in SQL execution
    NESTED_SQL_TOTAL Total number of nested SQL executions. Increases by 1 for each additional executed sub-SQL
    NESTED_SQL_DELTA Increment of nested SQL executions
    SOURCE_IP Source IP address of the request
    SOURCE_PORT Port number of the request source
    ROUTE_MISS_TOTAL Total number of times the requested partition was not hit since the OBServer started
    ROUTE_MISS_DELTA Number of times the requested partition was not hit since the last WR snapshot collection
    FIRST_LOAD_TIME Planned generation time
    PLAN_CACHE_hit_TOTAL Total number of times that the plan cache was hit since the OBServer started
    PLAN_CACHE_HIT_DELTA Number of times that the plan cache was hit since the last WR snapshot collection
    MUTI_QUERY_TOTAL Number of times this SQL has been located in a multi-query since the plan was generated
    MUTI_QUERY_DELTA Number of times this SQL has been located in a multi-query since the last WR snapshot collection
    MUTI_QUERY_BATCH_TOTAL Number of times this SQL batch has been executed since the plan was generated
    MUTI_QUERY_BATCH_DELTA Number of times this SQL batch has been executed since the last WR snapshot collection
    FULL_TABLE_SCAN_TOTAL Number of full-table scans performed by this SQL since the plan was generated
    FULL_TABLE_SCAN_DELTA Number of full-table scans performed by this SQL since the last WR snapshot collection
    ERROR_COUNT_TOTAL Number of errors reported by this SQL since the plan was generated
    ERROR_COUNT_DELTA Number of errors reported by this SQL since the last WR snapshot collection
    SAMPLE_TIME Time when the SQLSTAT snapshot was persisted to disk. The SQLSTAT data may be persisted multiple times within an interval between two WR snapshots.
    LATEST_ACTIVE_TIME Last active time of the plan corresponding to the SQL ID + Plan Hash on a specific node

    For more information about the oceanbase.CDB_WR_SQLSTAT view, see oceanbase.CDB_WR_SQLSTAT.

  • Use the oceanbase.DBA_WR_SQLSTAT view to view basic performance statistics of SQL statements executed in the current tenant.

    In the table, columns with _DELTA indicate the increment of statistical values from the time of the last WR snapshot collection to the current time.

    obclient [SYS]> SELECT * FROM SYS.DBA_WR_SQLSTAT WHERE ROWNUM = 1\G
    

    The query result is as follows:

    *************************** 1. row ***************************
                          SNAP_ID: 1
                          SVR_IP: xx.xx.xx.xx
                        SVR_PORT: 2882
                          SQL_ID: 01058E374A5EF26873BA4D99C4A74582
                        PLAN_HASH: 5547575357486659143
                        PLAN_TYPE: 0
                          MODULE: NULL
                          ACTION: NULL
                    PARSING_DB_ID: 0
                  PARSING_DB_NAME: NULL
                  PARSING_USER_ID: 0
                EXECUTIONS_TOTAL: 1
                EXECUTIONS_DELTA: 1
                DISK_READS_TOTAL: 0
                DISK_READS_DELTA: 0
                BUFFER_GETS_TOTAL: 0
                BUFFER_GETS_DELTA: 0
              ELAPSED_TIME_TOTAL: 1613
              ELAPSED_TIME_DELTA: 1613
                  CPU_TIME_TOTAL: 0
                  CPU_TIME_DELTA: 0
                    CCWAIT_TOTAL: 0
                    CCWAIT_DELTA: 0
                USERIO_WAIT_TOTAL: 0
                USERIO_WAIT_DELTA: 0
                    APWAIT_TOTAL: 0
                    APWAIT_DELTA: 0
    PHYSICAL_READ_REQUESTS_TOTAL: 0
    PHYSICAL_READ_REQUESTS_DELTA: 0
        PHYSICAL_READ_BYTES_TOTAL: 0
        PHYSICAL_READ_BYTES_DELTA: 0
            WRITE_THROTTLE_TOTAL: 0
            WRITE_THROTTLE_DELTA: 0
            ROWS_PROCESSED_TOTAL: 0
            ROWS_PROCESSED_DELTA: 0
        MEMSTORE_READ_ROWS_TOTAL: 0
        MEMSTORE_READ_ROWS_DELTA: 0
    MINOR_SSSTORE_READ_ROWS_TOTAL: 0
    MINOR_SSSTORE_READ_ROWS_DELTA: 0
    MAJOR_SSSTORE_READ_ROWS_TOTAL: 0
    MAJOR_SSSTORE_READ_ROWS_DELTA: 0
                        RPC_TOTAL: 0
                        RPC_DELTA: 0
                    FETCHES_TOTAL: 0
                    FETCHES_DELTA: 0
                      RETRY_TOTAL: 0
                      RETRY_DELTA: 0
                  PARTITION_TOTAL: 1
                  PARTITION_DELTA: 1
                NESTED_SQL_TOTAL: 0
                NESTED_SQL_DELTA: 0
                        SOURCE_IP: xx.xx.xx.xx
                      SOURCE_PORT: 2882
                ROUTE_MISS_TOTAL: 0
                ROUTE_MISS_DELTA: 0
                  FIRST_LOAD_TIME: 16-MAR-26 04.40.15.465600 PM
            PLAN_CACHE_HIT_TOTAL: 0
            PLAN_CACHE_HIT_DELTA: 0
                MUTI_QUERY_TOTAL: 0
                MUTI_QUERY_DELTA: 0
          MUTI_QUERY_BATCH_TOTAL: 0
          MUTI_QUERY_BATCH_DELTA: 0
            FULL_TABLE_SCAN_TOTAL: 0
            FULL_TABLE_SCAN_DELTA: 0
                ERROR_COUNT_TOTAL: 0
                ERROR_COUNT_DELTA: 0
                      SAMPLE_TIME: 16-MAR-26 04.40.15.000000 PM
              LATEST_ACTIVE_TIME: 16-MAR-26 04.40.15.500910 PM
    1 row in set (0.041 sec)
    

    The following table describes the fields.

    Field
    Description
    SNAP_ID The snapshot ID.
    SVR_IP The IP address of the node.
    SVR_PORT The port number of the node.
    SQL_ID The ID of the SQL statement.
    PLAN_HASH The hash value of the execution plan.
    PLAN_ID The ID of the execution plan.
    PLAN_TYPE For cached SQL plans, this column indicates the plan type:
    • 1: a local plan.
    • 2: a remote plan.
    • 3: a distributed plan.

    For cached PL objects, this column indicates the PL object type:
    • 1: a procedure.
    • 2: a function.
    • 3: a package.
    • 4: an anonymous block.
    MODULE The application module when the statement was first parsed. Set by using the DBMS_APPLICATION_INFO.SET_MODULE package.
    ACTION The application action when the statement was first parsed. Set by using the DBMS_APPLICATION_INFO.SET_ACTION package.
    PARSING_DB_ID The database ID when the statement was parsed.
    PARSING_DB_NAME The name of the database when the statement was parsed.
    PARSING_USER_ID The user ID when the statement was parsed.
    EXECUTIONS_TOTAL The total number of executions of the plan in the plan cache.
    EXECUTIONS_DELTA The increment of the total number of executions of the plan in the plan cache.
    DISK_READS_TOTAL The total number of disk reads.
    DISK_READS_DELTA The increment of the number of disk reads.
    BUFFER_GETS_TOTAL The total number of logical reads from the cache.
    BUFFER_GETS_DELTA The increment of the number of logical reads from the cache.
    ELAPSED_TIME_TOTAL The total time consumed by the statement. For parallel execution scenarios, this value is the cumulative value of each execution thread.
    ELAPSED_TIME_DELTA The increment of the time consumed by the statement.
    CPU_TIME_TOTAL The total CPU time consumed.
    CPU_TIME_DELTA The increment of the total CPU time consumed.
    CCWAIT_TOTAL The total time consumed by concurrency wait events.
    CCWAIT_DELTA The increment of the total time consumed by concurrency wait events.
    USERIO_WAIT_TOTAL The total time consumed by I/O waits.
    USERIO_WAIT_DELTA The increment of the total time consumed by I/O waits.
    APWAIT_TOTAL The total time consumed by application wait events.
    APWAIT_DELTA The increment of the total time consumed by application wait events.
    PHYSICAL_READ_REQUESTS_TOTAL The total number of physical read requests.
    PHYSICAL_READ_REQUESTS_DELTA The increment of the number of physical read requests.
    PHYSICAL_READ_BYTES_TOTAL The total number of bytes read during physical reads.
    PHYSICAL_READ_BYTES_DELTA The increment of the number of bytes read during physical reads.
    WRITE_THROTTLE_TOTAL The total time throttled when writing to MemStore.
    WRITE_THROTTLE_DELTA The increment of the total time throttled when writing to MemStore.
    ROWS_PROCESSED_TOTAL The total number of rows processed by the statement.
    ROWS_PROCESSED_DELTA The increment of the total number of rows processed by the statement.
    MEMSTORE_READ_ROWS_TOTAL The total number of rows read from MemStore.
    MEMSTORE_READ_ROWS_DELTA The increment of the total number of rows read from MemStore.
    MINOR_SSSTORE_READ_ROWS_TOTAL The total number of rows read from the minor SSStore.
    MINOR_SSSTORE_READ_ROWS_DELTA The increment of the total number of rows read from the minor SSStore.
    MAJOR_SSSTORE_READ_ROWS_TOTAL Total rows read from the major SSStore
    MAJOR_SSSTORE_READ_ROWS_DELTA Incremental total rows read from the major SSStore
    RPC_TOTAL Total number of RPCs
    RPC_DELTA Incremental number of RPCs
    FETCHES_TOTAL Total number of result set fetches
    FETCHES_DELTA Incremental number of result set fetches
    RETRY_TOTAL Total number of SQL retries
    RETRY_DELTA Incremental number of SQL retries
    PARTITION_TOTAL Total number of partitions scanned in SQL execution
    PARTITION_DELTA Incremental number of partitions scanned in SQL execution
    NESTED_SQL_TOTAL Total number of nested SQL executions. Increases by 1 for each additional executed sub-SQL
    NESTED_SQL_DELTA Incremental number of nested SQL executions
    SOURCE_IP VARCHAR2(46)
    SOURCE_PORT Port number of the request source
    ROUTE_MISS_TOTAL Total number of times the requested partition was not hit since OBServer started
    ROUTE_MISS_DELTA Number of times the requested partition was not hit since the last WR snapshot collection
    FIRST_LOAD_TIME Planned generation time
    PLAN_CACHE_HIT_TOTAL Total number of times that a plan cache hit occurred since OBServer started
    PLAN_CACHE_HIT_DELTA Number of times that a plan cache hit occurred since the last WR snapshot collection
    MUTI_QUERY_TOTAL Number of times this SQL has been located in a multi-query since the plan was generated
    MUTI_QUERY_DELTA Number of times this SQL has been located in a multi-query since the last WR snapshot collection
    MUTI_QUERY_BATCH_TOTAL Number of times this SQL batch has been executed since the plan was generated
    MUTI_QUERY_BATCH_DELTA Number of times this SQL batch has been executed since the last WR snapshot collection
    FULL_TABLE_SCAN_TOTAL Number of full table scans performed by this SQL since the plan was generated
    FULL_TABLE_SCAN_DELTA Number of full table scans performed by this SQL since the last WR snapshot collection
    ERROR_COUNT_TOTAL Number of errors reported by this SQL since the plan was generated
    ERROR_COUNT_DELTA Number of errors reported by this SQL since the last WR snapshot collection
    SAMPLE_TIME Time when the SQLSTAT snapshot was persisted to disk. An SQLSTAT snapshot may be persisted multiple times within an interval between two WR snapshots.
    LATEST_ACTIVE_TIME Last active time of the plan corresponding to the SQL ID + Plan Hash on a node

    For more information about the DBA_WR_SQLSTAT view, see oceanbase.DBA_WR_SQLSTAT.

View OBServer resource group information

  • Query the GV$OB_RES_MGR_SYSSTAT view for statistics of all resource groups on all OBServer nodes.

    obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_RES_MGR_SYSSTAT LIMIT 10;
    

    The query result is as follows:

    +--------+----------+----------------+----------+------------+-----------------------+-------+------------+------------+---------+
    | CON_ID | GROUP_ID | SVR_IP         | SVR_PORT | STATISTIC# | NAME                  | CLASS | VALUE      | VALUE_TYPE | STAT_ID |
    +--------+----------+----------------+----------+------------+-----------------------+-------+------------+------------+---------+
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          0 | rpc packet in         |     1 |   12995014 | ADD_VALUE  |   10000 |
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          1 | rpc packet in bytes   |     1 | 3080600714 | ADD_VALUE  |   10001 |
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          2 | rpc packet out        |     1 |    7975192 | ADD_VALUE  |   10002 |
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          3 | rpc packet out bytes  |     1 | 2401633337 | ADD_VALUE  |   10003 |
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          4 | rpc deliver fail      |     1 |          0 | ADD_VALUE  |   10004 |
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          5 | rpc net delay         |     1 |   23735015 | ADD_VALUE  |   10005 |
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          6 | rpc net frame delay   |     1 |     240711 | ADD_VALUE  |   10006 |
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          7 | mysql packet in       |     1 |         66 | ADD_VALUE  |   10007 |
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          8 | mysql packet in bytes |     1 |      13725 | ADD_VALUE  |   10008 |
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          9 | mysql packet out      |     1 |         86 | ADD_VALUE  |   10009 |
    +--------+----------+----------------+----------+------------+-----------------------+-------+------------+------------+---------+
    10 rows in set (0.026 sec)
    

    The following table describes the fields.

    Field
    Description
    CON_ID Tenant ID
    GROUP_ID Consumer Group ID
    SVR_IP Node IP
    SVR_PORT Node PORT
    STATISTIC# Statistics number
    NAME Statistics name
    CLASS Statistics category
    VALUE Statistics value
    VALUE_TYPE Value type: cumulative or assignment type
    STAT_ID Statistics ID

    For more information about the GV$OB_RES_MGR_SYSSTAT view, see GV$OB_RES_MGR_SYSSTAT.

  • Query the V$OB_RES_MGR_SYSSTAT view for statistics of the current resource group on the current OBServer node.

    obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_RES_MGR_SYSSTAT LIMIT 10;
    

    The query result is as follows:

    +--------+----------+----------------+----------+------------+-----------------------+-------+------------+------------+---------+
    | CON_ID | GROUP_ID | SVR_IP         | SVR_PORT | STATISTIC# | NAME                  | CLASS | VALUE      | VALUE_TYPE | STAT_ID |
    +--------+----------+----------------+----------+------------+-----------------------+-------+------------+------------+---------+
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          0 | rpc packet in         |     1 |   13010269 | ADD_VALUE  |   10000 |
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          1 | rpc packet in bytes   |     1 | 3084188226 | ADD_VALUE  |   10001 |
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          2 | rpc packet out        |     1 |    7984551 | ADD_VALUE  |   10002 |
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          3 | rpc packet out bytes  |     1 | 2404425894 | ADD_VALUE  |   10003 |
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          4 | rpc deliver fail      |     1 |          0 | ADD_VALUE  |   10004 |
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          5 | rpc net delay         |     1 |   23766006 | ADD_VALUE  |   10005 |
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          6 | rpc net frame delay   |     1 |     241049 | ADD_VALUE  |   10006 |
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          7 | mysql packet in       |     1 |         69 | ADD_VALUE  |   10007 |
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          8 | mysql packet in bytes |     1 |      13871 | ADD_VALUE  |   10008 |
    |      1 |        0 |  xx.xx.xx.xx   |     2882 |          9 | mysql packet out      |     1 |        142 | ADD_VALUE  |   10009 |
    +--------+----------+----------------+----------+------------+-----------------------+-------+------------+------------+---------+
    10 rows in set (0.007 sec)
    

    The following table describes the fields.

    Field
    Description
    CON_ID Tenant ID
    GROUP_ID Consumer Group ID
    SVR_IP Node IP
    SVR_PORT Node PORT
    STATISTIC# Statistics number
    NAME Statistics name
    CLASS Statistics category
    VALUE Statistics value
    VALUE_TYPE Value type: cumulative or assignment type
    STAT_ID Statistics ID

    For more information about the V$OB_RES_MGR_SYSSTAT view, see V$OB_RES_MGR_SYSSTAT.

References

  • Overview of WR
  • Manage WR
  • Clean up WR data

Previous topic

Manage WR
Last

Next topic

Clean up WR data
Next
on this page
View historical session data
View historical session statistics
View time model statistics
View SQLSTAT data
View OBServer resource group information
References