解决DDL死锁与job死锁常用语句

select session_id sid, owner, name, type,mode_held held, mode_requested request
from dba_ddl_locks where name='BPNEW'

select t.sid,t.serial# from v$session t 
where t.sid=17;

alter system kill session '17,449';

select a.username, a.sid,b.SQL_TEXT --, b.SQL_FULLTEXT
  from v$session a, v$sqlarea b 
where a.sql_address = b.address

set pagesize 100;
select 'alter system kill session ''' || sid ||',' || serial# || ''';' from v$session where sid in (select sid from dba_jobs_running);