Note
- This view is available starting with V4.4.0.
Purpose
This view displays information about objects cached in the result cache of udf functions 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 of the node where the replica resides. |
| CACHE_OBJECT_ID | bigint(20) | NO | The ID of the cached 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 cached object was first loaded. |
| LAST_ACTIVE_TIME | timestamp(6) | NO | The time when the cached object was last accessed. |
| HIT_COUNT | bigint(20) | NO | The number of cache hits. |
| CACHE_OBJ_SIZE | bigint(20) | NO | The size of the cached object in memory. |
| BUILD_TIME | bigint(20) | NO | The execution time of the UDF. |
| OBJECT_TYPE | longtext | NO | The type of the cached object. For result cache, the only supported 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 cached 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;