Where do concurrent request log files and output files go, Oracle 12.1 12.2
SELECT LOGFILE_NAME, OUTFILE_NAME ,a.request_date ,a.lfile_size/1024/1024 lfile ,a.ofile_size/1024/1024 ofile
,b.user_concurrent_program_name
from fnd_concurrent_requests a ,
fnd_concurrent_programs_vl b
where a.request_date between sysdate -4 and sysdate
and a.concurrent_program_id = b.concurrent_program_id
;
you forgot to link connect between the tables ..
ReplyDeleteand a.concurrent_program_id = b.concurrent_program_id