Purpose
The V$OB_SQL_WORKAREA_MEMORY_INFO view displays some general information about the SQL workarea, including the maximum available memory, current memory usage, and currently held memory. In this view, you can learn about the usage of the workareas in the current tenant, such as the memory usage.
Note
This view is introduced since OceanBase Database V2.2.77.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| MAX_WORKAREA_SIZE | bigint(20) | NO | The maximum memory that the workarea can occupy. The available memory is determined by ob_sql_work_area_percentage. |
| WORKAREA_HOLD_SIZE | bigint(20) | NO | The size of the currently held memory of the workarea. Note Only the size of the held memory can be obtained because the specific usage cannot be obtained from the memory management module. |
| MAX_AUTO_WORKAREA_SIZE | bigint(20) | NO | The estimated maximum available memory size in auto mode. The maximum available memory is calculated based on the following formula: MAX_WORKAREA_SIZE – WORKAREA_HOLD_SIZE + TOTAL_MEM_USED. It indicates the maximum memory that is automatically managed in the current workarea. |
| MEM_TARGET | bigint(20) | NO | The target size of memory that the workarea can occupy. It differs from MAX_AUTO_WORKAREA_SIZE in that this size is part of the maximum available size in auto mode. |
| TOTAL_MEM_USED | bigint(20) | NO | The size of memory used in auto mode. This size is obtained by the automatic memory management module and does not reflect the actual used size. |
| GLOBAL_MEM_BOUND | bigint(20) | NO | The maximum available global memory in auto mode. |
| DRIFT_SIZE | bigint(20) | NO | The current change in the required memory size. When the value of this column reaches the specified threshold, the global bound size is automatically recalculated. |
| WORKAREA_COUNT | bigint(20) | NO | The number of registered operator profiles. |
| MANUAL_CALC_COUNT | bigint(20) | NO | The number of calculations of the global bound size that are irregularly triggered. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| SVR_IP | varchar(46) | NO | The IP address of the server. |
| SVR_PORT | bigint(20) | NO | The port number of the server. |