REST APIs for Oracle Database

Get a session locks that is blocking other sessions

get

/database/monitoring/session_locks/holding/{session_id},{lock_id1},{lock_id2}

Using DBA_LOCKS and DBA_BLOCKERS views, this service returns a speciic DBA_LOCKS record where the session is not waiting for a locked object but is holding a lock on an object for which another session is waiting. In an Oracle RAC environment, this only applies if the blocker is on the same instance.

Request

Supported Media Types

application/json

Path Parameters

lock_id1: string

Type-specific lock identifier, part 1.
lock_id2: string

Type-specific lock identifier, part 2.
session_id: number

Session identifier.

Response

Supported Media Types

application/json

200 Response

Information on a specific session lock.

Root Schema : ResourceItem

Type: object

Additional Properties Allowed: true

Show Source

links(optional): array links

{
    "type":"object",
    "additionalProperties":true,
    "properties":{
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/LinkRelation"
            }
        }
    }
}

Nested Schema : links

Type: array

Show Source

Array of: object LinkRelation

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/LinkRelation"
    }
}

Nested Schema : LinkRelation

Type: object

Show Source

href: string
rel: string

{
    "type":"object",
    "properties":{
        "rel":{
            "type":"string"
        },
        "href":{
            "type":"string"
        }
    },
    "required":[
        "rel",
        "href"
    ]
}