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 |
Note:
1.To setup lock views such as dba_locks and dba_blockers, run $ORACLE_HOME/rdbms/admin/catblock.sql. The script creates dba_locks, dba_blockers, dba_kgllock, dba_lock (dba_locks is synonym for this), dba_lock_internal, dba_dml_locks, dba_ddl_locks and dba_waiters.