Variable Name | Object ID |
oraRepPending2PhaseCommits | 1.3.6.1.4.1.111.4.3.1.1.1 |
oraRepDisabledTriggers | 1.3.6.1.4.1.111.4.3.1.1.2 |
oraRepInvalidPackages | 1.3.6.1.4.1.111.4.3.1.1.3 |
oraRepSchemas | 1.3.6.1.4.1.111.4.3.1.1.4 |
Syntax | Gauge32 |
Max-Access | read-only |
Explanation | This indicates the number of failed distributed transactions in a PREPARED state. Used for monitoring configurations where databases are communicating synchronously. |
Typical Range | 0 |
Significance | This indicates the number of distributed transactions that remain unresolved because of a failure during the commit process. It can help measure the impact of failures. |
Related Variables | oraRepLinkErrors |
Suggested Presentation | error indicator |
Syntax | INTEGER32 |
Max-Access | read-only |
Explanation | This indicates the number of replication triggers that have been disabled. As triggers are the mechanism by which local changes are propogated to remote databases, disabled replication triggers cause databases in the replication environment to go out of sync. |
Typical Range | 0 |
Significance | Changes applied to replicated tales with a disabled replication trigger will not be propagated to remote sites. |
Related Variables | oraRepInvalidPackages |
Suggested Presentation | guage or error indicator (if >0) |
Syntax | INTEGER32 |
Max-Access | read-only |
Explanation | This indicates the number of replication packages that have been invalidated. As these packages are the mechanism by which remote changes are propogated to the local database, invalidated replication packages cause databases in the replication environment to go out of sync. |
Typical Range | 0 |
Significance | Invalid replication packages may cause transactions to build up in the error queue. |
Related Variables | oraRepDisabledTriggers |
Suggested Presentation | guage or error indicator (if >0) |
Syntax | INTEGER32 |
Max-Access | read-only |
Explanation | This indicates the number of schemas at the local node that are involved in replication. |
Typical Range | configuration dependent |
Significance | The number of database schema invoved in replication at the local site. |
Related Variables | oraRepSchemaName |
Suggested Presentation | guage or simple string |