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

;

1 comment:

  1. you forgot to link connect between the tables ..
    and a.concurrent_program_id = b.concurrent_program_id

    ReplyDelete

2015@Bahaa Barghouti. Powered by Blogger.