Retrieve Active Transaction Details
get
/services/{version}/connections/{connection}/activeTransactions
Retrieve details of the active transactions for a database connection.
Request
Path Parameters
-
connection: string
Minimum Length:
1
Maximum Length:61
Pattern:^[a-zA-Z][a-zA-Z0-9_#$]{1,29}([.][a-zA-Z][a-zA-Z0-9_#$]{1,29})?$
Connection name. For each alias in the credential store, a connection with the name 'domain.alias' exists.
-
version: string
Oracle GoldenGate Service API version.
Allowed Values:[ "v2" ]
Response
Supported Media Types
- application/json
200 Response
Active transaction details retrieved.
Root Schema : Oracle GoldenGate Database Active Transaction Details
Type:
object
Title:
Show Source
Oracle GoldenGate Database Active Transaction Details
-
$schema(optional):
Allowed Values:
[ "ogg:activeTransactions" ]
-
activeTransactions(optional):
array activeTransactions
Minimum Number of Items:
0
Maximum Number of Items:32767
List of all active transactions -
currentScn:
object currentScn
Current database SCN details
Nested Schema : activeTransactions
Type:
array
Minimum Number of Items:
0
Maximum Number of Items:
32767
List of all active transactions
Show Source
Nested Schema : currentScn
Type:
object
Current database SCN details
Show Source
-
csn(optional):
csn
Transaction start SCN
-
currentDate(optional):
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])$
Start time of the transaction -
userName(optional):
string
Minimum Length:
1
Maximum Length:4096
Database username
Nested Schema : items
Type:
Show Source
object
-
instanceId:
integer
Minimum Value:
0
Maximum Value:4.294967295E9
Instance identifier -
logonTime:
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])$
Time of logon to the session -
osUser:
string
Minimum Length:
1
Maximum Length:30
Operating System client username -
serialNum:
integer
Minimum Value:
0
Maximum Value:4.294967295E9
Session Serial Number -
sessionStatus:
Allowed Values:
[ "ACTIVE", "IDLE", "INACTIVE", "KILLED", "CACHED", "SNIPED" ]
Status of transaction or a session -
sid:
integer
Minimum Value:
0
Maximum Value:4.294967295E9
Session identifier -
txnStartDate:
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])$
Start time of the transaction -
txnStartScn:
txnStartScn
Transaction start SCN
-
txnStatus:
Allowed Values:
[ "ACTIVE", "IDLE", "INACTIVE", "KILLED", "CACHED", "SNIPED" ]
Status of transaction or a session -
userName:
string
Minimum Length:
1
Maximum Length:4096
Oracle username
Example Response (application/json)
{
"$schema":"api:standardResponse",
"links":[
{
"href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/activeTransactions",
"mediaType":"application/json",
"rel":"canonical"
},
{
"href":"http://localhost:11001/services/v2/connections/OracleGoldenGate.oggadmin/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":[
{
"sessionStatus":"INACTIVE",
"txnStartDate":"2018-09-24T15:04:48.000Z",
"userName":"SYS",
"txnStatus":"ACTIVE",
"logonTime":"2018-09-24T15:04:30.000Z",
"serialNum":45918,
"txnStartScn":1533970,
"osUser":"oracle",
"instanceId":1,
"sid":1552
}
],
"currentScn":{
"csn":1534681,
"currentDate":"2018-09-24T15:08:56.000Z",
"userName":"SYS"
}
}
}