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 of the udf objects executed during the current session on all 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 when the cache was last accessed. |
| 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 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 command to query information about objects cached in the result cache of the current tenant.
obclient [SYS]> SELECT * FROM SYS.V$OB_RESULT_CACHE_OBJECTS;