Oracle GoldenGate

Retrieve an existing In Flight Transaction Information

get

/services/{version}/mpoints/{item}/currentInflightTransactions

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 Current In-Flight Transactions

Type: object

Title: Oracle GoldenGate Current In-Flight Transactions

Show Source

$schema:

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

Minimum Number of Items: 0

Maximum Number of Items: 2147483647

{
    "title":"Oracle GoldenGate Current In-Flight Transactions",
    "type":"object",
    "properties":{
        "$schema":{
            "enum":[
                "mpoints:currentInflightTransactions"
            ]
        },
        "currentInflightTransactions":{
            "type":"array",
            "minItems":0,
            "maxItems":2147483647,
            "items":{
                "type":"object",
                "properties":{
                    "scn":{
                        "description":"SCN Number",
                        "x-oneOf":[
                            {
                                "description":"Normal format",
                                "type":"integer",
                                "minimum":1,
                                "maximum":9.223372036854776E18
                            },
                            {
                                "description":"Alternate format",
                                "type":"string",
                                "pattern":"[0-9]+[.][0-9]+",
                                "minLength":3,
                                "maxLength":64
                            }
                        ]
                    },
                    "xid":{
                        "description":"Transaction ID",
                        "type":"string",
                        "minLength":1,
                        "maxLength":16
                    },
                    "startTime":{
                        "description":"Transaction start time",
                        "type":"string",
                        "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])$",
                        "minLength":20,
                        "maxLength":32
                    },
                    "extract":{
                        "description":"Extract Name",
                        "type":"string",
                        "minLength":1,
                        "maxLength":16
                    },
                    "status":{
                        "description":"Transaction status",
                        "type":"string",
                        "minLength":1,
                        "maxLength":16
                    },
                    "redoRba":{
                        "description":"Redo RBA",
                        "type":"integer",
                        "minimum":0,
                        "maximum":4.294967295E9
                    },
                    "redoSeq":{
                        "description":"Redo Sequence Number",
                        "type":"integer",
                        "minimum":0,
                        "maximum":4.294967295E9
                    },
                    "size":{
                        "description":"Number of items in transaction",
                        "type":"integer",
                        "minimum":0,
                        "maximum":4.294967295E9
                    },
                    "redoThread":{
                        "description":"Redo Thread ID",
                        "type":"integer",
                        "minimum":0,
                        "maximum":4.294967295E9
                    }
                },
                "additionalProperties":false
            }
        }
    },
    "additionalProperties":false
}

Nested Schema : currentInflightTransactions

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":{
            "scn":{
                "description":"SCN Number",
                "x-oneOf":[
                    {
                        "description":"Normal format",
                        "type":"integer",
                        "minimum":1,
                        "maximum":9.223372036854776E18
                    },
                    {
                        "description":"Alternate format",
                        "type":"string",
                        "pattern":"[0-9]+[.][0-9]+",
                        "minLength":3,
                        "maxLength":64
                    }
                ]
            },
            "xid":{
                "description":"Transaction ID",
                "type":"string",
                "minLength":1,
                "maxLength":16
            },
            "startTime":{
                "description":"Transaction start time",
                "type":"string",
                "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])$",
                "minLength":20,
                "maxLength":32
            },
            "extract":{
                "description":"Extract Name",
                "type":"string",
                "minLength":1,
                "maxLength":16
            },
            "status":{
                "description":"Transaction status",
                "type":"string",
                "minLength":1,
                "maxLength":16
            },
            "redoRba":{
                "description":"Redo RBA",
                "type":"integer",
                "minimum":0,
                "maximum":4.294967295E9
            },
            "redoSeq":{
                "description":"Redo Sequence Number",
                "type":"integer",
                "minimum":0,
                "maximum":4.294967295E9
            },
            "size":{
                "description":"Number of items in transaction",
                "type":"integer",
                "minimum":0,
                "maximum":4.294967295E9
            },
            "redoThread":{
                "description":"Redo Thread ID",
                "type":"integer",
                "minimum":0,
                "maximum":4.294967295E9
            }
        },
        "additionalProperties":false
    }
}

