Oracle GoldenGate

Retrieve an existing Queue Statistics

get

/services/{version}/mpoints/{item}/queueStatistics

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 Queue statistics

Type: object

Title: Oracle GoldenGate Queue statistics

Show Source

$schema:

Allowed Values: [ "mpoints:queueStatistics" ]
queueStatistics: array queueStatistics

Minimum Number of Items: 0

Maximum Number of Items: 2147483647

{
    "title":"Oracle GoldenGate Queue statistics",
    "type":"object",
    "properties":{
        "$schema":{
            "enum":[
                "mpoints:queueStatistics"
            ]
        },
        "queueStatistics":{
            "type":"array",
            "minItems":0,
            "maxItems":2147483647,
            "items":{
                "type":"object",
                "properties":{
                    "queueReadWaits":{
                        "description":"Queue Reads resulting in a wait",
                        "type":"integer",
                        "minimum":0,
                        "maximum":9.223372036854776E18
                    },
                    "queueWrites":{
                        "description":"Queue Writes",
                        "type":"integer",
                        "minimum":0,
                        "maximum":9.223372036854776E18
                    },
                    "threadId":{
                        "description":"Owning Thread id",
                        "type":"integer",
                        "minimum":0,
                        "maximum":9.223372036854776E18
                    },
                    "queueReadsSignaled":{
                        "description":"Queue Read Waits that were signaled",
                        "type":"integer",
                        "minimum":0,
                        "maximum":9.223372036854776E18
                    },
                    "queueMaxSize":{
                        "description":"Max Size of the Queue",
                        "type":"integer",
                        "minimum":0,
                        "maximum":9.223372036854776E18
                    },
                    "queueName":{
                        "description":"Queue Name",
                        "type":"string",
                        "minLength":1,
                        "maxLength":1024
                    },
                    "queueReads":{
                        "description":"Queue Reads",
                        "type":"integer",
                        "minimum":0,
                        "maximum":9.223372036854776E18
                    },
                    "queueWriteWaits":{
                        "description":"Queue Writes resulting in a wait",
                        "type":"integer",
                        "minimum":0,
                        "maximum":9.223372036854776E18
                    },
                    "queueWritesSignaled":{
                        "description":"Queue Write Waits that were signaled",
                        "type":"integer",
                        "minimum":0,
                        "maximum":9.223372036854776E18
                    },
                    "queueItems":{
                        "description":"Items in the Queue",
                        "type":"integer",
                        "minimum":0,
                        "maximum":9.223372036854776E18
                    },
                    "queueCurrentSize":{
                        "description":"Current Size of the Queue",
                        "type":"integer",
                        "minimum":0,
                        "maximum":9.223372036854776E18
                    }
                },
                "additionalProperties":false
            }
        }
    },
    "additionalProperties":false
}

Nested Schema : queueStatistics

Type: array

Minimum Number of Items: 0

Maximum Number of Items: 2147483647

Show Source

[0]: object items

{
    "type":"array",
    "minItems":0,
    "maxItems":2147483647,
    "items":{
        "type":"object",
        "properties":{
            "queueReadWaits":{
                "description":"Queue Reads resulting in a wait",
                "type":"integer",
                "minimum":0,
                "maximum":9.223372036854776E18
            },
            "queueWrites":{
                "description":"Queue Writes",
                "type":"integer",
                "minimum":0,
                "maximum":9.223372036854776E18
            },
            "threadId":{
                "description":"Owning Thread id",
                "type":"integer",
                "minimum":0,
                "maximum":9.223372036854776E18
            },
            "queueReadsSignaled":{
                "description":"Queue Read Waits that were signaled",
                "type":"integer",
                "minimum":0,
                "maximum":9.223372036854776E18
            },
            "queueMaxSize":{
                "description":"Max Size of the Queue",
                "type":"integer",
                "minimum":0,
                "maximum":9.223372036854776E18
            },
            "queueName":{
                "description":"Queue Name",
                "type":"string",
                "minLength":1,
                "maxLength":1024
            },
            "queueReads":{
                "description":"Queue Reads",
                "type":"integer",
                "minimum":0,
                "maximum":9.223372036854776E18
            },
            "queueWriteWaits":{
                "description":"Queue Writes resulting in a wait",
                "type":"integer",
                "minimum":0,
                "maximum":9.223372036854776E18
            },
            "queueWritesSignaled":{
                "description":"Queue Write Waits that were signaled",
                "type":"integer",
                "minimum":0,
                "maximum":9.223372036854776E18
            },
            "queueItems":{
                "description":"Items in the Queue",
                "type":"integer",
                "minimum":0,
                "maximum":9.223372036854776E18
            },
            "queueCurrentSize":{
                "description":"Current Size of the Queue",
                "type":"integer",
                "minimum":0,
                "maximum":9.223372036854776E18
            }
        },
        "additionalProperties":false
    }
}

