Note
-
This view is available starting with V4.4.0.
Purpose
This view displays the objects cached in the result cache created during the execution of udf marked with result_cache on all OBServer nodes.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID:
|
| SVR_IP | varchar(46) | NO | The IP address of the node where the replica resides. |
| SVR_PORT | bigint(20) | NO | The port of the node where the replica resides. |
| CACHE_OBJECT_ID | bigint(20) | NO | The cache object ID allocated by the lib cache. |
| UDF_NAME | longtext | NO | The name of the UDF object. |
| FIRST_LOAD_TIME | timestamp(6) | NO | The time when the cache object was first loaded. |
| LAST_ACTIVE_TIME | timestamp(6) | NO | The last access time to the cache. |
| HIT_COUNT | bigint(20) | NO | The number of cache hits. |
| CACHE_OBJ_SIZE | bigint(20) | NO | The memory size occupied by the cache object. |
| BUILD_TIME | bigint(20) | NO | The execution time of the UDF. |
| OBJECT_TYPE | longtext | NO | The type of the cache object. For result cache, the only type is UDF_RESULT. |
| OBJECT_ID | bigint(20) | NO | The ID of the UDF routine. |
| DB_ID | bigint(20) | NO | The DB ID of the UDF. |
| HASH | bigint(20) | NO | The hash value of the cache object in the hash table. |
| SYS_VARS | varchar(4096) | NO | The set of system variables that affect the execution of the UDF. |
| CONFIGS | varchar(4096) | NO | The set of configurations that affect the execution of the UDF. |
Sample query
Execute the following command to query the information of objects cached in the result cache.
obclient [SYS]> SELECT * FROM SYS.GV$OB_RESULT_CACHE_OBJECTS;