Retrieve an existing Integrated Replicat Batch SQL Statistics
get
/services/{version}/mpoints/{item}/batchSqlStatistics
Required Role: User
Retrieve an existing Integrated Replicat Batch SQL 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 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:9223372036854776000Number of Batch Thread Groups -
sqlQueues:
integer
Minimum Value:
0Maximum Value:9223372036854776000SQL Queues -
totalBatches:
integer
Minimum Value:
0Maximum Value:9223372036854776000Total Batches -
totalBatchesInError:
integer
Minimum Value:
0Maximum Value:9223372036854776000Total Batches in Error -
totalBatchExecutions:
integer
Minimum Value:
0Maximum Value:9223372036854776000Total Batch Executions -
totalBatchOperations:
integer
Minimum Value:
0Maximum Value:9223372036854776000Total Batch Operations -
totalCommits:
integer
Minimum Value:
0Maximum Value:9223372036854776000Total Commits -
totalDeleteTime:
integer
Minimum Value:
0Maximum Value:9223372036854776000Total Delete Time -
totalElapsedTime:
integer
Minimum Value:
0Maximum Value:9223372036854776000Total Elapsed Batch Time -
totalFlushes:
integer
Minimum Value:
0Maximum Value:9223372036854776000Total Flushes -
totalForeignKeyCollisions:
integer
Minimum Value:
0Maximum Value:9223372036854776000Total Foreign Key Collisions -
totalInsertTime:
integer
Minimum Value:
0Maximum Value:9223372036854776000Total Insert Time -
totalNormalModeOperations:
integer
Minimum Value:
0Maximum Value:9223372036854776000Total Normal Mode Operations -
totalOperationFlushes:
integer
Minimum Value:
0Maximum Value:9223372036854776000Total Operation Flushes -
totalPluFlushes:
integer
Minimum Value:
0Maximum Value:9223372036854776000Total PLU Flushes -
totalPrimaryKeyCollisions:
integer
Minimum Value:
0Maximum Value:9223372036854776000Total Primary Key Collisions -
totalRollbacks:
integer
Minimum Value:
0Maximum Value:9223372036854776000Total Rollbacks -
totalUniqueKeyCollisions:
integer
Minimum Value:
0Maximum Value:9223372036854776000Total Unique Key Collisions -
totalUpdateTime:
integer
Minimum Value:
0Maximum Value:9223372036854776000Total 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":[
]
}