Oracle Desk
Stuff that is happening at my orcl
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
Home
Subscribe to:
Posts (Atom)
No comments:
Post a Comment