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.
No comments:
Post a Comment