Database Tuning (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center