Monitorable (Read-Only) Properties

Monitorable properties allow you to view information related to the database, database instance, or far sync instance.

You cannot change the values of monitorable properties. You can view all of them using the DGMGRL SHOW commands.

Note:

Information for monitorable properties can be seen only when broker management of the entity is enabled. Cloud Control displays the information obtained from these properties on the Property page.

If the database is an Oracle RAC database, the output values of some properties may also show instance-specific information. For example if the primary database is an Oracle RAC database, LogXptStatus may show Instance1 transmitting redo data to Standby2 has an error and Instance2 transmitting redo data to Standby4 has an error.

The following sections describe the monitorable properties:

• InconsistentLogXptProps (Inconsistent Redo Transport Properties)

• LogXptStatus (Redo Transport Status)

• LsbyFailedTxnInfo (Logical Standby Failed Transaction Information)

• LsbyParameters (Logical Standby Parameters)

• RecvQEntries (Receive Queue Entries)

• SendQEntries (Send Queue Entries)

• TopWaitEvents

• InconsistentLogXptProps (Inconsistent Redo Transport Properties)
  The InconsistentLogXptProps monitorable property returns a table that shows all properties related to redo transport services whose values are inconsistent between the broker configuration file and the runtime value.
• LogXptStatus (Redo Transport Status)
  The LogXptStatus monitorable property returns a table that contains the error status of redo transport services for each of the enabled configuration members.
• LsbyFailedTxnInfo (Logical Standby Failed Transaction Information)
  The LsbyFailedTxnInfo monitorable property identifies a failed transaction that caused log apply services to stop.
• LsbyParameters (Logical Standby Parameters)
  The LsbyParameters monitorable property contains a string that identifies the value of MAX_SGA and MAX_SERVERS specifically reserved for log apply services.
• RecvQEntries (Receive Queue Entries)
  The RecvQEntries monitorable property returns a table indicating all log files that were received by the standby database but have not yet been applied.
• SendQEntries (Send Queue Entries)
  The SendQEntries monitorable property returns a table that shows all log files on the primary database that were not successfully archived to one or more standby databases.
• TopWaitEvents
  The TopWaitEvents monitorable property specifies the 5 events with the longest waiting time in the specified instance.