Note
-
For V4.3.x versions, this view is available starting with V4.3.5 BP4.
Purpose
This view displays information about 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 | The tenant ID
|
| SVR_IP | varchar(46) | NO | The IP address of the node where the replica is located. |
| SVR_PORT | bigint(20) | NO | The port of the node where the replica is located. |
| 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 about objects cached in the result cache.
obclient [SYS]> SELECT * FROM SYS.GV$OB_RESULT_CACHE_OBJECTS;