Retrieve an existing Extract Database Statistics
get
/services/{version}/mpoints/{item}/statisticsExtract
Required Role: User
Retrieve an existing Extract Database 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 Extract process statistics
Type:
objectTitle:
Show Source
Oracle GoldenGate Extract process statistics-
$schema:
Allowed Values:
[ "mpoints:statisticsExtract" ] -
mappedTotalDeletes:
integer
Minimum Value:
0Maximum Value:9223372036854776000DELETE operations performed -
mappedTotalInserts:
integer
Minimum Value:
0Maximum Value:9223372036854776000INSERT operations performed -
mappedTotalTruncates:
integer
Minimum Value:
0Maximum Value:9223372036854776000TRUNCATE operations performed -
mappedTotalUnsupported:
integer
Minimum Value:
0Maximum Value:9223372036854776000UNSUPPORTED operations performed -
mappedTotalUpdates:
integer
Minimum Value:
0Maximum Value:9223372036854776000UPDATE operations performed -
mappedTotalUpserts:
integer
Minimum Value:
0Maximum Value:9223372036854776000UPSERT operations performed -
totalConversionErrors:
integer
Minimum Value:
0Maximum Value:9223372036854776000Number of character conversion errors -
totalConversionTruncates:
integer
Minimum Value:
0Maximum Value:9223372036854776000Number of character conversion truncations -
totalDiscards:
integer
Minimum Value:
0Maximum Value:9223372036854776000Number of operations discarded -
totalExecutedDdls:
integer
Minimum Value:
0Maximum Value:9223372036854776000DDL operations performed -
totalExecutedProcedures:
integer
Minimum Value:
0Maximum Value:9223372036854776000Procedures operations performed -
totalIgnores:
integer
Minimum Value:
0Maximum Value:9223372036854776000Number of errors ignored -
totalMetadataRecords:
integer
Minimum Value:
0Maximum Value:9223372036854776000Metadata records written to trail -
totalRowFetchAttempts:
integer
Minimum Value:
0Maximum Value:9223372036854776000Attempts to fetch from DBMS -
totalRowFetchFailures:
integer
Minimum Value:
0Maximum Value:9223372036854776000Failed fetch attempts
Example Response (application/json)
{
"$schema":"api:standardResponse",
"response":{
"totalIgnores":"0",
"totalDiscards":"0",
"mappedTotalInserts":"0",
"totalConversionErrors":"0",
"$schema":"mpoints:statisticsExtract",
"totalConversionTruncates":"0",
"totalExecutedDdls":"0",
"mappedTotalDeletes":"0",
"totalRowFetchAttempts":"0",
"totalRowFetchFailures":"0",
"mappedTotalTruncates":"0",
"mappedTotalUpdates":"0",
"totalMetadataRecords":"0"
},
"messages":[
],
"links":[
]
}