Nested Schema : items

Type: object

Show Source

queueCurrentSize: integer

Minimum Value: 0

Maximum Value: 9.223372036854776E18

Current Size of the Queue
queueItems: integer

Minimum Value: 0

Maximum Value: 9.223372036854776E18

Items in the Queue
queueMaxSize: integer

Minimum Value: 0

Maximum Value: 9.223372036854776E18

Max Size of the Queue
queueName: string

Minimum Length: 1

Maximum Length: 1024

Queue Name
queueReads: integer

Minimum Value: 0

Maximum Value: 9.223372036854776E18

Queue Reads
queueReadsSignaled: integer

Minimum Value: 0

Maximum Value: 9.223372036854776E18

Queue Read Waits that were signaled
queueReadWaits: integer

Minimum Value: 0

Maximum Value: 9.223372036854776E18

Queue Reads resulting in a wait
queueWrites: integer

Minimum Value: 0

Maximum Value: 9.223372036854776E18

Queue Writes
queueWritesSignaled: integer

Minimum Value: 0

Maximum Value: 9.223372036854776E18

Queue Write Waits that were signaled
queueWriteWaits: integer

Minimum Value: 0

Maximum Value: 9.223372036854776E18

Queue Writes resulting in a wait
threadId: integer

Minimum Value: 0

Maximum Value: 9.223372036854776E18

Owning Thread id

{
    "type":"object",
    "properties":{
        "queueReadWaits":{
            "description":"Queue Reads resulting in a wait",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        },
        "queueWrites":{
            "description":"Queue Writes",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        },
        "threadId":{
            "description":"Owning Thread id",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        },
        "queueReadsSignaled":{
            "description":"Queue Read Waits that were signaled",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        },
        "queueMaxSize":{
            "description":"Max Size of the Queue",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        },
        "queueName":{
            "description":"Queue Name",
            "type":"string",
            "minLength":1,
            "maxLength":1024
        },
        "queueReads":{
            "description":"Queue Reads",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        },
        "queueWriteWaits":{
            "description":"Queue Writes resulting in a wait",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        },
        "queueWritesSignaled":{
            "description":"Queue Write Waits that were signaled",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        },
        "queueItems":{
            "description":"Items in the Queue",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        },
        "queueCurrentSize":{
            "description":"Current Size of the Queue",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        }
    },
    "additionalProperties":false
}

Example Response (application/json)

{
    "$schema":"api:standardResponse",
    "response":{
        "$schema":"mpoints:queueStatistics",
        "queueStatistics":[
            {
                "queueReadWaits":0,
                "queueWrites":55463,
                "threadId":21963,
                "queueReadsSignaled":0,
                "queueMaxSize":0,
                "queueName":"AsyncReader 1 Buffers",
                "queueReads":55460,
                "queueWriteWaits":0,
                "queueWritesSignaled":0,
                "queueItems":4,
                "queueCurrentSize":0
            },
            {
                "queueReadWaits":68118,
                "queueWrites":7721,
                "threadId":21964,
                "queueReadsSignaled":7720,
                "queueMaxSize":0,
                "queueName":"AsyncReader 1 Results",
                "queueReads":7721,
                "queueWriteWaits":0,
                "queueWritesSignaled":0,
                "queueItems":8,
                "queueCurrentSize":0
            },
            {
                "queueReadWaits":2,
                "queueWrites":14893,
                "threadId":21964,
                "queueReadsSignaled":13,
                "queueMaxSize":0,
                "queueName":"IXAsyncTrans Buffers",
                "queueReads":14594,
                "queueWriteWaits":0,
                "queueWritesSignaled":0,
                "queueItems":300,
                "queueCurrentSize":0
            },
            {
                "queueReadWaits":64436,
                "queueWrites":15567,
                "threadId":21964,
                "queueReadsSignaled":29,
                "queueMaxSize":3.4359738368E10,
                "queueName":"IXAsyncTrans Results",
                "queueReads":15567,
                "queueWriteWaits":0,
                "queueWritesSignaled":0,
                "queueItems":316,
                "queueCurrentSize":0
            }
        ]
    },
    "messages":[
    ],
    "links":[
    ]
}