Retrieve an existing Extract Database Statistics by Table
get
/services/{version}/mpoints/{item}/statisticsTableExtract
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 Extract table statistics
Type:
object
Title:
Show Source
Oracle GoldenGate Extract table statistics
-
$schema(optional):
Allowed Values:
[ "mpoints:statisticsTableExtract" ]
-
statisticsTableExtract(optional):
array statisticsTableExtract
Minimum Number of Items:
0
Maximum Number of Items:2147483647
Nested Schema : statisticsTableExtract
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 -
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 -
totalRowFetchAttempts(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
Attempts to fetch from DBMS -
totalRowFetchFailures(optional):
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
Failed fetch attempts
Example Response (application/json)
{
"$schema":"api:standardResponse",
"response":{
"$schema":"mpoints:statisticsTableExtract",
"statisticsTableExtract":[
{
"totalIgnores":0,
"tableName":"U1.WAREHOUSE",
"totalDiscards":0,
"mappedTotalInserts":0,
"mappedTotalDeletes":0,
"totalRowFetchAttempts":0,
"totalRowFetchFailures":0,
"mappedTotalTruncates":0,
"mappedTotalUpdates":96
},
{
"totalIgnores":0,
"tableName":"U1.DISTRICT",
"totalDiscards":0,
"mappedTotalInserts":0,
"mappedTotalDeletes":0,
"totalRowFetchAttempts":0,
"totalRowFetchFailures":0,
"mappedTotalTruncates":0,
"mappedTotalUpdates":200
},
{
"totalIgnores":0,
"tableName":"U1.CUSTOMER",
"totalDiscards":0,
"mappedTotalInserts":0,
"mappedTotalDeletes":0,
"totalRowFetchAttempts":0,
"totalRowFetchFailures":0,
"mappedTotalTruncates":0,
"mappedTotalUpdates":186
},
{
"totalIgnores":0,
"tableName":"U1.HISTORY",
"totalDiscards":0,
"mappedTotalInserts":96,
"mappedTotalDeletes":0,
"totalRowFetchAttempts":0,
"totalRowFetchFailures":0,
"mappedTotalTruncates":0,
"mappedTotalUpdates":0
},
{
"totalIgnores":0,
"tableName":"U1.NEW_ORDER",
"totalDiscards":0,
"mappedTotalInserts":104,
"mappedTotalDeletes":90,
"totalRowFetchAttempts":0,
"totalRowFetchFailures":0,
"mappedTotalTruncates":0,
"mappedTotalUpdates":0
},
{
"totalIgnores":0,
"tableName":"U1.OORDER",
"totalDiscards":0,
"mappedTotalInserts":104,
"mappedTotalDeletes":0,
"totalRowFetchAttempts":0,
"totalRowFetchFailures":0,
"mappedTotalTruncates":0,
"mappedTotalUpdates":90
},
{
"totalIgnores":0,
"tableName":"U1.ORDER_LINE",
"totalDiscards":0,
"mappedTotalInserts":1080,
"mappedTotalDeletes":0,
"totalRowFetchAttempts":0,
"totalRowFetchFailures":0,
"mappedTotalTruncates":0,
"mappedTotalUpdates":886
},
{
"totalIgnores":0,
"tableName":"U1.STOCK",
"totalDiscards":0,
"mappedTotalInserts":0,
"mappedTotalDeletes":0,
"totalRowFetchAttempts":0,
"totalRowFetchFailures":0,
"mappedTotalTruncates":0,
"mappedTotalUpdates":1080
}
]
},
"messages":[
],
"links":[
]
}