How to find concurrent program trace file location?
I had enabled concurrent program tracing. But not sure where the trace file location is. I find out the following query on the internet. I used it and changed the user_dump_dest in the query to diagnostic_dest since we have 11.2.0.3 version of database. But when I input the request id number, it returns no rows selected. Is there any other way I can find the trace file? Please advise. Thank you very much.
SELECT 'Request id: '||request_id ,
'Trace id: '||oracle_Process_id,
'Trace Flag: '||req.enable_trace,
'Trace Name: