Oracle SNMP Support Reference Guide

Contents Glossary Index Home Previous Next

oraRepTable

The oraRep Table contains general information about the replicated schemas in the current database. Besides providing a count of the number of shemas being replicated to remote sites, it reports problems with the current node. These problems include the inability to propagate or receive replicated data.

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
Table A - 8. oraRep Table Variables and Corresponding Object ID's

oraRepPending2PhaseCommits

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

oraRepDisabledTriggers

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)

oraRepInvalidPackages

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)

oraRepSchemas

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

Contents Glossary Index Home Previous Next