Database Tuning (MOSC)

MOSC Banner

Questions About v$enqueue_lock

edited Jan 23, 2012 10:56AM in Database Tuning (MOSC) 2 commentsAnswered
Hi DBAs:

Today I resolved an RMAN problem using the query below. I found it in Note 1018679.102, but it is also in a few other places:

SELECT s.inst_id, l.id1, l.id2, s.sid, username AS "User", program, l.type, module, action, logon_time "Logon", l.*
  FROM v$session s,v$enqueue_lock l
WHERE l.sid = s.sid and l.type = 'CF'
AND l.id1 = 0 and l.id2 = 2;

I am updating my notes and would like to better understand what v$enqueue_lock.ID1 and v$enqueue_lock.ID2 mean.  The documentation I have found repeats:

ID1 NUMBER Lock identifier #1 (depends on type)

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