Purpose of Query
The purpose of this query is to check if any process is locking a schema
Applicable CAST Version
Release | Yes/No |
|---|---|
| 8.1.x |  |
| 8.0.x | |
| 7.3.x | |
Applicable RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server | |
| Microsoft SQL Server | |
| CSS2 | |
Query for CSS
select * from pg_locks
Query result example
"relation";12002;11069;;;"";;;;;"44/85673";6468;"AccessShareLock";t;t
Query result interpretation
It gives the ID of the process , lock type , date on which it was locked and Username
Notes/comments
Related Pages
