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:
1
Maximum 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:
object
Title:
Show Source
Oracle GoldenGate Batch SQL Statistics
-
$schema:
Allowed Values:
[ "mpoints:batchSqlStatistics" ]
-
lastTimestamp:
string
Minimum Length:
20
Maximum Length:32
Pattern:^[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:
0
Maximum Value:9223372036854776000
Number of Batch Thread Groups -
sqlQueues:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
SQL Queues -
totalBatches:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Total Batches -
totalBatchesInError:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Total Batches in Error -
totalBatchExecutions:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Total Batch Executions -
totalBatchOperations:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Total Batch Operations -
totalCommits:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Total Commits -
totalDeleteTime:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Total Delete Time -
totalElapsedTime:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Total Elapsed Batch Time -
totalFlushes:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Total Flushes -
totalForeignKeyCollisions:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Total Foreign Key Collisions -
totalInsertTime:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Total Insert Time -
totalNormalModeOperations:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Total Normal Mode Operations -
totalOperationFlushes:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Total Operation Flushes -
totalPluFlushes:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Total PLU Flushes -
totalPrimaryKeyCollisions:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Total Primary Key Collisions -
totalRollbacks:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Total Rollbacks -
totalUniqueKeyCollisions:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Total Unique Key Collisions -
totalUpdateTime:
integer
Minimum Value:
0
Maximum Value:9223372036854776000
Total 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":[
]
}