V$GOLDENGATE_CAPABILITIES

V$GOLDENGATE_CAPABILITIES displays information about the usage of various Oracle GoldenGate features, as well as database features used by Oracle GoldenGate.

Column Datatype Description
NAME VARCHAR2(22)

Feature name. Possible values:

  • AUTOCDR
  • DBENCRYPTION
  • DDLTRIGGEROPTIMIZATION
  • DELETECASCADEHINT
  • GGSESSION
  • PROCREPLICATION
  • SUPPLEMENTALLOG
  • TRANSIENTDUPLICATE
  • TRIGGERSUPPRESSION
COUNT NUMBER Number of times the feature has been used since instance startup
LAST_USED DATE Date on which the feature was last used
CON_ID NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data