oracle快速删除大表

-- 执行了15min，仍未出结果
select count(1) from  XXX_SUBSE_RATION_LIST;
-- 查询锁
SELECT l.session_id sid, s.serial#, l.locked_mode,l.oracle_username,
 
　　l.os_user_name,s.machine, s.terminal, o.object_name, s.logon_time
 
　　FROM v$locked_object l, all_objects o, v$session s
 
　　WHERE l.object_id = o.object_id
 
　　AND l.session_id = s.sid
 
　　ORDER BY sid, s.serial# ;
-- 删除锁表的任务
ALTER system KILL session '197,26765'; 
-- spid 20388  kill -9 20388
select spid, osuser, s.program from v$session s, v$process p 
where s.paddr = p.addr and s.sid =197;
-- http://blog.itpub.net/14663377/viewspace-1226186/
-- 50G的数据，1min左右删除完毕
truncate table XXX_SUBSE_RATION_LIST drop all storage;