1. Oracle GoldenGate Microservices REST API
  2. Tasks
  3. Distribution Service

Retrieve an existing Oracle GoldenGate Distribution Path Statistics

get

/services/{version}/sources/{distpath}/stats

Required Role: User

Retrieve an existing Oracle GoldenGate Distribution Path Statistics

Request

Path Parameters
Back to Top

Response

Supported Media Types

200 Response

Body ()
Root Schema : Oracle GoldenGate Distribution Path Statistics
Type: object
Title: Oracle GoldenGate Distribution Path Statistics
Show Source
Nested Schema : chunkStats
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 2147483647
Show Source
Nested Schema : netStats
Type: object
Show Source
Nested Schema : stats
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 6
Show Source
Nested Schema : tableStats
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 2147483647
Show Source
Nested Schema : tableStatsDaily
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 2147483647
Show Source
Nested Schema : tableStatsHourly
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 2147483647
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : localAddress
Type: object
Show Source
Nested Schema : remoteAddress
Type: object
Show Source
Nested Schema : host
Match One
Show Source
  • Minimum Length: 1
    Maximum Length: 4095
    Pattern: ^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$
    Network host name
  • host-x-oneOf[1]
    Network IP address
Nested Schema : port
Match One
Show Source
  • Minimum Value: 1
    Maximum Value: 65535
  • Minimum Value: 0
    Maximum Value: 0
Nested Schema : host-x-oneOf[1]
Network IP address
Match One
Show Source
  • Minimum Length: 7
    Maximum Length: 15
    Pattern: ^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$
    Network IPv4 address
  • Minimum Length: 1
    Maximum Length: 256
    Pattern: ^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$
    Network IPv6 address
Nested Schema : host
Match One
Show Source
  • Minimum Length: 1
    Maximum Length: 4095
    Pattern: ^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$
    Network host name
  • host-x-oneOf[1]
    Network IP address
Nested Schema : port
Match One
Show Source
  • Minimum Value: 1
    Maximum Value: 65535
  • Minimum Value: 0
    Maximum Value: 0
Nested Schema : host-x-oneOf[1]
Network IP address
Match One
Show Source
  • Minimum Length: 7
    Maximum Length: 15
    Pattern: ^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$
    Network IPv4 address
  • Minimum Length: 1
    Maximum Length: 256
    Pattern: ^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$
    Network IPv6 address
Nested Schema : items
Match Any
Show Source
Nested Schema : items-x-anyOf[0]
Type: object
Show Source
Nested Schema : items-x-anyOf[1]
Type: object
Show Source
Nested Schema : items-x-anyOf[2]
Type: object
Show Source
Nested Schema : items-x-anyOf[3]
Type: object
Show Source
Nested Schema : items-x-anyOf[4]
Type: object
Show Source
Nested Schema : items-x-anyOf[5]
Type: object
Show Source
Nested Schema : operations
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 16
Show Source
Nested Schema : since
Match One
Show Source
  • Minimum Length: 20
    Maximum Length: 32
    Pattern: ^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$
  • Allowed Values: [ "startup" ]
Nested Schema : items
Type: object
Show Source
Nested Schema : operation
Match One
Show Source
  • Allowed Values: [ "mapped", "unmapped", "default", "excluded" ]
Nested Schema : operations
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 16
Show Source
Nested Schema : since
Match One
Show Source
  • Minimum Length: 20
    Maximum Length: 32
    Pattern: ^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$
  • Allowed Values: [ "startup" ]
Nested Schema : sourceTable
Match Any
Show Source
Nested Schema : sqlexecOperations
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 2147483647
Show Source
Nested Schema : targetTable
Match Any
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : operation
Match Any
Show Source
  • Allowed Values: [ "insert", "update", "before", "alterBefore", "delete", "upsert", "unsupported", "drop", "truncate", "discard", "ignore", "marker", "operations", "insertCollision", "updateCollision", "deleteCollision" ]
  • Allowed Values: [ "cdrConflict", "cdrSuccess", "cdrFailure", "cdrConflictInsertExists", "cdrConflictUpdateExists", "cdrConflictUpdateMissing", "cdrConflictDeleteExists", "cdrConflictDeleteMissing" ]
  • Allowed Values: [ "fetchAttempt", "fetchFailed", "fetchDup", "fetchSnapshotByRowid", "fetchSnapshotByKey", "fetchByRowid", "fetchByKey", "fetchMissingSnapshotByRowid", "fetchMissingSnapshotByKey", "fetchMissingByRowid", "fetchMissingByKey", "fetchSnapshotInconsistent", "fetchInconsistent", "nofetch" ]
  • Allowed Values: [ "conversionFailure", "truncationFailure" ]
Nested Schema : sourceTable-x-anyOf[1]
Match Any
Show Source
  • Minimum Length: 3
    Maximum Length: 261
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
  • Minimum Length: 5
    Maximum Length: 392
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
Nested Schema : items
Type: object
Show Source
Nested Schema : name
Match Any
Show Source
Nested Schema : name-x-anyOf[1]
Match Any
Show Source
  • Minimum Length: 3
    Maximum Length: 261
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
  • Minimum Length: 5
    Maximum Length: 392
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
Nested Schema : targetTable-x-anyOf[1]
Match Any
Show Source
  • Minimum Length: 3
    Maximum Length: 261
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
  • Minimum Length: 5
    Maximum Length: 392
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
Nested Schema : operations
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 17
Show Source
Nested Schema : since
Match One
Show Source
  • Minimum Length: 20
    Maximum Length: 32
    Pattern: ^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$
  • Allowed Values: [ "startup" ]
