ORACLE DBA

查詢request id
SELECT req.request_id, fcp.user_concurrent_program_name, usr.user_name, req.request_date, TRUNC(SYSDATE) - TRUNC(request_date) days, req.logfile_name, req.outfile_name FROM applsys.fnd_concurrent_requests req, apps.fnd_concurrent_programs_vl fcp, applsys.fnd_user usrWHERE req.concurrent_program_id = fcp.concurrent_program_id AND req.requested_by = usr.user_id AND fcp.user_concurrent_program_name LIKE 'Cost Manager%'ORDER BY fcp.user_concurrent_program_name