| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 | 
 | 
| 
 | View PDF | 
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 |