Oracle GoldenGate 23ai Microservices Architecture REST APIドキュメンテーション

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

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:

指定できる値: [ "ogg:activeTransactions" ]
activeTransactions: 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":"System Change Number(Normal Format) for Oracle Database.",
                            "type":"integer",
                            "minimum":"0",
                            "maximum":"9223372036854776000",
                            "example":"6488359"
                        },
                        {
                            "description":"System Change Number(Alternate Format) for Oracle Database.",
                            "type":"string",
                            "pattern":"[0-9]+[.][0-9]+",
                            "minLength":"3",
                            "maxLength":"64",
                            "example":"6488359.3456712"
                        }
                    ]
                },
                "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":"4294967295"
                    },
                    "txnStartScn":{
                        "description":"Transaction start SCN",
                        "x-oneOf":[
                            {
                                "description":"System Change Number(Normal Format) for Oracle Database.",
                                "type":"integer",
                                "minimum":"0",
                                "maximum":"9223372036854776000",
                                "example":"6488359"
                            },
                            {
                                "description":"System Change Number(Alternate Format) for Oracle Database.",
                                "type":"string",
                                "pattern":"[0-9]+[.][0-9]+",
                                "minLength":"3",
                                "maxLength":"64",
                                "example":"6488359.3456712"
                            }
                        ]
                    },
                    "osUser":{
                        "description":"Operating System client username",
                        "type":"string",
                        "minLength":"1",
                        "maxLength":"30"
                    },
                    "instanceId":{
                        "description":"Instance identifier",
                        "type":"integer",
                        "minimum":"0",
                        "maximum":"4294967295"
                    },
                    "sid":{
                        "description":"Session identifier",
                        "type":"integer",
                        "minimum":"0",
                        "maximum":"4294967295"
                    }
                },
                "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":"4294967295"
            },
            "txnStartScn":{
                "description":"Transaction start SCN",
                "x-oneOf":[
                    {
                        "description":"System Change Number(Normal Format) for Oracle Database.",
                        "type":"integer",
                        "minimum":"0",
                        "maximum":"9223372036854776000",
                        "example":"6488359"
                    },
                    {
                        "description":"System Change Number(Alternate Format) for Oracle Database.",
                        "type":"string",
                        "pattern":"[0-9]+[.][0-9]+",
                        "minLength":"3",
                        "maxLength":"64",
                        "example":"6488359.3456712"
                    }
                ]
            },
            "osUser":{
                "description":"Operating System client username",
                "type":"string",
                "minLength":"1",
                "maxLength":"30"
            },
            "instanceId":{
                "description":"Instance identifier",
                "type":"integer",
                "minimum":"0",
                "maximum":"4294967295"
            },
            "sid":{
                "description":"Session identifier",
                "type":"integer",
                "minimum":"0",
                "maximum":"4294967295"
            }
        },
        "required":[
            "txnStartScn",
            "txnStatus",
            "txnStartDate",
            "sid",
            "serialNum",
            "instanceId",
            "userName",
            "osUser",
            "sessionStatus",
            "logonTime"
        ],
        "additionalProperties":false
    },
    "minItems":"0",
    "maxItems":"32767"
}

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

型: object

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

ソースの表示

csn: csn

トランザクション開始SCN
currentDate: 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: string

最小長: 1

最大長: 4096

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

