杀掉一直处于 正在终止 状态的并发请求

SELECT pkg.name
,pkg.owner
,acc.sid
,ses.serial#
,ses.paddr
,prc.spid
,'ALTER SYSTEM KILL SESSION ''' || ses.sid || ',' || ses.serial# || ''';'
FROM v$db_object_cache pkg
,v$access acc
,v$session ses
,v$process prc
WHERE pkg.owner = acc.owner
AND pkg.name = acc.object
AND acc.sid = ses.sid
AND prc.addr = ses.paddr
AND pkg.owner = 'APPS'
AND pkg.locks != '0'
AND pkg.name = '&package_name';



update fnd_concurrent_requests
set status_code = 'X', phase_code = 'C'
where request_id = &your_request_id;

commit;