DBA_KGLLOCK

Pls let me know which DBA view that I can join with dba_kgllock in order to find out which objects is/are pinned in the shared pool:

SQL> desc dba_kgllock

Name                                      Null?    Type

----------------------------------------- -------- ----------------------------

KGLLKUSE                                           RAW(8)

KGLLKHDL                                           RAW(8)

KGLLKMOD                                           NUMBER

KGLLKREQ                                           NUMBER

KGLLKTYPE                                          VARCHAR2(4)

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