Multiple choice technology databases

Which view contains details about locked objects ?

  1. v$lock
  2. v$user_objects
  3. v$locked_object
  4. v$session
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

v$locked_object is the Oracle dynamic performance view that shows detailed information about locked objects in the database, including the session ID, object ID, and lock mode. v$lock provides general lock information but not specific object details, while v$session shows session information without object locking details.