Note
- For V4.3.x, this view is available starting with V4.3.5 BP4.
Purpose
This view displays information about objects cached in the result cache of udf objects executed on the current OBServer node.
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 number 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 of 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 value 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 configurations that affect the execution of the UDF. |
Sample query
Execute the following statement to query information about objects cached in the result cache of the current tenant.
obclient [SYS]> SELECT * FROM SYS.V$OB_RESULT_CACHE_OBJECTS;