'oracle ERP' 태그의 글 목록

oracle ERP

oracle erp 특정 Concurrent Program 수행정보 확인 Scripts 2009.01.08

oracle erp 특정 Concurrent Program 수행정보 확인 Scripts

2009. 1. 8. 17:14

- 특정 Concurrent Program 수행정보 확인 Scripts
-- 변수 설명 :CONCURRENT_PROGRAM_NAME
select fcr.REQUEST_ID,
  fcpv.CONCURRENT_PROGRAM_NAME,fcpv.USER_CONCURRENT_PROGRAM_NAME,
  fcr.REQUESTED_START_DATE,
  fcr.ACTUAL_START_DATE "Start Time",
  fcr.ACTUAL_COMPLETION_DATE "End Time",
  decode(fcr.ACTUAL_COMPLETION_DATE,null, round((sysdate-fcr.ACTUAL_START_DATE)*24*60*60),
  round((fcr.ACTUAL_COMPLETION_DATE-fcr.ACTUAL_START_DATE)*24*60*60)) "Runtime(Sec)",
  fcr.ARGUMENT_TEXT "Parameter",
  --fcr.REQUESTED_BY, 
  fu.user_name,  
  fu.description "Requestor", 
  fcr.RESUBMIT_INTERVAL||','||
  decode(RESUBMIT_INTERVAL_UNIT_CODE,'MINUTES','M','HOURS','H','DAYS','D','MONTHS','M',null)||','||
  decode(RESUBMIT_INTERVAL_TYPE_CODE,'START','S','END','E',null) "SCHEDULE",
  '*'||oracle_process_id||'*' "Trace",
  fcr.PHASE_CODE,
  fcr.STATUS_CODE
from fnd_concurrent_requests fcr,
fnd_concurrent_programs_vl fcpv,
fnd_user fu
where fcr.CONCURRENT_PROGRAM_ID=fcpv.CONCURRENT_PROGRAM_ID
--  and PHASE_CODE='C'
--  and STATUS_CODE='C'
and fcpv.CONCURRENT_PROGRAM_NAME='KVRC1010'
  and fu.user_id=fcr.REQUESTED_BY
order by REQUEST_ID desc;

예전에 효인선생님한테 받았음 아주 유용하게 잘썼어요.

PREV 1 NEXT

TOP을 쫓는 술래

oracle ERP

oracle erp 특정 Concurrent Program 수행정보 확인 Scripts

+ Recent posts

티스토리툴바