Check the Trace File from Oracle 10G/11G/12c Database.

Check the Trace File from Oracle 10G/11G/12c Database.

SELECT value
FROM   v$diag_info
WHERE  name = 'Default Trace File';