Oracle GoldenGate REST API 21c (21.1.0)

アクティブなトランザクションの詳細の取得

get

/services/{version}/connections/{connection}/activeTransactions

データベース接続のアクティブなトランザクションの詳細を取得します。

リクエスト

パス・パラメータ

connection: string

最小長: 1

最大長: 61

パターン: ^[a-zA-Z][a-zA-Z0-9_#$]{1,29}([.][a-zA-Z][a-zA-Z0-9_#$]{1,29})?$

接続名。資格証明ストアの別名ごとに、domain.aliasという名前の接続が存在しています。
version: string

Oracle GoldenGateサービスのAPIバージョン。

指定できる値: [ "v2" ]

先頭に戻る

レスポンス

サポートされるメディア・タイプ

application/json

200レスポンス

アクティブなトランザクションの詳細が取得されました。

ルート・スキーマ: Oracle GoldenGate Database Active Transaction Details

型: object

タイトル: Oracle GoldenGate Database Active Transaction Details

ソースの表示

$schema(optional):

指定できる値: [ "ogg:activeTransactions" ]
activeTransactions(optional): array activeTransactions

最小アイテム数: 0

最大アイテム数: 32767

すべてのアクティブなトランザクションのリスト表示
currentScn: object currentScn

現在のデータベースSCNの詳細

{
    "title":"Oracle GoldenGate Database Active Transaction Details",
    "required":[
        "currentScn"
    ],
    "type":"object",
    "properties":{
        "$schema":{
            "enum":[
                "ogg:activeTransactions"
            ]
        },
        "currentScn":{
            "description":"Current database SCN details",
            "type":"object",
            "properties":{
                "csn":{
                    "description":"Transaction start SCN",
                    "x-oneOf":[
                        {
                            "description":"Normal format",
                            "type":"integer",
                            "minimum":0,
                            "maximum":9.223372036854776E18
                        },
                        {
                            "description":"Alternate format",
                            "type":"string",
                            "pattern":"[0-9]+[.][0-9]+",
                            "minLength":3,
                            "maxLength":64
                        }
                    ]
                },
                "currentDate":{
                    "description":"Start time of the transaction",
                    "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
                },
                "userName":{
                    "description":"Database username",
                    "type":"string",
                    "minLength":1,
                    "maxLength":4096
                }
            },
            "additionalProperties":false
        },
        "activeTransactions":{
            "description":"List of all active transactions",
            "type":"array",
            "items":{
                "type":"object",
                "properties":{
                    "sessionStatus":{
                        "description":"Status of transaction or a session",
                        "enum":[
                            "ACTIVE",
                            "IDLE",
                            "INACTIVE",
                            "KILLED",
                            "CACHED",
                            "SNIPED"
                        ]
                    },
                    "txnStartDate":{
                        "description":"Start time of the transaction",
                        "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
                    },
                    "userName":{
                        "description":"Oracle username",
                        "type":"string",
                        "minLength":1,
                        "maxLength":4096
                    },
                    "txnStatus":{
                        "description":"Status of transaction or a session",
                        "enum":[
                            "ACTIVE",
                            "IDLE",
                            "INACTIVE",
                            "KILLED",
                            "CACHED",
                            "SNIPED"
                        ]
                    },
                    "logonTime":{
                        "description":"Time of logon to the session",
                        "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
                    },
                    "serialNum":{
                        "description":"Session Serial Number",
                        "type":"integer",
                        "minimum":0,
                        "maximum":4.294967295E9
                    },
                    "txnStartScn":{
                        "description":"Transaction start SCN",
                        "x-oneOf":[
                            {
                                "description":"Normal format",
                                "type":"integer",
                                "minimum":0,
                                "maximum":9.223372036854776E18
                            },
                            {
                                "description":"Alternate format",
                                "type":"string",
                                "pattern":"[0-9]+[.][0-9]+",
                                "minLength":3,
                                "maxLength":64
                            }
                        ]
                    },
                    "osUser":{
                        "description":"Operating System client username",
                        "type":"string",
                        "minLength":1,
                        "maxLength":30
                    },
                    "instanceId":{
                        "description":"Instance identifier",
                        "type":"integer",
                        "minimum":0,
                        "maximum":4.294967295E9
                    },
                    "sid":{
                        "description":"Session identifier",
                        "type":"integer",
                        "minimum":0,
                        "maximum":4.294967295E9
                    }
                },
                "required":[
                    "txnStartScn",
                    "txnStatus",
                    "txnStartDate",
                    "sid",
                    "serialNum",
                    "instanceId",
                    "userName",
                    "osUser",
                    "sessionStatus",
                    "logonTime"
                ],
                "additionalProperties":false
            },
            "minItems":0,
            "maxItems":32767
        }
    },
    "additionalProperties":false
}

ネストされたスキーマ: activeTransactions

型: array

最小アイテム数: 0

最大アイテム数: 32767

すべてのアクティブなトランザクションのリスト表示

ソースの表示

配列: object items

{
    "description":"List of all active transactions",
    "type":"array",
    "items":{
        "type":"object",
        "properties":{
            "sessionStatus":{
                "description":"Status of transaction or a session",
                "enum":[
                    "ACTIVE",
                    "IDLE",
                    "INACTIVE",
                    "KILLED",
                    "CACHED",
                    "SNIPED"
                ]
            },
            "txnStartDate":{
                "description":"Start time of the transaction",
                "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
            },
            "userName":{
                "description":"Oracle username",
                "type":"string",
                "minLength":1,
                "maxLength":4096
            },
            "txnStatus":{
                "description":"Status of transaction or a session",
                "enum":[
                    "ACTIVE",
                    "IDLE",
                    "INACTIVE",
                    "KILLED",
                    "CACHED",
                    "SNIPED"
                ]
            },
            "logonTime":{
                "description":"Time of logon to the session",
                "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
            },
            "serialNum":{
                "description":"Session Serial Number",
                "type":"integer",
                "minimum":0,
                "maximum":4.294967295E9
            },
            "txnStartScn":{
                "description":"Transaction start SCN",
                "x-oneOf":[
                    {
                        "description":"Normal format",
                        "type":"integer",
                        "minimum":0,
                        "maximum":9.223372036854776E18
                    },
                    {
                        "description":"Alternate format",
                        "type":"string",
                        "pattern":"[0-9]+[.][0-9]+",
                        "minLength":3,
                        "maxLength":64
                    }
                ]
            },
            "osUser":{
                "description":"Operating System client username",
                "type":"string",
                "minLength":1,
                "maxLength":30
            },
            "instanceId":{
                "description":"Instance identifier",
                "type":"integer",
                "minimum":0,
                "maximum":4.294967295E9
            },
            "sid":{
                "description":"Session identifier",
                "type":"integer",
                "minimum":0,
                "maximum":4.294967295E9
            }
        },
        "required":[
            "txnStartScn",
            "txnStatus",
            "txnStartDate",
            "sid",
            "serialNum",
            "instanceId",
            "userName",
            "osUser",
            "sessionStatus",
            "logonTime"
        ],
        "additionalProperties":false
    },
    "minItems":0,
    "maxItems":32767
}

ネストされたスキーマ: currentScn

型: object

現在のデータベースSCNの詳細

ソースの表示

csn(optional): csn

トランザクション開始SCN
currentDate(optional): string

最小長: 20

最大長: 32

パターン: ^[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])$

