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