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

 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';