Oracle Defer Transaction Errors Test
Oracle uses deferred transactions to propagate data-level changes asynchronously among master sites in an advanced replication system as well as from an updatable snapshot to its master table. If a transaction is not successfully propagated to the remote site, Oracle rolls back the transaction, and logs the transaction in the SYS.DEFERROR view in the remote destination database.
This test reports the number of transactions that failed to materialize to the destination database from the source database due to errors.
This test is disabled by default. To enable the test, go to the enable / disable tests page using the menu sequence : Agents -> Tests -> Enable/Disable, pick Oracle Database as the Component type, Performance as the Test type, choose this test from the disabled tests list, and click on the << button to move the test to the ENABLED TESTS list. Finally, click the Update button.
Target of the test : An Oracle server
Agent deploying the test : An internal agent
Outputs of the test : One set of results for the Oracle server being monitored.
|
Measurement | Description | Measurement Unit | Interpretation |
---|---|---|---|
Defer transaction error count: |
Indicates the number of transactions that failed due to errors while being transferred from the source database to the destination database. |
Number |
An error in applying a deferred transaction may result from a database problem, such as a lack of available space in the table to be updated, or may be the result of an unresolved insert, update, or delete conflict. |