Note
This view is available starting with V2.2.77.
Purpose
This view displays some overall information about SQL Workarea on the current OBServer node, including the maximum available memory, current used memory, and current hold memory. You can use this view to understand the usage of Workarea in the current tenant, such as memory utilization.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| MAX_WORKAREA_SIZE | NUMBER(38) | NO | The maximum Workarea memory, which is determined by the parameter. The unit is bytes. |
| WORKAREA_HOLD_SIZE | NUMBER(38) | NO | The current hold memory size of Workarea. The unit is bytes.
Note>The actual usage cannot be obtained from the memory management module. Therefore, only the hold value can be obtained. |
| MAX_AUTO_WORKAREA_SIZE | NUMBER(38) | NO | The estimated maximum available memory size in auto mode. The unit is bytes. You can roughly calculate the maximum available memory using the formula max_work_area_size - hold + total_mem_used. This represents the maximum memory size that can be managed by auto mode in the current Workarea. |
| MEM_TARGET | NUMBER(38) | NO | The target size of available memory for the current Workarea. The unit is bytes. The difference between this value and max_auto_work_area is that this value is a certain proportion of max_auto_work_area. |
| TOTAL_MEM_USED | NUMBER(38) | NO | The current size of auto memory used. The unit is bytes. This value is the size of auto memory used, as reported by the SQL automatic memory management module, not the actual size of memory used. |
| GLOBAL_MEM_BOUND | NUMBER(38) | NO | The maximum available memory size in auto mode. The unit is bytes. |
| DRIFT_SIZE | NUMBER(38) | NO | The change in the current memory demand. The unit is bytes. This value is mainly used to calculate the fluctuation. When the fluctuation reaches a certain range, the global bound size will be automatically recalculated. |
| WORKAREA_COUNT | NUMBER(38) | NO | The number of registered operator profiles. |
| MANUAL_CALC_COUNT | NUMBER(38) | NO | The number of times the global bound size is calculated without being triggered periodically. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server. |
| SVR_PORT | NUMBER | NO | The port number of the server. |
Sample query
Query the SQL Workarea information of the current tenant on the current OBServer node.
obclient [SYS]> SELECT * FROM SYS.V$OB_SQL_WORKAREA_MEMORY_INFO;
The query result is as follows:
+-------------------+--------------------+------------------------+------------+----------------+------------------+------------+----------------+-------------------+----------------+----------+
| MAX_WORKAREA_SIZE | WORKAREA_HOLD_SIZE | MAX_AUTO_WORKAREA_SIZE | MEM_TARGET | TOTAL_MEM_USED | GLOBAL_MEM_BOUND | DRIFT_SIZE | WORKAREA_COUNT | MANUAL_CALC_COUNT | SVR_IP | SVR_PORT |
+-------------------+--------------------+------------------------+------------+----------------+------------------+------------+----------------+-------------------+----------------+----------+
| 214748364 | 0 | 214748364 | 214748364 | 0 | 26843545 | 0 | 0 | 887 | 11.xxx.xxx.xxx | 28825 |
+-------------------+--------------------+------------------------+------------+----------------+------------------+------------+----------------+-------------------+----------------+----------+
1 row in set