{
    "description":"Current database SCN details",
    "type":"object",
    "properties":{
        "csn":{
            "description":"Transaction start SCN",
            "x-oneOf":[
                {
                    "description":"System Change Number(Normal Format) for Oracle Database.",
                    "type":"integer",
                    "minimum":"0",
                    "maximum":"9223372036854776000",
                    "example":"6488359"
                },
                {
                    "description":"System Change Number(Alternate Format) for Oracle Database.",
                    "type":"string",
                    "pattern":"[0-9]+[.][0-9]+",
                    "minLength":"3",
                    "maxLength":"64",
                    "example":"6488359.3456712"
                }
            ]
        },
        "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

最大値: 4294967295

インスタンス識別子
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

最大値: 4294967295

セッション・シリアル番号
sessionStatus(必須):

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

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

最小値: 0

最大値: 4294967295

セッション識別子
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":"4294967295"
        },
        "txnStartScn":{
            "description":"Transaction start SCN",
            "x-oneOf":[
                {
                    "description":"System Change Number(Normal Format) for Oracle Database.",
                    "type":"integer",
                    "minimum":"0",
                    "maximum":"9223372036854776000",
                    "example":"6488359"
                },
                {
                    "description":"System Change Number(Alternate Format) for Oracle Database.",
                    "type":"string",
                    "pattern":"[0-9]+[.][0-9]+",
                    "minLength":"3",
                    "maxLength":"64",
                    "example":"6488359.3456712"
                }
            ]
        },
        "osUser":{
            "description":"Operating System client username",
            "type":"string",
            "minLength":"1",
            "maxLength":"30"
        },
        "instanceId":{
            "description":"Instance identifier",
            "type":"integer",
            "minimum":"0",
            "maximum":"4294967295"
        },
        "sid":{
            "description":"Session identifier",
            "type":"integer",
            "minimum":"0",
            "maximum":"4294967295"
        }
    },
    "required":[
        "txnStartScn",
        "txnStatus",
        "txnStartDate",
        "sid",
        "serialNum",
        "instanceId",
        "userName",
        "osUser",
        "sessionStatus",
        "logonTime"
    ],
    "additionalProperties":false
}

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

トランザクション開始SCN

1つに一致

ソースの表示

integer

最小値: 0

最大値: 9223372036854776000

Oracle Databaseの場合のシステム変更番号(標準形式)。

例: 6488359
string

最小長: 3

最大長: 64

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

Oracle Databaseの場合のシステム変更番号(代替形式)。

例: 6488359.3456712

{
    "description":"Transaction start SCN",
    "x-oneOf":[
        {
            "description":"System Change Number(Normal Format) for Oracle Database.",
            "type":"integer",
            "minimum":"0",
            "maximum":"9223372036854776000",
            "example":"6488359"
        },
        {
            "description":"System Change Number(Alternate Format) for Oracle Database.",
            "type":"string",
            "pattern":"[0-9]+[.][0-9]+",
            "minLength":"3",
            "maxLength":"64",
            "example":"6488359.3456712"
        }
    ]
}

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

トランザクション開始SCN

1つに一致

ソースの表示

integer

最小値: 0

最大値: 9223372036854776000

Oracle Databaseの場合のシステム変更番号(標準形式)。

例: 6488359
string

最小長: 3

最大長: 64

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

Oracle Databaseの場合のシステム変更番号(代替形式)。

例: 6488359.3456712

{
    "description":"Transaction start SCN",
    "x-oneOf":[
        {
            "description":"System Change Number(Normal Format) for Oracle Database.",
            "type":"integer",
            "minimum":"0",
            "maximum":"9223372036854776000",
            "example":"6488359"
        },
        {
            "description":"System Change Number(Alternate Format) for Oracle Database.",
            "type":"string",
            "pattern":"[0-9]+[.][0-9]+",
            "minLength":"3",
            "maxLength":"64",
            "example":"6488359.3456712"
        }
    ]
}

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

{
    "$schema":"api:standardResponse",
    "links":[
        {
            "href":"http://localhost:9012/services/v2/connections/DBNORTH/activeTransactions",
            "mediaType":"application/json",
            "rel":"canonical"
        },
        {
            "href":"http://localhost:9012/services/v2/connections/DBNORTH/activeTransactions",
            "mediaType":"application/json",
            "rel":"self"
        },
        {
            "href":"http://localhost:9012/services/v2/metadata-catalog/activeTransactions",
            "mediaType":"application/schema+json",
            "rel":"describedby"
        }
    ],
    "messages":[
    ],
    "response":{
        "$schema":"ogg:activeTransactions",
        "activeTransactions":[
        ],
        "currentScn":{
            "csn":"2102694",
            "currentDate":"2024-04-03T22:36:17.000Z",
            "userName":"SYS"
        }
    }
}

先頭に戻る