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