Note
-
For V4.3.x, this view is available starting with V4.3.5 BP4.
Purpose
This view displays the 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 resides. |
| SVR_PORT | bigint(20) | NO | The port of the node where the replica resides. |
| CACHE_OBJECT_ID | bigint(20) | NO | The ID of the cache object 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 time of the last access to the cache. |
| HIT_COUNT | bigint(20) | NO | The number of cache hits. |
| CACHE_OBJ_SIZE | bigint(20) | NO | The size of the cache object in memory. |
| 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 ID of the database to which the UDF belongs. |
| 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 configuration items 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;