DBA_KGLLOCK lists all the locks and pins held on KGL objects (objects in the Kernel Generic Library cache).
| Column | Datatype | NULL | Description |
|---|---|---|---|
kgllkuse |
RAW(4) |
Address of the user session that holds the lock or pin | |
kgllkhdl |
RAW(4) |
Address of the handle for the KGL object | |
kgllkmod |
NUMBER |
Current mode of the lock or pin | |
kgllkreq |
NUMBER |
Mode in which the lock or pin was requested | |
kgllktype |
VARCHAR2(4) |
Whether this is a lock or a pin |