Nested Schema : items
Type: object
Show Source
Nested Schema : operation
Match Any
Show Source
  • Allowed Values: [ "execution" ]
  • Allowed Values: [ "insert", "update", "before", "alterBefore", "delete", "upsert", "unsupported", "drop", "truncate", "discard", "ignore", "marker", "operations", "insertCollision", "updateCollision", "deleteCollision" ]
  • Allowed Values: [ "conversionFailure", "truncationFailure" ]
Nested Schema : operations
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 16
Show Source
Nested Schema : since
Match One
Show Source
  • Minimum Length: 20
    Maximum Length: 32
    Pattern: ^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$
  • Allowed Values: [ "startup" ]
Nested Schema : items
Type: object
Show Source
Nested Schema : operation
Match One
Show Source
  • Allowed Values: [ "transactions", "redirected", "replicatedProcedures", "ddlOperations", "storedProcedures", "datatypeFunctionality", "optypeFunctionality", "eventActions", "databaseCompatibility", "directTransactionRatio" ]
Nested Schema : operations
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 16
Show Source
Nested Schema : since
Match One
Show Source
  • Minimum Length: 20
    Maximum Length: 32
    Pattern: ^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$
  • Allowed Values: [ "startup" ]
Nested Schema : items
Type: object
Show Source
Nested Schema : operation
Match One
Show Source
  • Allowed Values: [ "ddlOperations", "primaryKeyUpdates", "emiTransactions", "userDefinedBarriers", "metadataBarriers", "lagGap" ]
Nested Schema : operations
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 16
Show Source
Nested Schema : since
Match One
Show Source
  • Minimum Length: 20
    Maximum Length: 32
    Pattern: ^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$
  • Allowed Values: [ "startup" ]
Nested Schema : tableDependencyStats
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 2147483647
Show Source
Nested Schema : tableWatermarkDependencyCounts
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 2147483647
Show Source
Nested Schema : workloadDependencyStats
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 3
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : operation
Match One
Show Source
  • Allowed Values: [ "transactions", "invalidIndexOperations", "splitTransactions", "splitAvgChunks", "splitAvgRows", "serializeTransactions", "largeTransactions", "largeAvgRows", "largeAvgChunks", "missingDepColumns", "nonNativeSupport", "maxSchedulingConstraints", "metadataBarriers", "ddlOperations", "sequenceOperations", "replicatedProcedures", "eventActions", "storedProcedures", "synchronous", "errorFallback" ]
Nested Schema : items
Type: object
Show Source
Nested Schema : childTable
Match Any
Show Source
Nested Schema : parentTable
Match Any
Show Source
Nested Schema : childTable-x-anyOf[1]
Match Any
Show Source
  • Minimum Length: 3
    Maximum Length: 261
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
  • Minimum Length: 5
    Maximum Length: 392
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
Nested Schema : parentTable-x-anyOf[1]
Match Any
Show Source
  • Minimum Length: 3
    Maximum Length: 261
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
  • Minimum Length: 5
    Maximum Length: 392
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
Nested Schema : items
Type: object
Show Source
Nested Schema : parentTable
Table with dependency constraint
Match Any
Show Source
Nested Schema : parentTable-x-anyOf[1]
Match Any
Show Source
  • Minimum Length: 3
    Maximum Length: 261
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
  • Minimum Length: 5
    Maximum Length: 392
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
Nested Schema : items
Type: object
Show Source
Nested Schema : operation
Match One
Show Source
  • Allowed Values: [ "foreignKeyParentRowDeletes", "tableLevelDependencies", "virtualColumnDependencies" ]
Nested Schema : items
Type: object
Show Source
Nested Schema : tableName
Match Any
Show Source
Nested Schema : tableName-x-anyOf[1]
Match Any
Show Source
  • Minimum Length: 3
    Maximum Length: 261
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
  • Minimum Length: 5
    Maximum Length: 392
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
Nested Schema : items
Type: object
Show Source
Nested Schema : tableName
Match Any
Show Source
Nested Schema : tableName-x-anyOf[1]
Match Any
Show Source
  • Minimum Length: 3
    Maximum Length: 261
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
  • Minimum Length: 5
    Maximum Length: 392
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
Nested Schema : items
Type: object
Show Source
Nested Schema : tableName
Match Any
Show Source
Nested Schema : tableName-x-anyOf[1]
Match Any
Show Source
  • Minimum Length: 3
    Maximum Length: 261
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
  • Minimum Length: 5
    Maximum Length: 392
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
Example Response (application/json)
{
    "$schema":"api:standardResponse",
    "response":{
        "$schema":"ogg:distPathStats",
        "lcrReceived":"121101",
        "lcrSent":"102131",
        "stats":[
            {
                "ddl":true,
                "since":"2015-05-04T09:50:11Z",
                "operations":[
                    {
                        "operation":"mapped",
                        "count":"1"
                    },
                    {
                        "operation":"unmapped",
                        "count":"2"
                    }
                ]
            },
            {
                "table":"ggadmin.Test",
                "since":"2015-05-04T09:50:11Z",
                "operations":[
                    {
                        "operation":"insert",
                        "count":"4"
                    },
                    {
                        "operation":"update",
                        "count":"2"
                    },
                    {
                        "operation":"delete",
                        "count":"1"
                    }
                ]
            }
        ],
        "netStats":{
            "localAddress":{
                "adc000001":"7810"
            },
            "remoteAddress":{
                "adc000002":"7811"
            },
            "totalBytesReceived":"10800",
            "totalBytesSent":"9000",
            "totalMsgsReceived":"10",
            "totalMsgsSent":"5"
        }
    },
    "messages":[
    ],
    "links":[
    ]
}
Back to Top