跟踪并发请求

-- 跟踪并发请求

select request_id, argument_text, v.REQUESTED_BY, v.REQUESTOR, v.*

  from apps.fnd_conc_req_summary_v v

 where 1 =1 

   and program_short_name = 'CUXTCREP'

   -- and v.REQUEST_DATE > to_date('2014-01-13', 'yyyy-mm-dd')

   and v.STATUS_CODE = 'R';

   

   

-- 跟踪并发请求的session

SELECT t.sid, t.SERIAL#, s.sql_text

    , 'ALTER system kill session ''' || t.sid || ',' || t.serial# || ''''

  FROM v$session t

       , v$sql  s

 WHERE s.SQL_ID = t.SQL_ID

       and t.audsid = (SELECT r.oracle_session_id

           FROM apps.fnd_concurrent_requests r

          WHERE r.request_id = 1246776 /*&request_id*/ );

 

ALTER system kill session '1171,46839';

-- CREATE GLOBAL TEMPORARY TABLE CUX.CUX_SYNC_HOLD_ORDER_TMP(ORDER_HEADER_ID NUMBER,VERSION_NUM NUMBER)ON   COMMIT   PRESERVE   ROWS ;

 

select 'kill -9 '||vp.spid,vs.logon_time,vs.sid,vs.serial#,

vs.action ,fcr.ARGUMENT_TEXT

from v$process vp,v$session vs,fnd_concurrent_requests fcr

where vp.addr=vs.paddr

and fcr.oracle_process_id = vp.spid

and fcr.oracle_session_id = vs.audsid

and fcr.os_process_id =vs.process 

and fcr.REQUEST_ID = 1775418

 

 

 

select * from fnd_conc_req_summary_v where request_id = 1775418;

 

select * from fnd_concurrent_programs c where c.concurrent_program_name = 'CUXLACRT'

select * from Fnd_Concurrent_Programs_Vl c where c.concurrent_program_name = 'CUXLACRT'

 

select * from FND_EXECUTABLES_FORM_V cC where upper(CC.EXECUTION_FILE_NAME) = 'CUX_GTT_COM_INVOICE_NEW_PKG%'