トランザクションの開始時間
userName(optional): string

最小長: 1

最大長: 4096

データベース・ユーザー名

{
    "description":"Current database SCN details",
    "type":"object",
    "properties":{
        "csn":{
            "description":"Transaction start SCN",
            "x-oneOf":[
                {
                    "description":"Normal format",
                    "type":"integer",
                    "minimum":0,
                    "maximum":9.223372036854776E18
                },
                {
                    "description":"Alternate format",
                    "type":"string",
                    "pattern":"[0-9]+[.][0-9]+",
                    "minLength":3,
                    "maxLength":64
                }
            ]
        },
        "currentDate":{
            "description":"Start time of the transaction",
            "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
        },
        "userName":{
            "description":"Database username",
            "type":"string",
            "minLength":1,
            "maxLength":4096
        }
    },
    "additionalProperties":false
}

ネストされたスキーマ: items

型: object

ソースの表示

instanceId: integer

最小値: 0

最大値: 4.294967295E9

インスタンス識別子
logonTime: string

最小長: 20

最大長: 32

パターン: ^[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])$

セッションへのログオン時間
osUser: string

最小長: 1

最大長: 30

オペレーティング・システム・クライアント・ユーザー名
serialNum: integer

最小値: 0

最大値: 4.294967295E9

セッション・シリアル番号
sessionStatus:

