Oracle 视图 DBA_HIST_APPLY_SUMMARY 官方解释,作用,如何使用详细说明
Oracle中的视图DBA_HIST_APPLY_SUMMARY是一个用于查询保持状态和应用时间概要信息的视图。它由数据库层收集的数据统计组成。它主要提供实例保持时间,恢复点应用时间和恢复点日志应用时间。
只有选择了受支持的特定痕迹(如Automatic Workload Repository)的实例,才能获取DBA_HIST_APPLY_SUMMARY视图的详细信息。
使用此视图可以查询在每个恢复点时期的实例保持时间(INSTANCE_RECOVERY_ELAPSED_TIME),恢复点应用时间(RESTORE_POINT_ELAPSED_TIME)以及在特定事件的恢复点日志应用时间(LOG_POINT_ELAPSED_TIME)等信息,从而可以获取关于系统恢复状态和应用时间的重要信息。
例如,下面的SQL查询可以用于查询特定时段内活动恢复点(ACTIVE_RESTORE_POINT)的概要信息:
SELECT * FROM dba_hist_apply_summary where trunc(begin_time) between start_date and end_date
此外,DBA_HIST_APPLY_SUMMARY视图也可以用于查询特定事件(如SCN)的实例恢复状态和应用时间:
SELECT * FROM dba_hist_apply_summary where active_restore_point = restore_point_name and resetlogs_scn_number
官方英文解释DBA_HIST_APPLY_SUMMARY displays historical statistics information about each apply process for Oracle GoldenGate, and Oracle XStream. This view is intended for use with Automatic Workload Repository (AWR).
For captured messages, the delay (in seconds) between the creation of the last message and it being received by the apply process. For user enqueued messages, the delay between the message being enqueued in the local database and being received by the apply process.
Total number of transactions received by the coordinator process since the apply process was last started
Total number of transactions applied by the apply process since the apply process was last started
Number of times since the apply process was last started that an apply server waited to apply a logical change record (LCR) in a transaction until another apply server applied a transaction because of a dependency between the transactions
Number of times since the apply process was last started that an apply server waited to commit a transaction until another apply server committed a transaction to serialize commits
For captured messages, the delay (in seconds) between the creation of the message corresponding to the low watermark and it being applied by the apply process. For user enqueued messages, the delay between the message being enqueued in the local database and being applied by the apply process.
Total number of messages applied by all the apply servers since the apply process was last started
Time elapsed (in hundredths of a second) dequeuing messages by all the apply servers since the apply process was last started
Time elapsed (in hundredths of a second) applying messages by all the apply servers since the apply process was last started
Total number of complete transactions that the coordinator has not assigned to any apply servers
Number of transactions applied by the apply process that resulted in an apply error since the apply process was last started
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.
我想要获取技术服务或软件
服务范围:MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式:远程服务、电话支持、现场服务,沟通指定方式服务
技术标签:数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题
本站部分文章参考或来源于网络,如有侵权请联系站长。
数据库远程运维 Oracle 视图 DBA_HIST_APPLY_SUMMARY 官方解释,作用,如何使用详细说明
相关文章
- Oracle 视图 DBA_ADVISOR_SQLA_WK_MAP 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_ANALYTIC_VIEW_LVLGRPS 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_AUDIT_STATEMENT 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_AW_PS 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_FILE_GROUP_TABLESPACES 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_GG_AUTO_CDR_COLUMN_GROUPS 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_TAB_COL_STATISTICS 官方解释,作用,如何使用详细说明
- Oracle 视图 USER_IM_EXPRESSIONS 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_SCHEDULER_REMOTE_DATABASES 官方解释,作用,如何使用详细说明
- 检查提升工作效率:使用Oracle数据库字段检查(oracle数据库字段)
- 初探Oracle数据库架构特征(oracle数据库的架构)
- 监控Oracle索引状态监控:提升性能的最佳实践(oracle索引状态)
- 超时解决Oracle存储过程超时等待的技巧(oracle存储过程等待)
- Oracle数据文件恢复,重建数据库梦想(oracle恢复数据文件)
- 如何查看 Oracle 数据库的版本信息?(查oracle版本)
- Oracle作业中如何控制日期参数(oracle作业日期参数)
- Oracle保留字完整的字典指南(oracle保留字字典)
- Oracle中日期数据类型的比较分析(oracle中日期的比较)
- 方文档安装Oracle官方文档安装指南(oracle上官)
- Oracle EM监控乃服务运行保证利器(oracle em监控项)
- Oracle DBA语句驱动业务功能(oracle dba语句)