We can use the below query to find the trace enabled at DB level.



ALTER SESSION SET NLS_LANGUAGE = 'AMERICAN';


 Select user_concurrent_program_name
from applsys.fnd_concurrent_programs fp,
applsys.fnd_concurrent_programs_tl fct
where fp.concurrent_program_id = fct.concurrent_program_id
and enable_trace <> 'N';



SELECT A.CONCURRENT_PROGRAM_NAME "Program Name",
SUBSTR(A.USER_CONCURRENT_PROGRAM_NAME,1,40) "User Program Name",
SUBSTR(B.USER_NAME,1,15) "Last Updated By",
SUBSTR(B.DESCRIPTION,1,25) DESCRIPTION
FROM APPS.FND_CONCURRENT_PROGRAMS_VL A, APPLSYS.FND_USER B
WHERE A.ENABLE_TRACE='Y'
AND A.LAST_UPDATED_BY=B.USER_ID;


Find All Programs Traced Recently

SELECT request_id, program.application_short_name,
cp.concurrent_program_name, cp.user_concurrent_program_name,
fcr.trace_enabled, fcr.trace_id, fcr.trace_filename, fcr.logfile_name
FROM fnd_concurrent_requests fcr
JOIN fnd_concurrent_programs cp ON fcr.concurrent_program_id = cp.concurrent_program_id
JOIN fnd_application program ON cp.application_id = program.application_id
WHERE fcr.request_date > SYSDATE - 1
AND fcr.trace_enabled = 'Y';