Oracle 视图 DBA_SR_STLOG_STATS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle 视图DBA_SR_STLOG_STATS用于查看私有 Service 请求错误日志 (STLog) 中出现的统计信息。
STLog 日志由 Oracle 自动生成，用于收集服务请求有关的故障信息。其中包含了来自操作员传入的错误报告和累积报告，以及相关故障的概述和细节。
使用DBA_SR_STLOG_STATS视图，DBA们可以轻松查看私有 Service 请求错误日志 (STLog) 的统计数据，可以比较得出错误报告的数量。它也可以帮助 DBA 确定是否存在某些特定的错误，以及日志中出现的错误的次数是否出现了显著变化。
为了使用DBA_SR_STLOG_STATS视图，DBA需要具有SELECT_CATALOG_ROLE权限。
下面是一个使用DBA_SR_STLOG_STATS查询的示例:
SQL>SELECT GV$STLOG_STATS.ERRCOUNT,
GV$STLOG_STATS.SUMERRORS
FROM DBA_SR_STLOG_STATS;
ERRCOUNT SUMERRORS
——— ———
13761 115
官方英文解释
DBA_SR_STLOG_STATS provides information on the statistics in the staging logs for the tables processed by DBMS_SYNC_REFRESH.PREPARE_STAGING_LOG.
These three statistics columns in the staging log are filled in PREPARE_STAGING_LOG:
-
The number of inserts (
NUM_INSERTS) -
The number of deletes (
NUM_DELETES) -
The number of updates (
NUM_UPDATES)
After the data in the staging logs of a synchronous refresh group have been processed by PREPARE_REFRESH and EXECUTE_REFRESH, the statistics columns for the tables in the group are cleared and appear as NULL.
Related View
USER_SR_STLOG_STATS provides information on the statistics in the staging logs for the tables belonging to the current user processed by DBMS_SYNC_REFRESH.PREPARE_STAGING_LOG.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the base table registered for synchronous refresh |
|
|
|
|
Name of the table |
|
|
|
|
Name of the staging log for tables. NULL for materialized views |
|
|
|
|
The number of inserts in the staging log |
|
|
|
|
The number of deletes in the staging log |
|
|
|
|
The number of updates in the staging log |
|
|
|
The mode specified by the user in running
|
See Also:
-
“USER_SR_STLOG_STATS”
-
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_SYNC_REFRESHpackage