指定できる値: [ "ACTIVE", "IDLE", "INACTIVE", "KILLED", "CACHED", "SNIPED" ]

トランザクションまたはセッションのステータス
sid: integer

最小値: 0

最大値: 4.294967295E9

セッション識別子
txnStartDate: string

最小長: 20

最大長: 32

パターン: ^[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])$

トランザクションの開始時間
txnStartScn: txnStartScn

トランザクション開始SCN
txnStatus:

指定できる値: [ "ACTIVE", "IDLE", "INACTIVE", "KILLED", "CACHED", "SNIPED" ]

トランザクションまたはセッションのステータス
userName: string

最小長: 1

最大長: 4096

Oracleユーザー名

{
    "type":"object",
    "properties":{
        "sessionStatus":{
            "description":"Status of transaction or a session",
            "enum":[
                "ACTIVE",
                "IDLE",
                "INACTIVE",
                "KILLED",
                "CACHED",
                "SNIPED"
            ]
        },
        "txnStartDate":{
            "description":"Start time of the transaction",
            "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
        },
        "userName":{
            "description":"Oracle username",
            "type":"string",
            "minLength":1,
            "maxLength":4096
        },
        "txnStatus":{
            "description":"Status of transaction or a session",
            "enum":[
                "ACTIVE",
                "IDLE",
                "INACTIVE",
                "KILLED",
                "CACHED",
                "SNIPED"
            ]
        },
        "logonTime":{
            "description":"Time of logon to the session",
            "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
        },
        "serialNum":{
            "description":"Session Serial Number",
            "type":"integer",
            "minimum":0,
            "maximum":4.294967295E9
        },
        "txnStartScn":{
            "description":"Transaction start SCN",
            "x-oneOf":[
                {
                    "description":"Normal format",
                    "type":"integer",
                    "minimum":0,
                    "maximum":9.223372036854776E18
                },
                {
                    "description":"Alternate format",
                    "type":"string",
                    "pattern":"[0-9]+[.][0-9]+",
                    "minLength":3,
                    "maxLength":64
                }
            ]
        },
        "osUser":{
            "description":"Operating System client username",
            "type":"string",
            "minLength":1,
            "maxLength":30
        },
        "instanceId":{
            "description":"Instance identifier",
            "type":"integer",
            "minimum":0,
            "maximum":4.294967295E9
        },
        "sid":{
            "description":"Session identifier",
            "type":"integer",
            "minimum":0,
            "maximum":4.294967295E9
        }
    },
    "required":[
        "txnStartScn",
        "txnStatus",
        "txnStartDate",
        "sid",
        "serialNum",
        "instanceId",
        "userName",
        "osUser",
        "sessionStatus",
        "logonTime"
    ],
    "additionalProperties":false
}

ネストされたスキーマ: txnStartScn

トランザクション開始SCN

1つに一致

ソースの表示

integer

最小値: 0

最大値: 9.223372036854776E18

標準の形式
string

最小長: 3

最大長: 64

パターン: [0-9]+[.][0-9]+

代替の形式

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

ネストされたスキーマ: csn

トランザクション開始SCN

1つに一致

ソースの表示

integer

最小値: 0

最大値: 9.223372036854776E18

標準の形式
string

最小長: 3

最大長: 64

パターン: [0-9]+[.][0-9]+

代替の形式

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

レスポンスの例(application/json)

{
    "$schema":"api:standardResponse",
    "links":[
        {
            "href":"http://localhost:11001/services/v2/connections/LocalDBMS/activeTransactions",
            "mediaType":"application/json",
            "rel":"canonical"
        },
        {
            "href":"http://localhost:11001/services/v2/connections/LocalDBMS/activeTransactions",
            "mediaType":"application/json",
            "rel":"self"
        },
        {
            "href":"http://localhost:11001/services/v2/metadata-catalog/activeTransactions",
            "mediaType":"application/schema+json",
            "rel":"describedby"
        }
    ],
    "messages":[
    ],
    "response":{
        "$schema":"ogg:activeTransactions",
        "activeTransactions":[
        ],
        "currentScn":{
            "csn":1542744,
            "currentDate":"2021-03-15T17:24:37.000Z",
            "userName":"SYS"
        }
    }
}

先頭に戻る