Oracle教程 2023-02-24

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

V$LCR_CACHE视图用于显示和管理有关LogMiner传输缓存的相关信息。LogMiner当增量对象或其他数据改变时，可以根据V$LCR_CACHE视图确定有哪些传输信息需要推送到客户端。

使用方法:

查看信息：

SELECT * FROM V$LCR_CACHE;

清空/删除缓存：

DELETE FROM V$LCR_CACHE WHERE SOURCE_ID = &SOURCE_ID; //SOURCE_ID 为源ID号

V$LCR_CACHE displays information about entries in the logical change record (LCR) cache.

Column	Datatype	Description
`LCR_TYPE`	`CHAR(12)`	Indicates whether the LCR is `INTERNAL` or `EXTERNAL`
`COMPONENT_NAME`	`VARCHAR2(128)`	Component name
`COMPONENT_TYPE`	`VARCHAR2(40)`	Component type. Possible values: `APPLY` `COORDINATOR` `APPLY` `READER` `APPLY` `SERVER` `CAPTURE` `COORDINATOR` `CAPTURE` `READER` `CAPTURE` `SERVER`
`NUM_COLUMNS`	`NUMBER`	Number of columns in the LCR
`FREE_COUNT`	`NUMBER`	Number of available LCRs
`REQUEST_COUNT`	`NUMBER`	Total request count
`CACHE_HITS`	`NUMBER`	Cache hit count
`ALT_CACHE_HITS`	`NUMBER`	Hit count from an alternate LCR cache entry
`PURGED_COUNT`	`NUMBER`	Cache purge count
`SID`	`NUMBER`	Session ID of the component process
`SERIAL#`	`NUMBER`	Session serial number of the component process
`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

Note:

This view is available starting with Oracle Database 21c.

分享到：