Jump to

• Request
• Response

Get all locks that are blocking other sessions

get

/database/monitoring/session_locks/holding/

Using DBA_LOCKS and DBA_BLOCKERS views, this service returns a list of DBA_LOCKS records 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. A client requires SQL Administrator role to invoke this service.

Request

Query Parameters

• limit: integer(int32)
  The maximum number of records to return.
• q:
  Filtering is the process of limiting a collection resource by using a per-request dynamic filter definition across multiple page resources, where each page contains a subset of items found in the complete collection. Filtering enables efficient traversal of large collections.

  Examples

  Select an example FilterCriteriaExample OrderByPropertyExample FilterAndOrderExample

There's no request body for this operation.

Back to Top

Response

Supported Media Types

• application/json

200 Response

All locks that are blocking other sessions.

Body ()

Root Schema : MonitoringSessionLocksHolding

Type: object

This collection represents database locks held by sessions that are blocking other sessions. The list of attributes may vary depending on database version.

Show Source

• count: integer
  Total number of records in the current response.
• hasMore: boolean
  Indicates if there are more records to be retrieved.
• items: array items
• limit: integer
  The actual page size limit on number of records applied by the server.
• links: array links
• offset: integer
  The actual index from which the item resources are returned.

{
    "type":"object",
    "description":"This collection represents database locks held by sessions that are blocking other sessions. The list of attributes may vary depending on database version.",
    "properties":{
        "items":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/MonitoringSessionLocksItem"
            }
        },
        "hasMore":{
            "type":"boolean",
            "description":"Indicates if there are more records to be retrieved."
        },
        "limit":{
            "type":"integer",
            "description":"The actual page size limit on number of records applied by the server."
        },
        "offset":{
            "type":"integer",
            "description":"The actual index from which the item resources are returned."
        },
        "count":{
            "type":"integer",
            "description":"Total number of records in the current response."
        },
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/LinkRelation"
            }
        }
    }
}

Nested Schema : items

Type: array

Show Source

• Array of: object MonitoringSessionLocksItem
  This object is represents a record on DBA_LOCK view. DBA_LOCK lists all locks or latches held in the database, and all outstanding requests for a lock or latch. The list of attributes may vary depending on database version.

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/MonitoringSessionLocksItem"
    }
}

Nested Schema : links

Type: array

Show Source

• Array of: object LinkRelation

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

Nested Schema : MonitoringSessionLocksItem

Type: object

This object is represents a record on DBA_LOCK view. DBA_LOCK lists all locks or latches held in the database, and all outstanding requests for a lock or latch. The list of attributes may vary depending on database version.

Show Source

• blocking_others: string
  Whether the lock is currently blocking others.
• con_id: integer
  The ID of the container to which the data pertains.
• last_convert: integer
  The last convert.
• links: array links
• lock_id1: string
  Type-specific lock identifier, part 1.
• lock_id2: string
  Type-specific lock identifier, part 2.
• lock_type: string
  Lock type.
• mode_held: string
  Lock mode.
• mode_requested: string
  Lock mode requested.
• session_id: integer
  Session holding or acquiring the lock.

{
    "type":"object",
    "description":"This object is represents a record on DBA_LOCK view. DBA_LOCK lists all locks or latches held in the database, and all outstanding requests for a lock or latch. The list of attributes may vary depending on database version.",
    "properties":{
        "session_id":{
            "type":"integer",
            "description":"Session holding or acquiring the lock."
        },
        "lock_type":{
            "type":"string",
            "description":"Lock type."
        },
        "mode_held":{
            "type":"string",
            "description":"Lock mode."
        },
        "mode_requested":{
            "type":"string",
            "description":"Lock mode requested."
        },
        "lock_id1":{
            "type":"string",
            "description":"Type-specific lock identifier, part 1."
        },
        "lock_id2":{
            "type":"string",
            "description":"Type-specific lock identifier, part 2."
        },
        "last_convert":{
            "type":"integer",
            "description":"The last convert."
        },
        "blocking_others":{
            "type":"string",
            "description":"Whether the lock is currently blocking others."
        },
        "con_id":{
            "type":"integer",
            "description":"The ID of the container to which the data pertains."
        },
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/components/schemas/LinkRelation"
            }
        }
    }
}

Nested Schema : links

Type: array

Show Source

• Array of: object LinkRelation

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

Nested Schema : LinkRelation

Type: object

Show Source

• href(required): string
• rel(required): string

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

Back to Top