Retrieve an existing Integrated Replicat Batch SQL Statistics
get
/services/{version}/mpoints/{item}/batchSqlStatistics
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 Batch SQL Statistics
Type:
objectTitle:
Show Source
Oracle GoldenGate Batch SQL Statistics-
$schema:
Allowed Values:
[ "mpoints:batchSqlStatistics" ] -
lastTimestamp:
string
Minimum Length:
20Maximum Length:32Pattern:^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$Last Operation Timestamp -
numberOfBatchThreadGroups:
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Number of Batch Thread Groups -
sqlQueues:
integer
Minimum Value:
0Maximum Value:9.223372036854776E18SQL Queues -
totalBatches:
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total Batches -
totalBatchesInError:
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total Batches in Error -
totalBatchExecutions:
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total Batch Executions -
totalBatchOperations:
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total Batch Operations -
totalCommits:
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total Commits -
totalDeleteTime:
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total Delete Time -
totalElapsedTime:
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total Elapsed Batch Time -
totalFlushes:
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total Flushes -
totalForeignKeyCollisions:
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total Foreign Key Collisions -
totalInsertTime:
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total Insert Time -
totalNormalModeOperations:
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total Normal Mode Operations -
totalOperationFlushes:
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total Operation Flushes -
totalPluFlushes:
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total PLU Flushes -
totalPrimaryKeyCollisions:
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total Primary Key Collisions -
totalRollbacks:
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total Rollbacks -
totalUniqueKeyCollisions:
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total Unique Key Collisions -
totalUpdateTime:
integer
Minimum Value:
0Maximum Value:9.223372036854776E18Total Update Time
Example Response (application/json)
{
"$schema":"api:standardResponse",
"response":{
"totalBatchExecutions":10,
"totalCommits":0,
"totalForeignKeyCollisions":0,
"totalInsertTime":0,
"totalBatches":10,
"lastTimestamp":"2015-06-05T13:22:18.034Z",
"totalFlushes":0,
"totalBatchesInError":0,
"totalPrimaryKeyCollisions":0,
"sqlQueues":5,
"totalRollbacks":0,
"totalDeleteTime":12340,
"totalUpdateTime":0,
"$schema":"mpoints:batchSqlStatistics",
"totalBatchOperations":100,
"totalElapsedTime":12340,
"totalOperationFlushes":0,
"totalNormalModeOperations":0,
"totalUniqueKeyCollisions":0,
"totalPluFlushes":0,
"numberOfBatchThreadGroups":1
},
"messages":[
],
"links":[
]
}