Concurrent에서 Process 찾기
set lines 130 set pages 300 COL spid FORMAT A10 COL process FORMAT A10 col CONCURRENT_PROGRAM_NAME format a30 col short_NAME format a12
SELECT to_char(r.actual_completion_date,’mmdd HH24:MI:SS’) COMP_DT,REQUEST_ID, — PARENT_REQUEST_ID, ORACLE_PROCESS_ID “spid” , — OS_PROCESS_ID “process”, CONCURRENT_PROGRAM_NAME short_NAME, — substr(g.USER_CONCURRENT_PROGRAM_NAME,1,30) CONCURRENT_PROGRAM_NAME, r.phase_code,r.status_code,(r.actual_completion_date – r.actual_start_date)*1440*60 RUN_REC , (r.actual_start_date – r.requested_start_date)*1440*60 pen_rec FROM FND_CONCURRENT_REQUESTS R, FND_CONCURRENT_PROGRAMS B , fnd_concurrent_programs_tl g WHERE R.CONCURRENT_PROGRAM_ID = B.CONCURRENT_PROGRAM_ID AND R.PROGRAM_APPLICATION_ID = B.APPLICATION_ID and r.program_application_id = g.application_id and R.CONCURRENT_PROGRAM_ID = g.CONCURRENT_PROGRAM_ID and g.language=’KO’ AND CONCURRENT_PROGRAM_NAME = ‘WSHINTERFACE’ and to_char(r.actual_start_date,’yymmddhh24miss’) between ‘030826180000’ and ‘030827090000’ and to_char(r.actual_start_date,’yymmddhh24miss’) between ‘030826180000’ and ‘030827090000’ –and PARENT_REQUEST_ID =839044 order by RUN_REC
Comments