Note
This view is introduced since OceanBase Database V4.3.0.
Purpose
The DBA_OB_AUX_STATISTICS view displays the auxiliary statistics of each tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| LAST_ANALYZED | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The timestamp for the last statistics collection. |
| CPU_SPEED(MHZ) | NUMBER(38) | YES | The CPU speed of the current environment, in MHz. |
| DISK_SEQ_READ_SPEED(MB/S) | NUMBER(38) | YES | The sequential read speed of the disk, in MB/s. |
| DISK_RND_READ_SPEED(MB/S) | NUMBER(38) | YES | The random read speed of the disk, in MB/s. |
| NETWORK_SPEED(MB/S) | NUMBER(38) | YES | The network transmission speed, in MB/s. |
Sample query
Manually enable auxiliary statistics collection.
obclient [SYS]> CALL dbms_stats.gather_system_stats();Query the auxiliary statistics of tenants.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_AUX_STATISTICS;The query result is as follows:
+------------------------------+----------------+---------------------------+---------------------------+---------------------+ | LAST_ANALYZED | CPU_SPEED(MHZ) | DISK_SEQ_READ_SPEED(MB/S) | DISK_RND_READ_SPEED(MB/S) | NETWORK_SPEED(MB/S) | +------------------------------+----------------+---------------------------+---------------------------+---------------------+ | 14-MAR-24 02.40.36.904572 PM | 2499 | 2675 | 370 | 1250 | +------------------------------+----------------+---------------------------+---------------------------+---------------------+ 1 row in set (0.017 sec)