Description of common statistical events|V4.3.5| docs|Distributed Database

Description of common statistical events

Last Updated：2026-02-05 05:53:38 Updated

Overview

This section describes some statistical event information stored in the V$SYSSTAT view. These statistics help identify and correct performance issues.

The V$SESSTAT view displays statistical event information for each session. This information is only valid for the currently connected session. When a session disconnects, all its statistical event information in the V$SESSTAT view is updated: the values are cleared, and new values are generated when the next session connects.

Many statistical events are associated with internal implementations and therefore may change or be removed; the actual situation shall prevail.

View statistical events

You can display all statistical events and their corresponding statistical event types in alphabetical order by using SQL statements in the sys tenant. Here is an example:

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

Common statistics events

Statistics event type	Statistics event ID	Statistics event name	Description
1	10000	rpc packet in	The total number of RPC packets sent to this OBServer.
1	10001	rpc packet in bytes	The total size of RPC packets sent to this OBServer.
1	10002	rpc packet out	The total number of RPC packets sent from this OBServer.
1	10003	rpc packet out bytes	The total size of RPC packets sent from this OBServer.
1	10005	rpc net delay	The total network delay for RPC packets from sending to receiving (excluding decode packet time), in microseconds.
1	10006	rpc net frame delay	The total network delay for RPC packets from sending to receiving (including decode packet time), in microseconds.
2	20001	request dequeue count	The total number of successful requests dequeued from the tenant queue.
2	20002	request queue time	The total time spent in the request queue, in microseconds.
4	30000	trans commit log sync time	The total time spent in synchronizing commit logs to a majority of replicas, in microseconds.
4	30001	trans commit log sync count	The total number of commit logs.
4	30002	trans commit log submit count	The total number of logs committed in all transactions.
4	30005	trans start count	The total number of transactions started.
4	30006	trans total used time	The total time spent in executing all transactions, in microseconds.
4	30009	trans rollback count	The total number of transactions rolled back.
4	30010	trans rollback time	The total time spent in rolling back all transactions, in microseconds.
4	30200	xa start total count	The total number of `xa_start` statements (successful and failed).
4	30201	xa start total used time	The total time spent in executing all `xa_start` statements (successful and failed), in microseconds.
4	30202	xa start with rpc total count	The total number of successful remote `xa_start` statements.
4	30203	failed xa start total count	The total number of failed `xa_start` statements.
4	30204	xa end total count	The total number of `xa_end` statements (successful and failed).
4	30205	xa end total used count	The total time spent in executing all `xa_end` statements (successful and failed), in microseconds.
4	30206	xa end with rpc total count	The total number of successful remote `xa_end` statements.
4	30207	failed xa end total count	The total number of failed `xa_end` statements.
4	30208	xa prepare total count	The total number of `xa_prepare` statements (successful and failed).
4	30209	xa prepare total used time	The total time spent in executing all `xa_prepare` statements (successful and failed), in microseconds.
4	30210	xa prepare with rpc total count	The total number of successful remote `xa_prepare` statements.
4	30211	failed xa prepare total count	The total number of failed `xa_prepare` statements.
4	30212	xa commit total count	The total number of `xa_commit` statements (successful and failed).
4	30213	xa commit total used time	The total time spent in executing all `xa_commit` statements (successful and failed), in microseconds.
4	30214	xa commit with rpc total count	The total number of successful remote `xa_commit` statements.
4	30215	failed xa commit total count	The total number of failed `xa_commit` statements.
4	30216	xa rollback total count	The total number of `xa_rollback` statements (successful and failed).
4	30217	xa rollback total used time	The total time spent in executing all `xa_rollback` statements (successful and failed), in microseconds.
4	30218	xa rollback with rpc total count	The total number of successful remote `xa_rollback` statements.
4	30219	failed xa rollback total count	The total number of failed `xa_rollback` statements.
8	40000	sql select count	The number of SELECT statements executed.
8	40001	sql select time	The total execution time of SELECT statements, in microseconds.
8	40002	sql insert count	The number of INSERT statements executed.
8	40003	sql insert time	The total execution time of INSERT statements, in microseconds.
8	40004	sql replace count	The number of REPLACE statements executed.
8	40005	sql replace time	The total execution time of REPLACE statements, in microseconds.
8	40006	sql update count	The number of UPDATE statements executed.
8	40007	sql update time	The total execution time of UPDATE statements, in microseconds.
8	40008	sql delete count	The number of DELETE statements executed.
8	40009	sql delete time	The total execution time of DELETE statements, in microseconds.
8	40018	sql other count	The number of other statements executed.
8	40019	sql other time	The total execution time of other statements, in microseconds.
8	40020	ps prepare count	The number of PS prepare operations.
8	40021	ps prepare time	The total time consumed by PS prepare operations, in microseconds.
8	40022	ps execute count	The number of PS execute operations.
8	40023	ps close count	The number of PS close operations.
8	40024	ps close time	The total time consumed by PS close operations, in microseconds.
8	40025	sql commit count	The number of commit operations.
8	40026	sql commit time	The total time consumed by commit operations, in microseconds.
8	40027	sql rollback count	The number of rollback operations.
8	40028	sql rollback time	The total time consumed by rollback operations, in microseconds.
8	40030	opened cursors current	The number of cursors that are currently open (used as session cache by OCP).
8	40031	opened cursors cumulative	The cumulative number of opened cursors.
8	40010	sql local count	The number of LOCAL statements executed.
8	40011	sql remote count	The number of REMOTE statements executed.
8	40012	sql distributed count	The number of DISTRIBUTED statements executed.
8	40013	active sessions	The number of active sessions.
8	40014	single query count	The number of single queries.
8	40015	multiple query count	The total number of statements sent by using the Multiple Query protocol.
8	40016	multiple query with one stmt count	The number of times that multiple queries are executed by using a single database statement.
8	40100	sql inner select count	The number of inner SQL SELECT statements executed.
8	40101	sql inner select time	The total execution time of inner SQL SELECT statements, in microseconds.
8	40102	sql inner insert count	The number of inner SQL INSERT statements executed.
8	40103	sql inner insert time	The total execution time of inner SQL INSERT statements, in microseconds.
8	40104	sql inner replace count	The number of inner SQL REPLACE statements executed.
8	40105	sql inner replace time	The total execution time of inner SQL REPLACE statements, in microseconds.
8	40106	sql inner update count	The number of inner SQL UPDATE statements executed.
8	40107	sql inner update time	The total execution time of inner SQL UPDATE statements, in microseconds.
8	40108	sql inner delete count	The number of inner SQL DELETE statements executed.
8	40109	sql inner delete time	The total execution time of inner SQL DELETE statements, in microseconds.
8	40110	sql inner other count	The number of inner SQL OTHER statements executed.
8	40111	sql inner other time	The total execution time of inner SQL OTHER statements, in microseconds.
8	40112	user logons cumulative	The number of user logons.
8	40113	user logouts cumulative	The number of user logouts.
8	40114	user logons failed cumulative	The number of failed user logons.
8	40115	user logons time cumulative	The total time spent on user logons.
8	40116	sql local execute time	The total execution time of SQL queries executed on the local database node, in microseconds.
8	40117	sql remote execute time	The total execution time of SQL queries executed on the remote node, in microseconds.
8	40118	sql distributed execute time	The total execution time of distributed transactions or SQL queries executed across multiple nodes, in microseconds.
8	40119	sql fail count	The number of SQL execution failures.
8	40120	inner sql local count	The number of local SQL statements generated internally.
8	40121	inner sql remote count	The number of remote SQL statements generated internally.
8	40122	inner sql distributed count	The number of distributed SQL statements generated internally.
16	50000	row cache hit	The number of row cache hits.
16	50001	row cache miss	The number of row cache misses.
16	50008	block cache hit	The number of micro block cache hits.
16	50009	block cache miss	The number of micro block cache misses.
32	60000	io read count	The number of read I/O operations.
32	60001	io read delay	The read I/O delay, in microseconds.
32	60002	io read bytes	The size of data involved in read I/O operations.
32	60003	io write count	The number of write I/O operations.
32	60004	io write delay	The write I/O delay, in microseconds.
32	60005	io write bytes	The size of data involved in write I/O operations.
32	60012	memstore apply count	The number of write operations executed on the MemTable.
32	60013	memstore apply succ count	The number of successful write operations executed on the MemTable.
32	60014	memstore apply fail count	The number of failed write operations executed on the MemTable.
32	60019	memstore read lock succ count	The number of successful snapshot read checks executed on rows.
32	60020	memstore read lock fail count	The number of failed snapshot read checks executed on rows.
32	60021	memstore write lock succ count	The number of successful row locks added.
32	60022	memstore write lock fail count	The number of failed row locks added.
32	60023	memstore wait write lock time	The time spent waiting for a row lock, in microseconds.
32	60024	memstore wait read lock time	The time spent waiting for a snapshot read, in microseconds.
32	60031	storage read row count	The number of rows read from storage.
32	60039	io read queue delay	The read I/O queue delay, in microseconds.
32	60057	ssstore read row count	The number of rows read from an SSTable.
32	69012	backup io read delay	The backup read I/O interface call delay, in microseconds.
32	69013	backup io write delay	The backup write I/O interface call delay, in microseconds.
32	69014	cos io read delay	The COS Get interface call delay, in microseconds.
32	69015	cos io write delay	The COS Put interface call delay, in microseconds.
32	130000	active memstore used	The memory occupied by active MemTables (may be larger).
32	130001	total memstore used	The memory occupied by all MemTables.
32	130002	major freeze trigger	The memory limit for triggering a major freeze.
32	130004	memstore limit	The total memory available for MemTables.
64	140002	max memory size	The max_memory value for the tenant memory specification.
64	140003	memory usage	The total memory used by the tenant.
64	140005	max cpus	The max_cpu parameter for the tenant, multiplied by 100.
64	140006	cpu usage	The CPU used by the tenant, multiplied by 100.
256	80057	clog trans log total size	The sum of the MemTable mutator size and the trans_header size.
3072	200001	DB time	The total time for database activities, including the sum of CPU time and non-idle wait time.
3072	200002	DB CPU	The CPU time consumed by database activities, in microseconds.
3072	200005	background elapsed time	The total time for background processes, in microseconds.
3072	200006	background cpu time	The CPU time consumed by background processes, in microseconds.
3072	200010	non idle wait time	The total time for non-idle waits, in microseconds.
3072	200011	idle wait time	The total time for idle waits, in microseconds.
3072	200012	background database time	The total time for database operations by background processes, in microseconds.
3072	200013	background database non-idle wait time	The time for non-idle waits during database operations by background processes, in microseconds.
3072	200014	background database idle wait time	The time for idle waits during database operations by background processes, in microseconds.
3072	220001	concurrency wait total time	The total time for waits caused by concurrency issues, such as resource locking, in microseconds.
3072	220002	user io wait total time	The total time for user processes waiting for I/O operations (such as reading or writing data to disk), in microseconds.
3072	220003	application wait total time	The total time for waits caused by user application code, such as row-level locking or explicit lock commands, in microseconds.