Retrieve an existing Distribution Server Table Statistics
get
/services/{version}/mpoints/{item}/distsrvrTableStats
Request
Path Parameters
-
item: string
Minimum Length:
1
Maximum Length:32
-
version: string
Oracle GoldenGate Service API version.
Allowed Values:[ "v2" ]
Response
Supported Media Types
- application/json
200 Response
Root Schema : Oracle GoldenGate Distribution Server Table statistics
Type:
object
Title:
Show Source
Oracle GoldenGate Distribution Server Table statistics
-
$schema(optional):
Allowed Values:
[ "mpoints:distsrvrTableStats" ]
-
statistics:
array statistics
Minimum Number of Items:
0
Maximum Number of Items:2147483647
Nested Schema : statistics
Type:
array
Minimum Number of Items:
0
Maximum Number of Items:
Show Source
2147483647
Nested Schema : items
Type:
Show Source
object
-
name(optional):
string
Minimum Length:
1
Maximum Length:240
Path Name -
stats(optional):
object stats
Nested Schema : stats
Type:
Show Source
object
-
$schema(optional):
Allowed Values:
[ "ogg:distPathTableStats" ]
-
deletes(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
-
inserts(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
-
lcrReceived:
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
-
lcrSent:
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
-
other(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
-
tableName:
tableName
-
truncates(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
-
unsupported(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
-
updates(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
-
upserts(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
Nested Schema : tableName
Match Any
Show Source
-
string
Minimum Length:
1
Maximum Length:130
Pattern:^([^.*?"]{1,128}|["].{1,128}["])$
-
tableName-x-anyOf[1]
Example Response (application/json)
{
"$schema":"api:standardResponse",
"response":{
"$schema":"mpoints:distsrvrTableStats",
"statistics":[
{
"totalInserts":10,
"tableName":"U1.ACCOUNT",
"totalOthers":2,
"name":"PROD.PATH.1",
"totalDeletes":30,
"lcrsReceived":96,
"totalDDLs":0,
"totalProcedures":0,
"totalUpdates":20,
"lcrsSent":10
},
{
"totalInserts":10,
"tableName":"U1.CUSTOMER",
"totalOthers":2,
"name":"PROD.PATH.1",
"totalDeletes":30,
"lcrsReceived":96,
"totalDDLs":0,
"totalProcedures":0,
"totalUpdates":20,
"lcrsSent":10
},
{
"totalInserts":5,
"tableName":"U1.ACCOUNT",
"totalOthers":1,
"name":"PROD.PATH.2",
"totalDeletes":0,
"lcrsReceived":43,
"totalDDLs":0,
"totalProcedures":0,
"totalUpdates":2,
"lcrsSent":15
},
{
"totalInserts":5,
"tableName":"U1.CUSTOMER",
"totalOthers":1,
"name":"PROD.PATH.2",
"totalDeletes":0,
"lcrsReceived":43,
"totalDDLs":0,
"totalProcedures":0,
"totalUpdates":2,
"lcrsSent":15
}
]
},
"messages":[
],
"links":[
]
}