Oracle教程 2023-02-24

Oracle 视图 V$RESULT_CACHE_DEPENDENCY 官方解释，作用，如何使用详细说明

Oracle视图V$RESULT_CACHE_DEPENDENCY用于查看当前和活动结果缓存中的模式和对象的依赖关系。通过这个视图，可以查看表或视图被用做结果缓存中的依赖，以及缓存被每一个结果缓存依赖项更新的时间。

如何使用:
首先确保结果缓存已经启用，然后可以使用下面的SQL查询V$RESULT_CACHE_DEPENDENCY来查看当前和活动的缓存依赖关系：

SELECT SCHEMA#, SCHEMA_NAME, OBJ#, OBJ_NAME, LAST_CHANGE#
FROM V$RESULT_CACHE_DEPENDENCY;

V$RESULT_CACHE_DEPENDENCY displays the depends-on relationship between cached results and dependencies.

Column	Datatype	Description
`RESULT_ID`	`NUMBER`	Cached result
`DEPEND_ID`	`NUMBER`	Dependency object
`OBJECT_NO`	`NUMBER`	Dictionary object number of the dependency object
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

分享到：