334 Sessions and locks

   335 ==================

   336 

   337 Select locked objects::

   338 

   339   select * from v$locked_object;

   340 

   341   select * from v$locked_object a, all_objects b

   342     where a.object_id = b.object_id;

   343 

   344   select b.owner, b.object_name, a.oracle_username, a.os_user_name

   345     from v$locked_object a, all_objects b

   346     where a.object_id = b.object_id;

   347 

   348   select

   349      c.owner,

   350      c.object_name,

   351      c.object_type,

   352      b.sid,

   353      b.serial#,

   354      b.status,

   355      b.osuser,

   356      b.machine

   357   from v$locked_object a, v$session b, dba_objects c

   358   where b.sid = a.session_id and a.object_id = c.object_id;

   359 

   360 Kill session::

   361 

   362   alter system kill session 'SID,SERIAL#';

   363   alter system kill session '361,565';

   364