Retrieve an existing Distribution Server Table Statistics
get
/services/{version}/mpoints/{item}/distsrvrTableStats
Required Role: User
Retrieve an existing Distribution Server Table StatisticsRequest
Path Parameters
-
item(required): string
Minimum Length:
1Maximum Length:32 -
version(required): 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:
objectTitle:
Show Source
Oracle GoldenGate Distribution Server Table statistics-
$schema:
Allowed Values:
[ "mpoints:distsrvrTableStats" ] -
statistics(required):
array statistics
Minimum Number of Items:
0Maximum Number of Items:2147483647
Nested Schema : statistics
Type:
arrayMinimum Number of Items:
0Maximum Number of Items:
Show Source
2147483647Nested Schema : items
Type:
Show Source
object-
name:
string
Minimum Length:
1Maximum Length:240Path Name -
stats:
object stats
Nested Schema : stats
Type:
Show Source
object-
$schema:
Allowed Values:
[ "ogg:distPathTableStats" ] -
deletes:
integer
Minimum Value:
0Maximum Value:9223372036854776000 -
inserts:
integer
Minimum Value:
0Maximum Value:9223372036854776000 -
lcrReceived(required):
integer
Minimum Value:
0Maximum Value:9223372036854776000 -
lcrSent(required):
integer
Minimum Value:
0Maximum Value:9223372036854776000 -
other:
integer
Minimum Value:
0Maximum Value:9223372036854776000 -
tableName(required):
tableName
-
truncates:
integer
Minimum Value:
0Maximum Value:9223372036854776000 -
unsupported:
integer
Minimum Value:
0Maximum Value:9223372036854776000 -
updates:
integer
Minimum Value:
0Maximum Value:9223372036854776000 -
upserts:
integer
Minimum Value:
0Maximum Value:9223372036854776000
Nested Schema : tableName
Match Any
Show Source
-
string
Minimum Length:
1Maximum Length:130Pattern:^([^.*?"]{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":[
]
}