Oracle教程 2023-02-23

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

本站中文解释

ALL_APPLY_ERRORS（所有应用错误）视图是Oracle数据库中的一个动态性视图，它提供了一种检查及应用解决策略的方法，用于发现并解决复制过程中出现的错误。

用途：

1.ALL_APPLY_ERRORS视图可以用来查询复制错误及其解决情况；

2.通过查询ALL_APPLY_ERRORS视图，可以获得以下信息：APPLY信息的行索引和行状态，相关错误信息，错误作用的表；

3.通过ALL_APPLY_ERRORS视图，可以根据获取的错误信息来诊断复制及解决策略的问题；

4.可以使用ALL_APPLY_ERRORS视图来查看特定的应用错误是否存在，这可以帮助开发者对特定应用表进行相应的处理。

使用方法：

1.查询应用错误：可以使用SELECT语句来查询ALL_APPLY_ERRORS视图详细信息；

2.解决应用错误：可以按照搜索到的错误信息提供的建议来解决该错误；

3.查看应用状态：可以使用ALL_APPLY_ERRORS视图的APPLY_STATUS字段来查看复制过程中应用的状态。

官方英文解释

ALL_APPLY_ERROR displays information about the error transactions generated by the apply processes that dequeue messages from queues accessible to the current user.

Related Views

DBA_APPLY_ERROR displays information about the error transactions generated by all apply processes in the database.
USER_APPLY_ERROR displays information about the error transactions generated by apply processes visible to the current user. This view does not display the SOURCE_ROOT_NAME column.

Column	Datatype	Description
`APPLY_NAME`	`VARCHAR2(128)`	Name of the apply process at the local database which processed the transaction
`QUEUE_NAME`	`VARCHAR2(128)`	Name of the queue at the local database from which the transaction was dequeued
`QUEUE_OWNER`	`VARCHAR2(128)`	Owner of the queue at the local database from which the transaction was dequeued
`LOCAL_TRANSACTION_ID`	`VARCHAR2(22)`	Local transaction ID for the error transaction
`SOURCE_DATABASE`	`VARCHAR2(128)`	Database where the transaction originated
`SOURCE_TRANSACTION_ID`	`VARCHAR2(128)`	Original transaction ID at the source database
`SOURCE_COMMIT_SCN`	`NUMBER`	Original commit system change number (SCN) for the transaction at the source database
`MESSAGE_NUMBER`	`NUMBER`	Identifier for the message in the transaction that raised an error
`ERROR_NUMBER`	`NUMBER`	Error number of the error raised by the transaction
`ERROR_MESSAGE`	`VARCHAR2(4000)`	Error message of the error raised by the transaction
`RECIPIENT_ID`	`NUMBER`	User ID of the original user that applied the transaction
`RECIPIENT_NAME`	`VARCHAR2(128)`	Name of the original user that applied the transaction
`MESSAGE_COUNT`	`NUMBER`	Total number of messages inside the error transaction
`ERROR_CREATION_TIME`	`DATE`	Time that the error was created
`SOURCE_COMMIT_POSITION`	`RAW(64)`	Original commit position for the transaction
`ERROR_TYPE`	`VARCHAR2(11)`	NULL if the apply process can access all of the LCRs in the error transaction. `EAGER` `ERROR` if the apply process cannot access all of the LCRs in the error transaction. This error type typically means that the apply process was applying LCRs in a large transaction. When the `ERROR_TYPE` is `EAGER` `ERROR`, manage the error transaction using the instructions in Oracle Database XStream Guide. `RECORD LCR` indicates that a single LCR has been recorded as requested by user-specified error handling configuration `RECORD TXN NO LCRS` indicates that the identified transaction encountered an error and only the transaction ID is recorded as requested by user-specified error handling configuration `RECORD TXN WITH LCRS` indicates that the identified transaction encountered and error. The entire transaction is recorded as requested by user-specified error handling configuration. `UNHANDLED ERRORS NO LCR` indicates that the identified transaction encountered an error and there was no error handling specified for this handler. No LCRs are recorded for this transaction. `DISCARDED` is used to mark recorded and discarded LCRs.
`SOURCE_ROOT_NAME`	`VARCHAR2(128)`	The global name of the source root database
`ERROR_POSITION`	`RAW(64)`	LCR position at which the error occurred

本站中文解释

官方英文解释

相关推荐