How to Find Alert Log File Location in Oracle

In newer versions of Oracle Database it is not obvious where is the location of the alert file to investigate any potential issues.

The best way to find the Oracle alert file location is to use this query

select * 
from v$diag_info 
where NAME = 'Diag Trace';