Oracle: db locks with session and serial



select b.inst_id, 'alter system kill session ''' || b.sid || ',' || b.serial# || ''';' from gv$locked_object a , gv$session b, dba_objects c where b.sid = a.session_id and a.object_id = c.object_id;

No comments:

Post a Comment