Library Cache waiting on inexistent object
Hi all,
on Oracle Database 19c Enterprise Edition Release 19.7.0.0.0 I'm investigating on a library cache lock and have this query result:
Objects locked by Library Cache based on sessions detected above
select to_char(SESSION_ID,'99999') sid ,
substr(LOCK_TYPE,1,40) Type,
substr(lock_id1,1,43) Object_Name,
substr(mode_held,1,4) HELD, substr(mode_requested,1,4) REQ,
lock_id2 Lock_addr
from dba_lock_internal
where
mode_requested<>'None'
and mode_requested<>mode_held
and session_id in ( select sid
from v\$session_wait where wait_time=0
and event like '%library cache%') ;
SID TYPE OBJECT_NAME HELD REQ LOCK_ADDR