DBA Hub

📋Steps in this guide1/1

Objects locked by library cache

select to_char(SESSION_ID,'999') sid , substr(LOCK_TYPE,1,30) Type, substr(lock_id1,1,23) 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_requestedmode_held and session_id in ( select sid from v$session_wait where wait_time=0 and event like '%library cache%') ;

oracle configurationintermediate
by OracleDba
15 views
1

Objects locked by library cache

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
select to_char(SESSION_ID,'999') sid ,
substr(LOCK_TYPE,1,30) Type,
substr(lock_id1,1,23) 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_requestedmode_held
and session_id in ( select sid
from v$session_wait where wait_time=0
and event like '%library cache%') ;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!