REST APIs for Oracle Database

Get a specific lock that a session is waiting on

get

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

Using DBA_LOCKS and DBA_WAITERS views, this service returns the corresponding DBA_LOCKS records for session that is waiting on locks held by other sessions. In an Oracle RAC environment, this only applies if the waiter 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 lock that a session is waiting on.

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"
    ]
}