?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
- 특정 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;
예전에 효인선생님한테 받았음 아주 유용하게 잘썼어요.
http://youngcow.net/doc/oracle10g/appdev.102/b14258/u_encode.htm#i1000187

자바스크립트에서 인코딩한것을 디코딩할때 찾아썼음...
oraclesetup.txt
sql 기본적인 사용법입니다.

참고용으로 좋습니다.

+ Recent posts

티스토리툴바