Oracle教程 2023-02-27

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

Oracle的视图ALL_REFRESH是数据库层中的视图，它包含系统中所有激活的定期和逐行刷新，以及它们的行和描述信息。它用于检索当前活动的查看的刷新计划信息。

使用该视图，可以枚举系统中所有激活的定期和逐行刷新，以便查询某个特定的查看的刷新策略或者检查活动刷新计划的运行情况。

该视图可以使用以下查询：SELECT * FROM ALL_REFRESH;

ALL_REFRESH视图可用于查询某个表或视图是否正在定期或逐行刷新，以及这些查看的刷新计划的运行情况，主要用于数据库管理中。

ALL_REFRESH describes all the refresh groups accessible to the current user.

Related Views

Column	Datatype	NULL	Description
`ROWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the refresh group
`RNAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the refresh group
`REFGROUP`	`NUMBER`		Internal identifier of the refresh group
`IMPLICIT_DESTROY`	`VARCHAR2(1)`		Indicates whether the refresh group is destroyed when its last item is subtracted (`Y`) or not (`N`)
`PUSH_DEFERRED_RPC`	`VARCHAR2(1)`		Indicates whether changes are pushed from the snapshot to the master before refresh (`Y`) or not (`N`)
`REFRESH_AFTER _ERRORS`	`VARCHAR2(1)`		Indicates whether to proceed with refresh despite errors when pushing deferred RPCs (`Y`) or not (`N`)
`ROLLBACK_SEG`	`VARCHAR2(128)`		Name of the rollback segment to use while refreshing
`JOB`	`NUMBER`		Identifier of the job used to refresh the group automatically
`NEXT_DATE`	`DATE`		Date that this job will next be refreshed automatically, if not broken
`INTERVAL`	`VARCHAR2(200)`		A date function used to compute the next `NEXT_DATE`
`BROKEN`	`VARCHAR2(1)`		Indicates whether the job is broken and will never be run (`Y`) or not (`N`)
`PURGE_OPTION`	`NUMBER(38)`		Method for purging the transaction queue after each push (`1` indicates quick purge option; `2` indicates precise purge option)
`PARALLELISM`	`NUMBER(38)`		Level of parallelism for transaction propagation
`HEAP_SIZE`	`NUMBER(38)`		Size of the heap
`JOB_NAME`	`VARCHAR2(128)`		The name of the job used to automatically refresh the group