Retrieve an existing Replicat Database Statistics by Table
get
/services/{version}/mpoints/{item}/statisticsTableReplicat
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 Replicat table statistics
Type:
object
Title:
Show Source
Oracle GoldenGate Replicat table statistics
-
$schema(optional):
Allowed Values:
[ "mpoints:statisticsTableReplicat" ]
-
statisticsTableReplicat(optional):
array statisticsTableReplicat
Minimum Number of Items:
0
Maximum Number of Items:2147483647
Nested Schema : statisticsTableReplicat
Type:
array
Minimum Number of Items:
0
Maximum Number of Items:
Show Source
2147483647
Nested Schema : items
Type:
Show Source
object
-
mappedTotalDeletes(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
DELETE operations performed -
mappedTotalInserts(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
INSERT operations performed -
mappedTotalTruncates(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
TRUNCATE operations performed -
mappedTotalUnsupported(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
UNSUPPORTED operations performed -
mappedTotalUpdates(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
UPDATE operations performed -
mappedTotalUpserts(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
UPSERT operations performed -
tableName(optional):
string
Minimum Length:
1
Maximum Length:1024
Table Name -
targetTableName(optional):
string
Minimum Length:
1
Maximum Length:1024
Target_Table Name -
totalConflictsDetected(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
Total Apply Conflicts -
totalConflictsFailed(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
Total Conflicts that Failed Automatic Resolution -
totalConflictsResolved(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
Total Conflicts Automatically Resolved -
totalDeleteRowExists(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
Number of DB conflicts of the type delete row exists -
totalDeleteRowMissing(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
Number of DB conflicts of the type delete row missing -
totalDiscards(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
Number of operations discarded -
totalIgnores(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
Number of errors ignored -
totalInsertRowExists(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
Number of DB conflicts of the type insert row exists -
totalUpdateRowExists(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
Number of DB conflicts of the type update row exists -
totalUpdateRowMissing(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
Number of DB conflicts of the type update row missing
Example Response (application/json)
{
"$schema":"api:standardResponse",
"response":{
"$schema":"mpoints:statisticsTableReplicat",
"statisticsTableReplicat":[
{
"totalIgnores":0,
"tableName":"U1.WAREHOUSE",
"totalConflictsResolved":0,
"totalDiscards":0,
"mappedTotalInserts":0,
"mappedTotalDeletes":0,
"totalConflictsFailed":0,
"mappedTotalTruncates":0,
"totalConflictsDetected":0,
"mappedTotalUpdates":186
},
{
"totalIgnores":0,
"tableName":"U1.STOCK",
"totalConflictsResolved":0,
"totalDiscards":0,
"mappedTotalInserts":0,
"mappedTotalDeletes":0,
"totalConflictsFailed":0,
"mappedTotalTruncates":0,
"totalConflictsDetected":0,
"mappedTotalUpdates":2076
},
{
"totalIgnores":0,
"tableName":"U1.OORDER",
"totalConflictsResolved":0,
"totalDiscards":0,
"mappedTotalInserts":200,
"mappedTotalDeletes":0,
"totalConflictsFailed":0,
"mappedTotalTruncates":0,
"totalConflictsDetected":0,
"mappedTotalUpdates":160
},
{
"totalIgnores":0,
"tableName":"U1.HISTORY",
"totalConflictsResolved":0,
"totalDiscards":0,
"mappedTotalInserts":186,
"mappedTotalDeletes":0,
"totalConflictsFailed":0,
"mappedTotalTruncates":0,
"totalConflictsDetected":0,
"mappedTotalUpdates":0
},
{
"totalIgnores":0,
"tableName":"U1.NEW_ORDER",
"totalConflictsResolved":0,
"totalDiscards":0,
"mappedTotalInserts":200,
"mappedTotalDeletes":160,
"totalConflictsFailed":0,
"mappedTotalTruncates":0,
"totalConflictsDetected":0,
"mappedTotalUpdates":0
},
{
"totalIgnores":0,
"tableName":"U1.ORDER_LINE",
"totalConflictsResolved":0,
"totalDiscards":0,
"mappedTotalInserts":2076,
"mappedTotalDeletes":0,
"totalConflictsFailed":0,
"mappedTotalTruncates":0,
"totalConflictsDetected":0,
"mappedTotalUpdates":1600
},
{
"totalIgnores":0,
"tableName":"U1.CUSTOMER",
"totalConflictsResolved":0,
"totalDiscards":0,
"mappedTotalInserts":0,
"mappedTotalDeletes":0,
"totalConflictsFailed":0,
"mappedTotalTruncates":0,
"totalConflictsDetected":0,
"mappedTotalUpdates":346
},
{
"totalIgnores":0,
"tableName":"U1.DISTRICT",
"totalConflictsResolved":0,
"totalDiscards":0,
"mappedTotalInserts":0,
"mappedTotalDeletes":0,
"totalConflictsFailed":0,
"mappedTotalTruncates":0,
"totalConflictsDetected":0,
"mappedTotalUpdates":386
}
]
},
"messages":[
],
"links":[
]
}