Retrieve an existing Replicat Database Statistics by Table
get
/services/{version}/mpoints/{item}/statisticsTableReplicat
Request
Path Parameters
-
item: string
Minimum Length:
1Maximum 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:
objectTitle:
Show Source
Oracle GoldenGate Replicat table statistics-
$schema(optional):
Allowed Values:
[ "mpoints:statisticsTableReplicat" ] -
statisticsTableReplicat(optional):
array statisticsTableReplicat
Minimum Number of Items:
0Maximum Number of Items:2147483647
Nested Schema : statisticsTableReplicat
Type:
arrayMinimum Number of Items:
0Maximum Number of Items:
Show Source
2147483647Nested Schema : items
Type:
Show Source
object-
mappedTotalDeletes(optional):
integer
Minimum Value:
0Maximum Value:9.223372036854776E18DELETE operations performed -
mappedTotalInserts(optional):
integer
Minimum Value:
0Maximum Value:9.223372036854776E18INSERT operations performed -
mappedTotalTruncates(optional):
integer
Minimum Value:
0Maximum Value:9.223372036854776E18TRUNCATE operations performed -
mappedTotalUnsupported(optional):
integer
Minimum Value:
0Maximum Value:9.223372036854776E18UNSUPPORTED operations performed -
mappedTotalUpdates(optional):
integer
Minimum Value:
0Maximum Value:9.223372036854776E18UPDATE operations performed -
mappedTotalUpserts(optional):
integer
Minimum Value:
0Maximum Value:9.223372036854776E18UPSERT operations performed -
tableName(optional):
string
Minimum Length:
1Maximum Length:1024Table Name -
targetTableName(optional):
string
Minimum Length:
1Maximum Length:1024Target_Table Name -
totalConflictsDetected(optional):
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total Apply Conflicts -
totalConflictsFailed(optional):
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total Conflicts that Failed Automatic Resolution -
totalConflictsResolved(optional):
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total Conflicts Automatically Resolved -
totalDeleteRowExists(optional):
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Number of DB conflicts of the type delete row exists -
totalDeleteRowMissing(optional):
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Number of DB conflicts of the type delete row missing -
totalDiscards(optional):
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Number of operations discarded -
totalIgnores(optional):
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Number of errors ignored -
totalInsertRowExists(optional):
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Number of DB conflicts of the type insert row exists -
totalUpdateRowExists(optional):
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Number of DB conflicts of the type update row exists -
totalUpdateRowMissing(optional):
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Number 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":[
]
}