Oracle教程 2023-02-27

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

本站中文解释

_INFO

Oracle视图“DBA_SR_GRP_STATUS_INFO”存储有关表空间/分组间状态的信息，以帮助诊断表空间/分组间存储。它显示当前表空间状态、表空间状态分组和指定的表空间的错误代码和报警阈值。

可以使用该视图检查当前表空间状态，包括但不限于：正常状态、写入错误状态、表空间状态组ID、表空间状态组中指定表空间的错误代码和报警阈值。

例如，可以使用以下语句来检查表空间组ID是否处于“正常”状态：

SELECT STATUS
FROM DBA_SR_GRP_STATUS_INFO
WHERE GROUP_ID=’

‘;

官方英文解释

DBA_SR_GRP_STATUS provides information on the current refresh operations for the current synchronous refresh groups in the database. It has the same columns as the DBA_SR_GRP_STATUS_ALL view.

Refresh operations are controlled using the DBMS_SYNC_REFRESH package.

Related View

USER_SR_GRP_STATUS provides information on the current refresh operations for the current synchronous refresh groups in the database which are owned by the current user. Its columns are the same as those in DBA_SR_GRP_STATUS.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the refresh operation, which is the user who launched the operation
`GROUP_ID`	`NUMBER`	`NOT NULL`	Group ID of the synchronous refresh group
`OPERATION`	`VARCHAR2(7)`		The phase of the refresh operation performed: `PREPARE` `EXECUTE`
`STATUS`	`VARCHAR2(10)`		The status of the refresh operation: `RUNNING` `NOT PROCESSED` `COMPLETE` `ERROR-SOFT` `ERROR-HARD` `ABORT` `PARTIAL`
`NUM_TBLS`	`NUMBER`	`NOT NULL`	The number of tables in the synchronous refresh group
`NUM_MVS`	`NUMBER`	`NOT NULL`	The number of materialized views in the synchronous refresh group
`BASE_TBLS_REFR_STATUS`	`VARCHAR2(13)`		Indicates the refresh status of base tables in the synchronous refresh group. The possible values are: `NOT PROCESSED` `COMPLETE` `ABORT`
`NUM_MVS_COMPLETED`	`NUMBER`		The number of materialized views which have completed refresh in the synchronous refresh group
`NUM_MVS_ABORTED`	`NUMBER`		The number of materialized views which have aborted refresh in the synchronous refresh group
`ERROR_NUMBER`	`NUMBER`		Error number of the run (if any)
`ERROR_MESSAGE`	`VARCHAR2(4000)`		Error message of the run (if any)
`PREPARE_START_TIME`	`DATE`		Time that the `PREPARE_REFRESH` phase of the run started
`PREPARE_END_TIME`	`DATE`		Time that the `PREPARE_REFRESH` phase of the run ended
`EXECUTE_START_TIME`	`DATE`		Time that the `EXECUTE_REFRESH` phase of the run started
`EXECUTE_END_TIME`	`DATE`		Time that the `EXECUTE_REFRESH` phase of the run ended

本站中文解释

官方英文解释

相关推荐