Nested Schema : items

Type: object

Show Source

extract: string

Minimum Length: 1

Maximum Length: 16

Extract Name
redoRba: integer

Minimum Value: 0

Maximum Value: 4.294967295E9

Redo RBA
redoSeq: integer

Minimum Value: 0

Maximum Value: 4.294967295E9

Redo Sequence Number
redoThread: integer

Minimum Value: 0

Maximum Value: 4.294967295E9

Redo Thread ID
scn: scn

SCN Number
size: integer

Minimum Value: 0

Maximum Value: 4.294967295E9

Number of items in transaction
startTime: 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])$

Transaction start time
status: string

Minimum Length: 1

Maximum Length: 16

Transaction status
xid: string

Minimum Length: 1

Maximum Length: 16

Transaction ID

{
    "type":"object",
    "properties":{
        "scn":{
            "description":"SCN Number",
            "x-oneOf":[
                {
                    "description":"Normal format",
                    "type":"integer",
                    "minimum":1,
                    "maximum":9.223372036854776E18
                },
                {
                    "description":"Alternate format",
                    "type":"string",
                    "pattern":"[0-9]+[.][0-9]+",
                    "minLength":3,
                    "maxLength":64
                }
            ]
        },
        "xid":{
            "description":"Transaction ID",
            "type":"string",
            "minLength":1,
            "maxLength":16
        },
        "startTime":{
            "description":"Transaction start time",
            "type":"string",
            "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])$",
            "minLength":20,
            "maxLength":32
        },
        "extract":{
            "description":"Extract Name",
            "type":"string",
            "minLength":1,
            "maxLength":16
        },
        "status":{
            "description":"Transaction status",
            "type":"string",
            "minLength":1,
            "maxLength":16
        },
        "redoRba":{
            "description":"Redo RBA",
            "type":"integer",
            "minimum":0,
            "maximum":4.294967295E9
        },
        "redoSeq":{
            "description":"Redo Sequence Number",
            "type":"integer",
            "minimum":0,
            "maximum":4.294967295E9
        },
        "size":{
            "description":"Number of items in transaction",
            "type":"integer",
            "minimum":0,
            "maximum":4.294967295E9
        },
        "redoThread":{
            "description":"Redo Thread ID",
            "type":"integer",
            "minimum":0,
            "maximum":4.294967295E9
        }
    },
    "additionalProperties":false
}

Nested Schema : scn

SCN Number

Match One

Show Source

integer

Minimum Value: 1

Maximum Value: 9.223372036854776E18

Normal format
string

Minimum Length: 3

Maximum Length: 64

Pattern: [0-9]+[.][0-9]+

Alternate format

{
    "description":"SCN Number",
    "x-oneOf":[
        {
            "description":"Normal format",
            "type":"integer",
            "minimum":1,
            "maximum":9.223372036854776E18
        },
        {
            "description":"Alternate format",
            "type":"string",
            "pattern":"[0-9]+[.][0-9]+",
            "minLength":3,
            "maxLength":64
        }
    ]
}

Example Response (application/json)

{
    "$schema":"api:standardResponse",
    "response":{
        "$schema":"mpoints:currentInflightTransactions",
        "currentInflightTransactions":[
            {
                "scn":"0.4080896",
                "xid":"1.6.1358",
                "startTime":"2015-06-11T11:21:31.011Z",
                "extract":"EORADB1",
                "status":"Running",
                "redoRba":11829476,
                "redoSeq":202,
                "size":3,
                "redoThread":1
            },
            {
                "scn":"0.4080898",
                "xid":"2.16.1835",
                "startTime":"2015-06-11T11:21:31.564Z",
                "extract":"EORADB1",
                "status":"Running",
                "redoRba":11830800,
                "redoSeq":202,
                "size":7,
                "redoThread":1
            }
        ]
    },
    "messages":[
    ],
    "links":[
    ]
}