Your Doorstep to the Temple of Oracle

Oracle EBS

How to Kill Concurrent Request session ?

Posted by appsdba11i on March 12, 2011

How to Kill Concurrent Request session ?

Step 1 Mapping Concurrent request Id to Sid and serai# by using
following query

select v.request_id, s.sid,s.serial#,s.event,p.spid
from apps.fnd_conc_requests_form_v v,v$process p,v$session s
where v.request_id = ‘<enter request id>’
and v.oracle_process_id = p.spid(+)
and p.addr = s.paddr(+)

Step 2 Execute following command and supply output from query 1

SQL> alter system kill session ‘sid, serial#’

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: