DBA Data[Home] [Help]

VIEW: SYS.V_$LIBCACHE_LOCKS

Source

View Text - Preformatted

select "TYPE","ADDR","HOLDING_USER_SESSION","HOLDING_SESSION","OBJECT_HANDLE","LOCK_HELD","REFCOUNT","MODE_HELD","MODE_REQUESTED","SAVEPOINT_NUMBER","CON_ID" from v$libcache_locks
View Text - HTML Formatted

SELECT "TYPE"
, "ADDR"
, "HOLDING_USER_SESSION"
, "HOLDING_SESSION"
, "OBJECT_HANDLE"
, "LOCK_HELD"
, "REFCOUNT"
, "MODE_HELD"
, "MODE_REQUESTED"
, "SAVEPOINT_NUMBER"
, "CON_ID"
FROM V$LIBCACHE_LOCKS