Tuesday, May 19, 2009

DBA_KGLLOCK

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

1To 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.

Oracle data dictionary views

Oracle dynamic performance views